/* ================================================================================ 档案代号:mmi_file 档案名称:工作性质档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table mmi_file ( mmi01 varchar2(2) NOT NULL, /*工作性质码 */ mmi02 varchar2(80), /*工作性质说明 */ mmi03 varchar2(1), /*区别 */ /*区别 1.工作性质 2.需求类别 */ mmiacti varchar2(1), /*资料有效码 */ mmiuser varchar2(10), /*资料所有者 */ /*系统维护 */ mmigrup varchar2(10), /*资料所有群 */ /*系统维护 */ mmimodu varchar2(10), /*资料更改者 */ /*系统维护 */ mmidate date /*最近修改日 */ /*系统维护 */ ); create unique index mmi_pk on mmi_file (mmi01); alter table mmi_file add constraint mmi_pk primary key (mmi01) enable validate; grant select on mmi_file to public; grant index on mmi_file to public; grant update on mmi_file to public; grant delete on mmi_file to public; grant insert on mmi_file to public; |