/* ================================================================================ 档案代号:vnc_file 档案名称:aps 加班资讯维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vnc_file ( vnc01 varchar2(10) DEFAULT '' NOT NULL, /*资源类别(0:机器 1:工作站)*/ vnc02 date DEFAULT sysdate NOT NULL, /*资源编号*/ vnc03 number(9) DEFAULT '0' NOT NULL, /*日期*/ vnc04 number(9), /*开始时间 */ vnc05 number(1) /*结束时间 */ ); create unique index vnc_pk on vnc_file (vnc01,vnc02,vnc03); alter table vnc_file add constraint vnc_pk primary key (vnc01,vnc02,vnc03) enable validate; grant select on vnc_file to public; grant index on vnc_file to public; grant update on vnc_file to public; grant delete on vnc_file to public; grant insert on vnc_file to public; |