/* ================================================================================ 档案代号:obm_file 档案名称:运输方式档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table obm_file ( obm01 varchar2(10) NOT NULL, /*运输方式代码 */ obm02 varchar2(80), /*说明 */ obmacti varchar2(1), /*有效否 */ obmuser varchar2(10), /*建档人员 */ obmgrup varchar2(10), /*建档部门 */ obmmodu varchar2(10), /*最后修改人员 */ obmdate date /*最后修改日期 */ ); create unique index obm_pk on obm_file (obm01); alter table obm_file add constraint obm_pk primary key (obm01) enable validate; grant select on obm_file to public; grant index on obm_file to public; grant update on obm_file to public; grant delete on obm_file to public; grant insert on obm_file to public; |