/* ================================================================================ 档案代号:fbi_file 档案名称:部门折旧费用科目档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fbi_file ( fbi01 varchar2(10) NOT NULL, /*部门代号 */ fbi02 varchar2(24), /*折旧费用科目编号 */ fbi03 varchar2(10) NOT NULL, /*资产类别 */ fbiacti varchar2(1), /*资料有效码 */ fbiuser varchar2(10), /*资料所有者 */ fbigrup varchar2(10), /*资料所有群 */ fbimodu varchar2(10), /*资料更改者 */ fbidate date, /*最近修改日 */ fbi021 varchar2(24) /*折旧费用科目编号二 */ ); create unique index fbi_pk on fbi_file (fbi01,fbi03); alter table fbi_file add constraint fbi_pk primary key (fbi01,fbi03) enable validate; grant select on fbi_file to public; grant index on fbi_file to public; grant update on fbi_file to public; grant delete on fbi_file to public; grant insert on fbi_file to public; |