/* ================================================================================ 档案代号:shp_file 档案名称:RUN CARD分割资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table shp_file ( shp01 varchar2(16) NOT NULL, /*分割单号 */ shp02 date, /*分割日期 */ shp03 varchar2(19), /*Run Card */ shp04 number(5), /*制程顺序 */ shp05 varchar2(6), /*作业编号 */ shp06 number(15,3), /*WIP 数量 */ shp07 varchar2(10), /*员工编号 */ shp08 varchar2(1), /*No Use */ shp09 varchar2(1), /*WIP数量 */ shp10 varchar2(1), /*No Use */ shpconf varchar2(1), /*确认码 */ shptime varchar2(5), /*分割时间 */ shpacti varchar2(1), /*资料有效码 */ shpuser varchar2(10), /*资料所有者 */ shpgrup varchar2(10), /*资料所有群 */ shpmodu varchar2(10), /*资料更改者 */ shpdate date /*最近修改日 */ ); create index shp_02 on shp_file (shp03); create unique index shp_pk on shp_file (shp01); alter table shp_file add constraint shp_pk primary key (shp01) enable validate; grant select on shp_file to public; grant index on shp_file to public; grant update on shp_file to public; grant delete on shp_file to public; grant insert on shp_file to public; |