/* ================================================================================ 档案代号:gih_file 档案名称:采购预算档 (单头) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gih_file ( gih01 varchar2(6) NOT NULL, /*预测编号 */ gih02 varchar2(1) NOT NULL, /*类别 */ /*类别 1:外购料 2:内购料 */ gih03 varchar2(10) NOT NULL, /*部门编号 */ /*部门编号 (输入 '*' 表示全部) */ gihacti varchar2(1), /*资料有效码 */ gihuser varchar2(10), /*资料所有者 */ gihgrup varchar2(10), /*资料所有部门 */ gihmodu varchar2(10), /*资料修改者 */ gihdate date /*最近修改日 */ ); create index gih_02 on gih_file (gih01); create unique index gih_pk on gih_file (gih01,gih02,gih03); alter table gih_file add constraint gih_pk primary key (gih01,gih02,gih03) enable validate; grant select on gih_file to public; grant index on gih_file to public; grant update on gih_file to public; grant delete on gih_file to public; grant insert on gih_file to public; |