/* ================================================================================ 档案代号:fja_file 档案名称:设备保修规模档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fja_file ( fja01 varchar2(2) NOT NULL, /*保修规模编号 */ fja02 varchar2(80), /*说明 */ fjaacti varchar2(1), /*资料有效码 */ fjauser varchar2(10), /*资料所有者 */ fjagrup varchar2(10), /*资料所有部门 */ fjamodu varchar2(10), /*最后修改人员 */ fjadate date /*最后修改日期 */ ); create unique index fja_pk on fja_file (fja01); alter table fja_file add constraint fja_pk primary key (fja01) enable validate; grant select on fja_file to public; grant index on fja_file to public; grant update on fja_file to public; grant delete on fja_file to public; grant insert on fja_file to public; |