CvsjMeZG

1CREATE TABLE if Not exists dds.S_ExtItem_PlateNumber (
2	ExtItem_id int Not null REFERENCES dds.H_ExtItem, 
3	PlateNumber string null, 
4	Actual_date datetime Not null, 
5	Load_date datetime Not null,  
6	Source_system_id int Not null ENCODING RLE, 
7	LAUNCH_ID int ENCODING RLE, 
8PRIMARY KEY (ExtItem_id , Actual_date  )) 
9ORDER BY ExtItem_id  ,Actual_date SEGMENTED BY HASH ( ExtItem_id) ALL NODES ;