/* ================================================================================ 档案代号:pmw_file 档案名称:采购料件询价单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pmw_file ( pmw01 varchar2(16) NOT NULL, /*询价单号 */ pmw03 varchar2(10), /*供应厂商编号 */ pmw04 varchar2(4), /*交易币别 */ pmw06 date, /*询价日期 */ pmwacti varchar2(1), /*资料有效码 */ /*资料有效码(Y/N) */ pmwuser varchar2(10), /*资料所有者 */ pmwgrup varchar2(10), /*资料所有部门 */ pmwmodu varchar2(10), /*资料修改者 */ pmwdate date, /*最近修改日 */ pmw05 varchar2(4), /*税别 */ pmw051 number(9,4) /*税率 */ ); create unique index pmw_pk on pmw_file (pmw01); alter table pmw_file add constraint pmw_pk primary key (pmw01) enable validate; grant select on pmw_file to public; grant index on pmw_file to public; grant update on pmw_file to public; grant delete on pmw_file to public; grant insert on pmw_file to public; |