/* ================================================================================ 档案代号:fje_file 档案名称:工单型态档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fje_file ( fje01 varchar2(4) NOT NULL, /*工单型态编号 */ fje02 varchar2(80), /*说明 */ fje03 varchar2(1), /*性质 */ /*1.维修 2.保养 */ fje04 varchar2(1), /*No Use */ fje05 varchar2(1), /*No Use */ fje06 varchar2(1), /*No Use */ fje07 varchar2(1), /*No Use */ fje08 varchar2(1), /*No Use */ fje09 varchar2(1), /*No Use */ fje10 varchar2(1) /*No Use */ ); create unique index fje_pk on fje_file (fje01); alter table fje_file add constraint fje_pk primary key (fje01) enable validate; grant select on fje_file to public; grant index on fje_file to public; grant update on fje_file to public; grant delete on fje_file to public; grant insert on fje_file to public; |