/* ================================================================================ 档案代号:vbi_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vbi_file ( vbi01 varchar2(10) DEFAULT '' NOT NULL, /*工作站编号*/ vbi02 varchar2(10), /*存放位置 */ vbi03 varchar2(40), /*工作站名称 */ vbi04 varchar2(40), /*工作站描述 */ vbi05 number(9) /*cpt介面上的排序号 */ ); create unique index vbi_pk on vbi_file (vbi01); alter table vbi_file add constraint vbi_pk primary key (vbi01) enable validate; grant select on vbi_file to public; grant index on vbi_file to public; grant update on vbi_file to public; grant delete on vbi_file to public; grant insert on vbi_file to public; |