/* ================================================================================ 档案代号:skn_file 档案名称:报工群组工单资料档 档案目的:报工群组工单资料单头档 上游档案: 下游档案: ============.========================.========================================== */ create table skn_file ( skn01 varchar2(16) DEFAULT '' NOT NULL, /*工单单号*/ skn02 varchar2(1) DEFAULT '' NOT NULL, /*审核码*/ sknacti varchar2(1), /*资料有效码 */ skndate date, /*资料修改日期 */ skngrup varchar2(10), /*资料所属群组 */ sknmodu varchar2(10), /*资料修改者 */ sknuser varchar2(10) /*资料使用者 */ ); create unique index skn_pk on skn_file (skn01); alter table skn_file add constraint skn_pk primary key (skn01) enable validate; grant select on skn_file to public; grant index on skn_file to public; grant update on skn_file to public; grant delete on skn_file to public; grant insert on skn_file to public; |