/* ================================================================================ 档案代号:bgd_file 档案名称:等级本薪资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bgd_file ( bgd01 varchar2(10) NOT NULL, /*版本 */ bgd02 varchar2(10) NOT NULL, /*职等代号 */ bgd03 number(5) NOT NULL, /*职级代号 */ bgd04 number(20,6), /*标准本薪 */ bgd05 number(20,6), /*投保薪资 */ bgdacti varchar2(1), /*资料有效否 */ bgduser varchar2(10), /*资料所有者 */ bgdgrup varchar2(10), /*资料所有群 */ bgdmodu varchar2(10), /*资料更改者 */ bgddate date /*最近修改日 */ ); create unique index bgd_pk on bgd_file (bgd01,bgd02,bgd03); alter table bgd_file add constraint bgd_pk primary key (bgd01,bgd02,bgd03) enable validate; grant select on bgd_file to public; grant index on bgd_file to public; grant update on bgd_file to public; grant delete on bgd_file to public; grant insert on bgd_file to public; |