/*
================================================================================
档案代号:cqw_file
档案名称:杂项扣缴人资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cqw_file
(
cqw01       varchar2(8) NOT NULL,    /*扣缴人代号                             */
cqw02       varchar2(30),            /*扣 缴 人                               */
cqw03       varchar2(20),            /*身份证号/统一编号                      */
cqw04       varchar2(13),            /*帐    号                               */
cqw05       varchar2(255),           /*户籍地址                               */
cqw06       varchar2(255)            /*地    址                               */
);

create unique index cqw_pk on cqw_file (cqw01);
alter table cqw_file add  constraint cqw_pk primary key  (cqw01) enable validate;
grant select on cqw_file to public;
grant index on cqw_file to public;
grant update on cqw_file to public;
grant delete on cqw_file to public;
grant insert on cqw_file to public;