/* ================================================================================ 档案代号:fid_file 档案名称:作业资料单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fid_file ( fid01 varchar2(10) NOT NULL, /*作业编号 */ fid02 varchar2(80), /*说明 */ fid03 number(8,3), /*预备工时,单位小时 */ fid04 number(8,3), /*标准工时,单位小时 */ fid05 varchar2(1), /*No */ fid06 varchar2(1), /*No */ fid07 varchar2(1), /*No */ fid08 varchar2(1), /*No */ fid09 varchar2(1), /*No */ fid10 varchar2(1), /*No */ fidacti varchar2(1), /*资料有效码 */ fiduser varchar2(10), /*资料所有者 */ fidgrup varchar2(10), /*资料所有部门 */ fidmodu varchar2(10), /*最后修改人员 */ fiddate date /*最后修改日期 */ ); create unique index fid_pk on fid_file (fid01); alter table fid_file add constraint fid_pk primary key (fid01) enable validate; grant select on fid_file to public; grant index on fid_file to public; grant update on fid_file to public; grant delete on fid_file to public; grant insert on fid_file to public; |