/* ================================================================================ 档案代号:tqi_file 档案名称:客户层级关系单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tqi_file ( tqi01 varchar2(10) NOT NULL, /*上级客户代码 */ tqi02 date, /*生效日期 */ tqi03 date, /*失效日期 */ tqiacti varchar2(1), /*有效码 */ tqiuser varchar2(10), /*资料所有者 */ tqigrup varchar2(10), /*资料所有部门 */ tqimodu varchar2(10), /*资料修改者 */ tqidate date /*最近修改日 */ ); create unique index tqi_pk on tqi_file (tqi01); alter table tqi_file add constraint tqi_pk primary key (tqi01) enable validate; grant select on tqi_file to public; grant index on tqi_file to public; grant update on tqi_file to public; grant delete on tqi_file to public; grant insert on tqi_file to public; |