执法案件管理系统-数据库设计

执法案件管理系统

数据库设计河南拓普网络计算机工程有限公司河南拓普网络计算机工程有限公司河南拓普网络计算机工程有限公司目录TOC\o"1-5"\h\z执法案件管理系统1数据库设计11.引言41.1.编写此文档目的42.命名42.1语言42.2大小写42.3单词分隔42.4保留字42.5命名长度52.6字段名称53.命名规范53.1命名规范概述53.2具体业务表名命名情况54.数据库设计64.1案件信息64.2立（销）案申请74.3终结报告/处罚决定94.4不予处罚信息104.5执法反馈信息114.6移送案件134.7简易处罚144.8案件延期信息154.9送达回证164.10强制执行164.11结案信息174.12案卷归档184.13事项审批184.14赔偿信息194.15诉讼情况204.16告知结果信息224.17复议登记信息224.18中止复议审理241.引言1.1.编写此文档目的此文档主要是指导开发人员进行系统开发，指导实施人员对执法案件管理系统数据库结构有一定的了解，指导数据库人员可以对执法案件管理系统的数据库表结构有一定的认识和应用。2.命名2.1语言命名使用能表述对象意义的汉语名词简拼或者约定俗成的符号，不允许使用中文或者特殊字符，对象名重名时，加类型前缀以示区别。2.2大小写名称全部大写，以方便不同数据库移植，规避各种数据库不同的命名规则。2.3单词分隔命名的各单词之间使用下划线进行分隔。2.4保留字命名禁止使用数据库保留字。2.5命名长度限制在30个字符内（含前缀）。2.6字段名称同一个字段名在一个数据库中只能代表一个意思。不同的表用于相同内容的字段应该采用同样的名称、字段类型定义。命名规范3.1命名规范概述项目名称命名规范表名由刖缀和名称两部分组成，刖缀为业务模块的拼音缩写，名称采用中文名称的拼音缩写，中间用“”分割。字段名名称米用中文名称的拼音缩写，字段名称必须用字母开头，字段中含有的字母必须是大写字母。索引由刖缀和名称两部分组成，刖缀是INDEX_,名称是表名+字段名，如果复合索引的构成字段较多，则只包含第一个字段名视图由刖缀和名称两部分组成，刖缀是v_,名称是业务操作名称的拼音缩写。存储过程由刖缀和名称两部分组成，刖缀是P_，名称是业务操作名称的拼音缩写。包由刖缀和名称两部分组成，刖缀是PKG_，名称是业务模块名称的拼音缩写。序列由刖缀和名称两部分组成，刖缀是SEQ_，名称是业务模块名称的拼音缩写。3.2具体业务表名命名情况行政执法执法拼音缩写（LAW_）为前缀，后跟各业务表的拼音缩写国标代码代码拼音缩写（CODE_）为前缀，后跟各国标表的拼音缩写

数据库设计4.1案件信息PhysicalProperty(s)of"LAWCaseInfo"Table描述案件信息字段(s)of"'LAWCASEINFO"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASENO案件编号VARCHAR(50)NoNULLNoCASENAME案件名称VARCHAR(255)NoNOTNULLNoCASESOU发现途径代码CHAR(2)NoNULLNoLIMDATE办案期限止日期TIMESTAMPNoNULLNoCASEVAL涉案金额DECIMAL(18,6)NoNULLNoCLUECON描述VARCHAR(4000)NoNULLNoSTATE状态VARCHAR(2)NoNOTNULLNoCASESTATE当前案件状态VARCHAR(2)NoNULLNoREGDATE受理日期TIMESTAMPNoNOTNULLNoMODDATE操作日期TIMESTAMPNoNULLNoPERID受理人BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNULLNoMARPRID企业标识BIGINTNoNULLNoBUSID业务标识VARCHAR(50)NoNULLNoCASEAPPRORGID案源审核机关标识BIGINTNoNULLNoPROERNAME提供者姓名（名称）VARCHAR(200)NoNOTNULLNoPROERAGE提供者年龄INTEGERNoNULLNoPROERSEX提供者性别VARCHAR(1)NoNULLNoPROERDOM提供者住所（地址）VARCHAR(200)NoNULLNoPROERTEL提供者联系电话VARCHAR(50)NoNULLNoPROERCERNO提供者身份证号VARCHAR(18)NoNULLNoCASEAPPRDAT案源审核日期TIMESTAMPNoNULLNo

