/* ================================================================================ 档案代号:shg_file 档案名称:稼动效率资料单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table shg_file ( shg01 date NOT NULL, /*日期 */ shg02 varchar2(10) NOT NULL, /*员工编号 */ shg021 varchar2(10) NOT NULL, /*班别编号 */ shg03 number(5) NOT NULL, /*序号 */ shg04 varchar2(6), /*转稼原因 */ shg05 number(10,4), /*转稼工时 */ shg06 varchar2(16), /*工单号码 */ shg07 varchar2(10), /*制程代号 */ shg08 varchar2(40), /*料号 */ shg09 number(10,4), /*核准工时 */ shg10 varchar2(10), /*责任单位 */ shg11 varchar2(1), /*确认否 */ shgud01 varchar2(255), /*自订栏位-Textedit */ shgud02 varchar2(40), /*自订栏位-文字 */ shgud03 varchar2(40), /*自订栏位-文字 */ shgud04 varchar2(40), /*自订栏位-文字 */ shgud05 varchar2(40), /*自订栏位-文字 */ shgud06 varchar2(40), /*自订栏位-文字 */ shgud07 number(15,3), /*自订栏位-数值 */ shgud08 number(15,3), /*自订栏位-数值 */ shgud09 number(15,3), /*自订栏位-数值 */ shgud10 number(10), /*自订栏位-整数 */ shgud11 number(10), /*自订栏位-整数 */ shgud12 number(10), /*自订栏位-整数 */ shgud13 date, /*自订栏位-日期 */ shgud14 date, /*自订栏位-日期 */ shgud15 date /*自订栏位-日期 */ ); create unique index shg_pk on shg_file (shg01,shg02,shg021,shg03); alter table shg_file add constraint shg_pk primary key (shg01,shg02,shg021,shg03) enable validate; grant select on shg_file to public; grant index on shg_file to public; grant update on shg_file to public; grant delete on shg_file to public; grant insert on shg_file to public; |