/* ================================================================================ 档案代号:tql_file 档案名称:客户类系列档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tql_file ( tql01 varchar2(10) NOT NULL, /*客户代号 */ tql02 number(5) NOT NULL, /*项次 */ tql03 varchar2(2) NOT NULL, /*代码类别 */ tql04 varchar2(10) /*代码代号 */ ); create unique index tql_pk on tql_file (tql01,tql02,tql03); alter table tql_file add constraint tql_pk primary key (tql01,tql02,tql03) enable validate; grant select on tql_file to public; grant index on tql_file to public; grant update on tql_file to public; grant delete on tql_file to public; grant insert on tql_file to public; |