/* ================================================================================ 档案代号:sgb_file 档案名称:异常除外代号档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table sgb_file ( sgb01 varchar2(6) NOT NULL, /*异常代号 */ sgb02 varchar2(1), /*No Use */ sgb03 varchar2(1), /*责任部门 */ sgb04 varchar2(10), /*属性 */ sgb05 varchar2(80), /*异常说明 */ sgb06 varchar2(24) /*会计科目 */ ); create unique index sgb_pk on sgb_file (sgb01); alter table sgb_file add constraint sgb_pk primary key (sgb01) enable validate; grant select on sgb_file to public; grant index on sgb_file to public; grant update on sgb_file to public; grant delete on sgb_file to public; grant insert on sgb_file to public; |