/* ================================================================================ 档案代号:sge_file 档案名称:员工应投入工时档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table sge_file ( sge01 date NOT NULL, /*工作日期 */ sge02 varchar2(10) NOT NULL, /*员工编号 */ sge03 number(10,2), /*应投入工时 */ sgeacti varchar2(1), /*资料有效码 */ /*系统维护 */ sgeuser varchar2(10), /*资料所有者 */ /*系统维护 */ sgegrup varchar2(10), /*资料所有群 */ /*系统维护 */ sgemodu varchar2(10), /*资料更改者 */ /*系统维护 */ sgedate date /*最近修改日 */ /*系统维护 */ ); create unique index sge_pk on sge_file (sge01,sge02); alter table sge_file add constraint sge_pk primary key (sge01,sge02) enable validate; grant select on sge_file to public; grant index on sge_file to public; grant update on sge_file to public; grant delete on sge_file to public; grant insert on sge_file to public; |