/* ================================================================================ 档案代号:tqf_file 档案名称:通路关系单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tqf_file ( tqf01 varchar2(10) NOT NULL, /*上级通路代码 */ tqf02 date, /*生效日期 */ tqf03 date, /*失效日期 */ tqfacti varchar2(1), /*资料有效否 */ tqfuser varchar2(10), /*资料所有者 */ tqfgrup varchar2(10), /*资料所有群 */ tqfmodu varchar2(10), /*资料修改者 */ tqfdate date /*最近修改日期 */ ); create unique index tqf_pk on tqf_file (tqf01); alter table tqf_file add constraint tqf_pk primary key (tqf01) enable validate; grant select on tqf_file to public; grant index on tqf_file to public; grant update on tqf_file to public; grant delete on tqf_file to public; grant insert on tqf_file to public; |