/* ================================================================================ 档案代号:zw_file 档案名称:权限类别档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zw_file ( zw01 varchar2(10) NOT NULL, /*权限类别 */ zw02 varchar2(80), /*权限说明 */ zw03 varchar2(10), /*使用目录编号 */ zw04 varchar2(1), /*test */ zw05 varchar2(1), /*闲置处理 */ zw06 number(5), /*闲置时间(秒) */ zwacti varchar2(1), /*Active flag */ zwuser varchar2(10), /*OWNER */ zwgrup varchar2(10), /*GROUP */ zwmodu varchar2(10), /*MODIFY USER */ zwdate date /*MODIFY DATE */ ); create unique index zw_pk on zw_file (zw01); alter table zw_file add constraint zw_pk primary key (zw01) enable validate; grant select on zw_file to public; grant index on zw_file to public; grant update on zw_file to public; grant delete on zw_file to public; grant insert on zw_file to public; |