ECASEAPPRPERID案源审核人标识BIGINTNoNULLNoCASEAPPRJOBID案源审核职位标识BIGINTNoNULLNoNAME当事人姓名（名称）VARCHAR(200)NoNULLNoDOM当事人住所（经营场所）VARCHAR(200)NoNULLNoLEREP法定代表人或负责人VARCHAR(IOO)NoNULLNoTEL当事人联系电话VARCHAR(50)NoNULLNoAGE当事人年龄INTEGERNoNULLNoSEX当事人性别CHAR(1)NoNULLNoOCCUPATION当事人职业VARCHAR(255)NoNULLNoCERNO当事人身份证号（企业注册号）VARCHAR(50)NoNULLNoPOSTALCODE当事人邮政编码CHAR(6)NoNULLNoPARTYTYPE当事人类别VARCHAR(2)NoNULLNoADSIGN广告类案件标示true广告类案件,false非广告类案件SMALLINTNoNULLNoMYCASEIDcase模型标识BIGINTNoNULLNoISNAMED是否具名VARCHAR(2)NoNULLNoPROERLAWUNITS执法单位VARCHAR(90)NoNULLNoPROERTYPE投诉、申诉、举报人类型VARCHAR(2)NoNULLNoPROERLEREP法定代表人（负责人）VARCHAR(90)NoNULLNoPROERPOSTCODE邮政编码VARCHAR(6)NoNULLNo4.2立（销）案申请PhysicalProperty(s)of”LAWREGCASEAPPLY”Table描述立(销)案申请字段(s)of"LAWREGCASEAPPLY"Table

字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoMARPRID主体标识BIGINTNoNULLNoCASENAME案件名称VARCHAR(255)NoNOTNULLNoWRITTYPECODE文书种类VARCHAR(8)NoNOTNULLNoCASENO案件编号VARCHAR(50)NoNULLNoNAME当事人姓名（名称）VARCHAR(200)NoNULLNoDOM当事人住所（经营场所）VARCHAR(200)NoNULLNoLEREP法定代表人或负责人VARCHAR(IOO)NoNULLNoTEL当事人联系电话VARCHAR(50)NoNULLNoAGE当事人年龄INTEGERNoNULLNoSEX当事人性别CHAR(1)NoNULLNoOCCUPATION当事人职业VARCHAR(255)NoNULLNoCERTYPE证件类型CHAR(1)NoNULLNoCERNO当事人身份证号VARCHAR(50)NoNULLNoPOSTALCODE当事人邮政编码CHAR(6)NoNULLNoPARTYTYPE当事人类别VARCHAR(2)NoNULLNoILLENTTYPE违法主体类型VARCHAR(2)NoNULLNoCASESPOT案发地VARCHAR(255)NoNOTNULLNoCASESCEDISTRICT案发地所在行政区划CHAR(6)NoNULLNoCASETIME案发时间TIMESTAMPNoNULLNoCASESOU案件来源CHAR(2)NoNULLNoCLOCASEREA销案原因代码CHAR(1)NoNULLNoDESC描述VARCHAR(2000)NoNULLNoUNDERTAKER承办人VARCHAR(IOO)NoNULLNoMARK立销标志true立案,false销案SMALLINTNoNOTNULLNoADSIGN广告类案件标示true广告类案件,false非广告类案件SMALLINTNoNULLNoREGDATE录入日期TIMESTAMPNoNOTNULLNoPERID录入人标识BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoAPPRORGID立案审批机关标BIGINTNoNULLNo

