/* ================================================================================ 档案代号:trw_file 档案名称:员工工种资料 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table trw_file ( trw01 varchar2(6) NOT NULL, /*工种代号 */ trw02 varchar2(80), /*说明 */ trwacti varchar2(1), /*资料有效否 */ trwuser varchar2(10), /*资料所有者 */ trwgrup varchar2(10), /*资料所有部门 */ trwmodu varchar2(10), /*资料更改者 */ trwdate date /*最近修改日 */ ); create unique index trw_pk on trw_file (trw01); alter table trw_file add constraint trw_pk primary key (trw01) enable validate; grant select on trw_file to public; grant index on trw_file to public; grant update on trw_file to public; grant delete on trw_file to public; grant insert on trw_file to public; |