/* ================================================================================ 档案代号:tqj_file 档案名称:客户层级关系单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tqj_file ( tqj01 varchar2(10) NOT NULL, /*上级客户代码 */ tqj02 number(5) NOT NULL, /*项次 */ tqj03 varchar2(10) NOT NULL, /*下级客户代码 */ tqj04 date, /*生效日期 */ tqj05 date /*失效日期 */ ); create unique index tqj_pk on tqj_file (tqj01,tqj02); alter table tqj_file add constraint tqj_pk primary key (tqj01,tqj02) enable validate; grant select on tqj_file to public; grant index on tqj_file to public; grant update on tqj_file to public; grant delete on tqj_file to public; grant insert on tqj_file to public; |