识VERIFYORGID立案核审机关标识BIGINTNoNULLNoCASENOORGID案件编号机关标识BIGINTNoNULLNoJOBID职位标识BIGINTNoNOTNULLNoSTATE状态［工作流状态］VARCHAR(2)NoNOTNULLNoWORKUNIT当事人工作单位VARCHAR(IOO)NoNULLNoCASENOPERID案件编号人员标识BIGINTNoNULLNo4.3终结报告/处罚决定PhysicalProperty(s)of”LAWDISREP"Table描述终结报告/处罚决定字段(s)of"'LAWDISREP"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoWRITTYPECODE文书种类VARCHAR(8)NoNOTNULLNoINFDEED违法事实VARCHAR(9000)NoNULLNoPARTYINFACC当事人情况VARCHAR(2000)NoNULLNoPENBASIS处罚依据VARCHAR(4500)NoNULLNoPENDECISION处罚决定VARCHAR(4000)NoNULLNoMODADV签发意见VARCHAR(600)NoNULLNoPENAM罚款金额DECIMAL(18,6)NoNULLNoILLEGINCOME违法所得金额DECIMAL(18,6)NoNULLNoCASECOURSE案件经过VARCHAR(9000)NoNULLNoCASEKIND案件性质VARCHAR(1000)NoNULLNoCASECHR案件性质代码CHAR(1)NoNULLNo

CASEVAL涉案金额DECIMAL(18,6)NoNULLNoILLEGACTTYPE违法行为种类代码VARCHAR(6)NoNULLNoOTHILLEGACTTYPE其它违法行为种类VARCHAR(90)NoNULLNoFORFAM没收违法所得金额DECIMAL(18,6)NoNULLNoAPPRCURAM变价金额DECIMAL(18,6)NoNULLNoPENTYPE处罚种类VARCHAR(IOO)NoNULLNoPENRESULT处罚结果代码VARCHAR(IOO)NoNULLNoREMARK备注VARCHAR(1000)NoNULLNoLAWITEMCODE法律法规及条款代码VARCHAR(4)NoNULLNoPENDECISSDATE录入日期（签发日期）TIMESTAMPNoNOTNULLNoEXEDATE执行日期TIMESTAMPNoNULLNoPERID录入人标识BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNULLNoEXAMIORGID审查机关标识BIGINTNoNULLNoVERIFYORGID处罚决定核审机关标识BIGINTNoNULLNoAPPRORGID处罚决定审批机关标识BIGINTNoNULLNoENTITYPE实体类型VARCHAR(2)NoNOTNULLNoSTATE状态［工作流状态］VARCHAR(2)NoNOTNULLNoCASETYPE案件类型CHAR(1)NoNULLNoCASEREA列入典型案件原因CHAR(1)NoNULLNo4.4不予处罚信息PhysicalProperty(s)of”LAWDENYPUNINFO”Table描述不予处罚信息字段(s)of"LAWDENYPUNINFO"Table

字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoCASECOURSE案件经过VARCHAR(4000)NoNULLNoCASEKIND案件性质VARCHAR(1000)NoNULLNoREASON不予处罚原因VARCHAR(1000)NoNULLNoREGDATE录入日期TIMESTAMPNoNOTNULLNoPERID录入人标识BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoSTATE状态VARCHAR(2)NoNOTNULLNoEXAMIORGID审核机关标识BIGINTNoNULLNoAPPRORGID审查机关标识BIGINTNoNULLNoCASECHR案件性质代码CHAR(1)NoNULLNo4.5执法反馈信息PhysicalProperty(s)of”LAWCASEFEEDBACK”Table描述执法反馈信息字段(s)of"'LAWCASEFEEDBACK""Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoBUSTYPE业务来源类型VARCHAR(2)NoNULLNoBUSID业务标识BIGINTNoNULLNoCASEID案件标识BIGINTNoNOTNULLNoSTATE案件状态VARCHAR(2)NoNULLNoSTATENAME案件状态名称VARCHAR(50)NoNULLNoREASON原因VARCHAR(1000)NoNULLNoCLOCASEDATE销案日期TIMESTAMPNoNULLNoCLOCASEREA销案理由CHAR(1)NoNULLNoCLOCASEREANAME销案理由名称VARCHAR(100)NoNULLNoACCPTRANFAUTHTYPE受移送机关类别CHAR(3)NoNULLNoACCPTRANFAU受移送机关类别VARCHAR(100)NoNULLNo

