/* ================================================================================ 档案代号:fjh_file 档案名称:设备系统单据性质档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fjh_file ( fjhslip varchar2(5) NOT NULL, /*单别 */ fjhdesc varchar2(80), /*单据名称 */ fjhauno varchar2(1), /*自动编号否 (y/n) */ fjhkind varchar2(1), /*编号方式 */ fjhconf varchar2(1), /*立即确认 */ fjhprit varchar2(1), /*立即列印 */ fjhtype varchar2(2), /*单据性质 */ /* 01.设备工单 02.设备检查单 */ /* 03.设备发料单 04.设备退料单 */ fjhacti varchar2(1), /*资料有效码 */ fjhuser varchar2(10), /*资料所有者 */ fjhgrup varchar2(10), /*资料所有部门 */ fjhmodu varchar2(10), /*资料修改者 */ fjhdate date /*最近修改日 */ ); create unique index fjh_pk on fjh_file (fjhslip); alter table fjh_file add constraint fjh_pk primary key (fjhslip) enable validate; grant select on fjh_file to public; grant index on fjh_file to public; grant update on fjh_file to public; grant delete on fjh_file to public; grant insert on fjh_file to public; |