/*==============================================================*/
/* Table: DZSQ_KHD_AJ */
/*==============================================================*/
create table DZSQ_KHD_AJ (
ANJUANBH INT8 null,
ANJUANH CHAR(80) null,
ANJUANMC CHAR(80) null,
TIANXIEMS CHAR(4) null,
ANJUANLX CHAR(4) null,
SHENQINGBH INT8 null,
CHUANGJIANRQ DATE null,
ZHUCEDM CHAR(80) null,
ANJUANZT CHAR(4) null,
QIANMINGRQ DATE null,
ANJUANBBH CHAR(20) null,
ANJUANBLJ CHAR(255) null,
BEIZHU CHAR(255) null,
QIANMCN CHAR(50) null,
NEIBUBH CHAR(255) null,
FASONGRQ DATE null,
BAOID CHAR(50) null
);
comment on column DZSQ_KHD_AJ.ANJUANBH is
'案卷编号';
comment on column DZSQ_KHD_AJ.ANJUANH is
'案卷号';
comment on column DZSQ_KHD_AJ.ANJUANMC is
'案卷名称';
comment on column DZSQ_KHD_AJ.TIANXIEMS is
'填写模式 0:新申请 1:答复补正 2:主动提交 3:快捷事务';
comment on column DZSQ_KHD_AJ.ANJUANLX is
'案卷类型 0:新申请 2:中间文件';
comment on column DZSQ_KHD_AJ.SHENQINGBH is
'申请编号';
comment on column DZSQ_KHD_AJ.CHUANGJIANRQ is
'创建日期';
comment on column DZSQ_KHD_AJ.ZHUCEDM is
'注册代码';
comment on column DZSQ_KHD_AJ.ANJUANZT is
'案卷状态 0:编辑 1:待发送 2:发送成功 3:发送失败 4:服务器拒收 5:已删除 6:已收到回执';
comment on column DZSQ_KHD_AJ.QIANMINGRQ is
'签名日期';
comment on column DZSQ_KHD_AJ.ANJUANBBH is
'案卷包编号(ZIP)';
comment on column DZSQ_KHD_AJ.ANJUANBLJ is
'案卷包路径(ZIP)';
comment on column DZSQ_KHD_AJ.BEIZHU is
'备注';
comment on column DZSQ_KHD_AJ.QIANMCN is
'签名CN';
format like this is not support