THTYPENAME名称ACCPTRANFAUTH受移送机关VARCHAR(IOO)NoNULLNoTRANFREATYPE移送原因类别CHAR(1)NoNULLNoTRANFREATYPENAME移送原因类别名称VARCHAR(IOO)NoNULLNoTRANFREA移送原因VARCHAR(1000)NoNULLNoTRANFDATE移送日期TIMESTAMPNoNULLNoMARPRID企业标识BIGINTNoNULLNoNAME当事人姓名（名称）VARCHAR(200)NoNULLNoCERNO当事人身份证号（企业注册号）VARCHAR(50)NoNULLNoCASENO案件编号VARCHAR(IOO)NoNULLNoAPPPROCEDURE适用程序CHAR(1)NoNULLNoAPPPRONAME适用程序名称VARCHAR(20)NoNULLNoCASEFIDATE立案日期TIMESTAMPNoNULLNoCASEENDDATE结案日期TIMESTAMPNoNULLNoCASEVAL案值DECIMAL(18,6)NoNULLNoCASESCEDISTRICT案发地所在行政区划CHAR(6)NoNULLNoCASESCEDISNAME案发地所在行政区划名称VARCHAR(IOO)NoNULLNoCASESPOT案发地VARCHAR(255)NoNULLNoILLEGINCOME违法所得金额DECIMAL(18,6)NoNULLNoILLEGACTTYPE违法行为种类代码VARCHAR(6)NoNULLNoILLACTTYPENAME违法行为种类名称VARCHAR(300)NoNULLNoQUABASISCODE定性依据VARCHAR(6)NoNULLNoQUABASIS定性依据名称VARCHAR(200)NoNULLNoPENBASISCODE处罚依据VARCHAR(6)NoNULLNoPENBASIS处罚依据名称VARCHAR(200)NoNULLNoPENTYPE处罚种类VARCHAR(IOO)NoNULLNoPENTYPENAME处罚种类名称VARCHAR(500)NoNULLNoPENRESULT处罚结果代码VARCHAR(IOO)NoNULLNoPENRESNAME处罚结果名称VARCHAR(600)NoNULLNoPENAM罚款金额DECIMAL(18,6)NoNULLNoFORFAM没收金额DECIMAL(18,6)NoNULLNo

APPRCURAM变价金额DECIMAL(18,6)NoNULLNoCOMMEACO行政强制措施类型VARCHAR(IOO)NoNULLNoCOMMEACONAME行政强制措施类型名称VARCHAR(120)NoNULLNoPENWRITNO处罚决定书文号VARCHAR(IOO)NoNULLNoPENDECISSDATE处罚决定书签发日期TIMESTAMPNoNULLNoFEDBACSTA反馈状态VARCHAR(2)NoNULLNoORGID机构标识BIGINTNoNOTNULLNoPERID受理人标识BIGINTNoNOTNULLNoREGDATE创建日期TIMESTAMPNoNOTNULLNoORGNODE机构节点代码VARCHAR(10)NoNULLNoCASERES案件结果VARCHAR(1)NoNULLNoCASETYPE案件类型VARCHAR(1)NoNULLNoFILENO档案编号VARCHAR(50)NoNULLNoCASESTATE办案状态VARCHAR(2)NoNULLNo4.6移送案件PhysicalProperty(s)of”LAWMOVESENDCASE”Table描述移送案件字段(s)of"'LAWMOVESENDCASE"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoACCPTRANFAUTH移送机关VARCHAR(IOO)NoNULLNoTRANFREA移送原因VARCHAR(2000)NoNULLNoREMARK备注VARCHAR(1000)NoNULLNoTRANFDATE录入日期TIMESTAMPNoNOTNULLNoPERID录入人标识BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNOTNULLNoSTATE状态［工作流状态］VARCHAR(2)NoNOTNULLNo

