/* ================================================================================ 档案代号:gbo_file 档案名称:部门可上线人数设定档 档案目的:依照不同部门设定最大上线数 上游档案: 下游档案: ============.========================.========================================== */ create table gbo_file ( gbo01 varchar2(10) NOT NULL, /*部门编号 */ gbo02 varchar2(1), /*限制部门上线人数 */ gbo03 number(10) /*可上线人数 */ ); create unique index gbo_pk on gbo_file (gbo01); alter table gbo_file add constraint gbo_pk primary key (gbo01) enable validate; grant select on gbo_file to public; grant index on gbo_file to public; grant update on gbo_file to public; grant delete on gbo_file to public; grant insert on gbo_file to public; |