/* ================================================================================ 档案代号:ock_file 档案名称:客诉原因代码档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ock_file ( ock01 varchar2(6) NOT NULL, /*客诉原因代码 */ ock02 varchar2(80), /*原因说明 */ ockacti varchar2(1), /*资料有效码 */ ockuser varchar2(10), /*资料所有者 */ ockgrup varchar2(10), /*资料所有群 */ ockmodu varchar2(10), /*资料更改者 */ ockdate date /*最近修改日 */ ); create unique index ock_pk on ock_file (ock01); alter table ock_file add constraint ock_pk primary key (ock01) enable validate; grant select on ock_file to public; grant index on ock_file to public; grant update on ock_file to public; grant delete on ock_file to public; grant insert on ock_file to public; |