TRANFREATYPE移送原因类别CHAR(l)NoNULLNoACCPTRANFAUTHTYPE受移送机关类别CHAR(3)NoNULLNoTRANFMANSUM移送司法机关人数INTEGERNoNULLNo4.7简易处罚PhysicalProperty(s)of”LAWDISPOSEEASY”Table描述简易处罚字段(s)of"'LAWDISPOSEEASY"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoPENTYPE处罚种类VARCHAR(500)NoNULLNoPENRESULT处罚结果代码VARCHAR(IOO)NoNULLNoPENAM罚款金额DECIMAL(18,6)NoNULLNoFORFAM没收金额DECIMAL(18,6)NoNULLNoCASEVAL涉案金额DECIMAL(18,6)NoNULLNoREDICLIMIT复议期（天）INTEGERNoNULLNoLAWSUITLIMIT诉讼期（天）INTEGERNoNULLNoREVAUTH复议机关VARCHAR(255)NoNULLNoLAWSUITCOURT管辖法院VARCHAR(255)NoNULLNoPAYTYPE缴纳方式VARCHAR(255)NoNULLNoPENBASIS处罚依据VARCHAR(255)NoNULLNoDISDATE违法日期TIMESTAMPNoNULLNoFILLWRITDATE处罚日期TIMESTAMPNoNULLNoTHEREPAYSIGN是否当场缴纳SMALLINTNoNULLNoNAME当事人/单位名称VARCHAR(IOO)NoNULLNoPARTYTYPE当事人类别VARCHAR(2)NoNULLNoLEREP法定代表人VARCHAR(300)NoNULLNoDOM经营地址VARCHAR(200)NoNULLNoCERTYPE证件类型CHAR(1)NoNULLNoCERNO证件号码VARCHAR(50)NoNULLNoCASESPOT违法行为发生地VARCHAR(255)NoNULLNoCASESOU违法行为发现途径CHAR(2)NoNULLNo

