/* ================================================================================ 档案代号:oqw_file 档案名称:生产地资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oqw_file ( oqw01 varchar2(10) NOT NULL, /*生产地编号 */ oqw02 varchar2(80), /*生产地名称 */ oqw03 varchar2(10), /*隶属国别编号 */ oqwacti varchar2(1), /*资料有效码 */ oqwuser varchar2(10), /*资料所有者 */ oqwgrup varchar2(10), /*资料所有部门 */ oqwmodu varchar2(10), /*资料修改者 */ oqwdate date /*最近修改日 */ ); create unique index oqw_pk on oqw_file (oqw01); alter table oqw_file add constraint oqw_pk primary key (oqw01) enable validate; grant select on oqw_file to public; grant index on oqw_file to public; grant update on oqw_file to public; grant delete on oqw_file to public; grant insert on oqw_file to public; |