/* ================================================================================ 档案代号:nmo_file 档案名称:票别说明档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nmo_file ( nmo01 varchar2(2) NOT NULL, /*票别 */ nmo02 varchar2(80), /*说明 */ nmoacti varchar2(1), /*有效码 */ nmouser varchar2(10), /*资料所有者 */ nmogrup varchar2(10), /*资料所有部门 */ nmomodu varchar2(10), /*资料修改者 */ nmodate date /*最近修改日 */ ); create unique index nmo_pk on nmo_file (nmo01); alter table nmo_file add constraint nmo_pk primary key (nmo01) enable validate; grant select on nmo_file to public; grant index on nmo_file to public; grant update on nmo_file to public; grant delete on nmo_file to public; grant insert on nmo_file to public; |