ILLEGACTTYPE违法行为种类VARCHAR(6)NoNULLNoILLEGACTEXTTYPE详细违法行为种类VARCHAR(IO)NoNULLNoLAWBASIS法规依据VARCHAR(255)NoNULLNoREGDATE录入日期TIMESTAMPNoNULLNoPERID录入人标识BIGINTNoNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNOTNULLNoSTATE状态［工作流状态］VARCHAR(255)NoNOTNULLNoGODANDSERCATE商品及服务类别VARCHAR(8)NoNULLNo4.8案件延期信息PhysicalProperty(s)of”LAWCASEPOSINFO”Table描述案件延期信息字段(s)of"LAWCASEPOSINFO"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoWRITTYPECODE文书种类VARCHAR(8)NoNULLNoLIMDATEOLD原办案期限止日期TIMESTAMPNoNULLNoLIMDATENEW新办案期限止日期TIMESTAMPNoNULLNoPOSREA延期原因VARCHAR(4000)NoNULLNoREMARK备注VARCHAR(2000)NoNULLNoREGDATE录入日期TIMESTAMPNoNOTNULLNoPERID录入人标识BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNOTNULLNoSTATE状态［工作流状态］VARCHAR(2)NoNOTNULLNo河南拓普网络计算机工程有限公司河南拓普网络计算机工程有限公司字段(s)of"LAWCOMPEXE"Table字段(s)of"LAWCOMPEXE"TableEXAMIORGID审查机关标识BIGINTNoNULLNoAPPRORGID审批机关标识BIGINTNoNULLNo4.9送达回证PhysicalProperty(s)of”LAWSENDCER”Table描述送达回证字段(s)of"'LAWSENDCER"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoNOTICEID通知书编号BIGINTNoNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoSERWRITNO文书种类VARCHAR(8)NoNOTNULLNoSERPER送达人VARCHAR(IOO)NoNULLNoSERTIME送达时间TIMESTAMPNoNULLNoSERSPOT送达地点VARCHAR(255)NoNULLNoWASSENDER受送达人VARCHAR(IOO)NoNULLNoSERFORM受送方式CHAR(1)NoNULLNoADDRE收件人VARCHAR(IOO)NoNULLNoEYEWITNESS见证人VARCHAR(IOO)NoNULLNoREMARK备注VARCHAR(255)NoNULLNoREGDATE录入日期TIMESTAMPNoNOTNULLNoPERID录入人标识BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNOTNULLNoSTATE状态［工作流状态］VARCHAR(2)NoNOTNULLNo4.10强制执行PhysicalProperty(s)of"LAWCOMPEXE"Table描述强制执行河南拓普网络计算机工程有限公司河南拓普网络计算机工程有限公司字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoWRITTYPECODE文书种类VARCHAR(8)NoNOTNULLNoACCCOURT受理法院VARCHAR(255)NoNULLNoDESC描述VARCHAR(255)NoNULLNoCOMPDATE强制时间TIMESTAMPNoNULLNoCOMPUSER强制下达人VARCHAR(255)NoNULLNoREGDATE录入日期TIMESTAMPNoNOTNULLNoPERID录入人标识BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNOTNULLNoSTATE状态［工作流状态］VARCHAR(2)NoNOTNULLNo4.11结案信息PhysicalProperty(s)of”LAWENDCASEINFO”Table描述结案信息字段(s)of"LAWENDCASEINFO"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoWRITTYPECODE文书种类VARCHAR(8)NoNULLNoFINEBREAKUP罚款是否完结SMALLINTNoNULLNoTYPCASESIGN是否公告典型违法案例SMALLINTNoNULLNoTYPTALKSIGN是否发布典型案例点评SMALLINTNoNULLNoPOSTCASESIGN是否发布提示公告SMALLINTNoNULLNoREMARK备注VARCHAR(255)NoNULLNoREGDATE录入日期TIMESTAMPNoNOTNULLNoPERID录入人标识BIGINTNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNo河南拓普网络计算机工程有限公司河南拓普网络计算机工程有限公司PhysicalProperty(s)of"LAWITEMAPPRINFOPhysicalProperty(s)of"LAWITEMAPPRINFO"TableJOBID职位标识BIGINTNoNULLNoSTATE状态［工作流状态］VARCHAR(2)NoNOTNULLNoFILENO档案编号VARCHAR(50)NoNULLNo4.12案卷归档PhysicalProperty(s)of""LAWLAWDOC”Table描述案卷归档字段(s)of"'LAWLAWDOC"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoCATALOG目录VARCHAR(1200)NoNULLNoDOCCONTENT案卷内容VARCHAR(1200)NoNULLNoPIGDATE归档日期TIMESTAMPNoNULLNoDOCNAME案卷名称VARCHAR(1200)NoNULLNoDOCNO案卷编号VARCHAR(90)NoNULLNoDOCTYPE案卷类别VARCHAR(2)NoNULLNoJOBID职位IdBIGINTNoNOTNULLNoORGID机构标识BIGINTNoNOTNULLNoPLACE存放位置VARCHAR(300)NoNULLNoKEEDATE保存年限TIMESTAMPNoNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoDOCSOURCE案卷资料VARCHAR(1500)NoNULLNoPERID用户IdBIGINTNoNOTNULLNo4.13事项审批描述河南拓普网络计算机工程有限公司河南拓普网络计算机工程有限公司事项审批字段(s)of"LAWITEMAPPRINFO"Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoBUSTYPECODE业务环节代码VARCHAR(2)NoNOTNULLNoWRITTYPECODE文书种类VARCHAR(8)NoNOTNULLNoEXAPRO审批事项CHAR(2)NoNULLNoACCORDING提请审批的理由及依据VARCHAR(4000)NoNULLNoREMARK备注VARCHAR(2000)NoNULLNoUNDTAKERID承办人标识BIGINTNoNOTNULLNoUNDTAKEDATE承办日期TIMESTAMPNoNOTNULLNoORGID机关标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNOTNULLNoSTATE状态［工作流状态］VARCHAR(2)NoNOTNULLNoVERIFYORGID核审机关标识BIGINTNoNULLNoAPPRORGID审批机关标识BIGINTNoNULLNo4.14赔偿信息PhysicalProperty(s)of"LAWAMEINFO"Table描述赔偿信息字段(s)of"'LAWAMEINFO"Table字段名中文名数据类型主键非空外键备注ID赔偿信息IdBIGINTYesNOTNULLNoNAME赔偿申请人（企业）名称VARCHAR(200)NoNOTNULLNoLEREP赔偿请求人法定代表人（负责人、投资人、执行合伙企业事务的合伙人）VARCHAR(IOO)NoNULLNoDOM赔偿请求人经营VARCHAR(200)NoNULLNo

地址CERNO赔偿请求人营业执照号码VARCHAR(50)NoNULLNoAPPLYORGID赔偿请求人机构IdBIGINTNoNULLNoAMEOBLAUTH赔偿义务机关IdBIGINTNoNOTNULLNoAMETR申请赔偿的事实经过VARCHAR(1000)NoNULLNoAMEREQ赔偿请求的具体内容VARCHAR(1000)NoNULLNoAMEREA申请赔偿的理由和根据VARCHAR(1000)NoNULLNoAPPDATE接到申请日期TIMESTAMPNoNOTNULLNoREGDATE登记日期TIMESTAMPNoNOTNULLNoPERID登记人IdBIGINTNoNOTNULLNoORGID登记机关IdBIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoJOBID职位标识BIGINTNoNULLNoNORSTATE正常状态VARCHAR(3)NoNOTNULLNoPENWRITNO行政处罚（处理）决定文号VARCHAR(1000)NoNULLNoADMDECDATE作出决定日期TIMESTAMPNoNULLNoOBEADMINACT具体行政行为VARCHAR(3000)NoNULLNoOBEADMINACTTYPE具体行政行为种类CHAR(2)NoNULLNoAPPAMEAM申请赔偿金额DECIMAL(19,6)NoNULLNoACCRESULE受理结果CHAR(1)NoNULLNoREASON受理理由VARCHAR(1000)NoNULLNoLAWBASIS法律法规依据VARCHAR(200)NoNULLNoAMEFORM赔偿方式CHAR(1)NoNULLNo4.15诉讼情况PhysicalProperty(s)of”LAWLAWSUIT”Table描述诉讼情况字段(s)of"LAWLAWSUIT"Table

字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoDOM原告住址VARCHAR(300)NoNULLNoAGE原告年龄INTEGERNoNULLNoNAME原告姓名VARCHAR(300)NoNULLNoTEL原告电话VARCHAR(30)NoNULLNoPOSTALCODE原告邮编CHAR(6)NoNULLNoSEX原告性别CHAR(1)NoNULLNoAGENTADDR诉讼代理人住址VARCHAR(300)NoNULLNoAGENTNAME诉讼代理人姓名VARCHAR(90)NoNULLNoAGENTTEL诉讼代理人电话VARCHAR(30)NoNULLNoAGENTPOSTCODE诉讼代理人邮编VARCHAR(30)NoNULLNoCONTENT诉讼内容VARCHAR(3000)NoNULLNoACCCOURT受理法院VARCHAR(300)NoNULLNoREGDATE创建时间TIMESTAMPNoNULLNoOBEADMINACT具体行政行为VARCHAR(3000)NoNULLNoADMDECNO行政处罚决定书文号VARCHAR(IOO)NoNULLNoDEFORGID被告机关BIGINTNoNOTNULLNoCOURTDATE开庭日期TIMESTAMPNoNULLNoCASEID案件标识BIGINTNoNULLNoJOBID职位IdBIGINTNoNOTNULLNoORGID机构标识BIGINTNoNOTNULLNoPRIORGID主管机关标识BIGINTNoNOTNULLNoREMARK备注VARCHAR(600)NoNULLNoJUDRESULT判决结果VARCHAR(1200)NoNULLNoLAWSUITRESCODE诉讼结果代码VARCHAR(2)NoNULLNoJUDDATE判决日期TIMESTAMPNoNULLNoACCDATE受理日期TIMESTAMPNoNULLNoPERID用户IdBIGINTNoNOTNULLNoOBEADMINACTTYPE具体行政行为种类CHAR(2)NoNULLNoADJUTYPE审判类型CHAR(1)NoNULLNoJUDAUTH审判机关VARCHAR(200)NoNULLNoJUDTYPE判决类型CHAR(2)NoNULLNoAPPETYPE被告类型CHAR(1)NoNULLNo

4.16告知结果信息PhysicalProperty(s)of"LAWN0TRESINF0”Table描述告知结果信息字段(s)of"'LAWN0TRESINF0”Table字段名中文名数据类型主键非空外键备注ID标识BIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNOTNULLNoNOTWAYCODE告知方式代码VARCHAR(2)NoNULLNoNOTCONTENT告知内容VARCHAR(1000)NoNULLNoNOTDATE告知时间TIMESTAMPNoNOTNULLNoWASNOTPER被告知人VARCHAR(IOO)NoNULLNoNOTPER告知人VARCHAR(IOO)NoNULLNoREMARK备注VARCHAR(1000)NoNULLNo4.17复议登记信息PhysicalProperty(s)of”LAWLAWSUIT”Table描述诉讼情况复议登记信息字段(s)of"'LAWREDISINFO"Table字段名中文名数据类型主键非空外键备注ID复议登记信息IdBIGINTYesNOTNULLNoCASEID案件标识BIGINTNoNULLNoENTNAME（企业）名称VARCHA