执法局新数据库

波波2015

已于 2023-02-15 00:46:38 修改

阅读量180

点赞数

分类专栏： SQLServer 文章标签：数据库 java 服务器 Powered by 金山文档

于 2023-02-15 00:35:32 首次发布

本文链接：https://blog.csdn.net/gp574480143/article/details/129035932

版权

SQLServer 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_ajdczjbg

/****** Object: Table [dbo].[m_case_ajdczjbg] Script Date: 2023/2/15 0:32:56 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_ajdczjbg](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[BasicInfo] [varchar](200) NULL,

[BeginDate] [datetime] NULL,

[EndDate] [datetime] NULL,

[BasicCase] [varchar](2000) NULL,

[Evidence] [varchar](2000) NULL,

[Violated] [varchar](2000) NULL,

[LegalBasis] [varchar](2000) NULL,

[Penalty] [varchar](1000) NULL,

[Deal] [varchar](200) NULL,

[Upper] [varchar](50) NULL,

[Lower] [decimal](18, 2) NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_ajdczjbg_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_ajdczjbg] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'唯一ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'ID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_基本情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'BasicInfo'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_开始时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'BeginDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'EndDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_基本案情' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'BasicCase'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_违法证据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'Evidence'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_违反了' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'Violated'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_法律依据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'LegalBasis'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_处罚内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'Penalty'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_处理' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'Deal'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_罚款大写' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'Upper'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件调查终结报告_罚款小写' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'Lower'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'案件调查终结报告' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajdczjbg'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_ajjaspb

/****** Object: Table [dbo].[m_case_ajjaspb] Script Date: 2023/2/15 0:37:31 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_ajjaspb](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[Abstract] [varchar](2000) NULL,

[ExeResult] [varchar](200) NULL,

[Implement] [varchar](50) NULL,

[CBRYJ_IsAgree] [varchar](50) NULL,

[CBRYJ_Date] [datetime] NULL,

[CBJGSHYJ_IsAgree] [varchar](50) NULL,

[CBJGSHYJ_Reason] [varchar](200) NULL,

[CBJGSHYJ_Date] [datetime] NULL,

[FZJGYJ_IsAgree] [varchar](50) NULL,

[FZJGYJ_Date] [datetime] NULL,

[XZJGFZRSPYJ_IsAgree] [varchar](50) NULL,

[XZJGFZRSPYJ_Date] [datetime] NULL,

[AuditRoleID] [int] NULL CONSTRAINT [DF_m_case_ajjaspb_AuditRoleID] DEFAULT ((1)),

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_ajjaspb_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_ajjaspb] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_案情摘要' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'Abstract'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'执行结果' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'ExeResult'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_执行情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'Implement'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_办案人员意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'CBRYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_办案人员意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'CBRYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_承办机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_承办机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_承办机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_法制机构意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'FZJGYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_法制机构意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'FZJGYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_机关负责人意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_机关负责人意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件结案审批表_当前审核人职务ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'AuditRoleID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'案件结案审批表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajjaspb'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_ajysh

/****** Object: Table [dbo].[m_case_ajysh] Script Date: 2023/2/15 0:38:20 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_ajysh](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[MoveToName] [varchar](50) NULL,

[CauseAction] [varchar](200) NULL,

[IllegalAct] [varchar](2000) NULL,

[Reason] [varchar](200) NULL,

[Base] [varchar](200) NULL,

[Sheet] [varchar](500) NULL,

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_ajysh_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_ajysh] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送函_反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送函_移送机关名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'MoveToName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送函_案由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'CauseAction'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送函_违法情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'IllegalAct'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送函_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送函_根据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'Base'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送函_清单' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'Sheet'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送函_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'案件移送函' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysh'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_ajysspb

/****** Object: Table [dbo].[m_case_ajysspb] Script Date: 2023/2/15 0:38:45 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_ajysspb](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](500) NULL,

[Type] [varchar](20) NULL,

[Mechanism] [varchar](100) NULL,

[Brief] [varchar](500) NULL,

[Base] [varchar](500) NULL,

[CBRYJ] [varchar](100) NULL,

[CBRYJ_Date] [datetime] NULL,

[CBJGSHYJ_IsAgree] [varchar](50) NULL,

[CBJGSHYJ_Reason] [varchar](200) NULL,

[CBJGSHYJ_Date] [datetime] NULL,

[FZJGSHYJ_IsAgree] [varchar](50) NULL,

[FZJGSHYJ_Reason] [varchar](200) NULL,

[FZJGSHYJ_Date] [datetime] NULL,

[XZJGFZRSPYJ_IsAgree] [varchar](50) NULL,

[XZJGFZRSPYJ_Date] [datetime] NULL,

[AuditRoleID] [int] NULL CONSTRAINT [DF_m_case_ajysspb_AuditRoleID] DEFAULT ((1)),

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_ajysspb_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_ajysspb] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场照片拍摄说明反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'Type'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_受移送机关' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'Mechanism'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_简要案情' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'Brief'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_移送法律依据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'Base'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_承办人意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'CBRYJ'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_承办人意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'CBRYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_承办机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_承办机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_承办机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_法制机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_法制机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_法制机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_机关负责人审批意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_机关负责人审批意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件移送审批表_当前审核人职务ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'AuditRoleID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'案件移送审批表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_ajysspb'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_byfqjntzs

/****** Object: Table [dbo].[m_case_byfqjntzs] Script Date: 2023/2/15 0:39:13 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_byfqjntzs](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[SendDate] [datetime] NULL,

[PunishMoney] [varchar](50) NULL,

[DivideDate] [datetime] NULL,

[Reason] [varchar](200) NULL,

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_byfqjntzs_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_byfqjntzs] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'不予分期缴纳罚款通知书_反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'不予分期缴纳罚款通知书_送达时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'SendDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'不予分期缴纳罚款通知书_处罚金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'PunishMoney'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'不予分期缴纳罚款通知书_分期时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'DivideDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'不予分期缴纳罚款通知书_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'不予分期缴纳罚款通知书_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'不予分期缴纳通知书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_byfqjntzs'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_cssbtzfhyjs

/****** Object: Table [dbo].[m_case_cssbtzfhyjs] Script Date: 2023/2/15 0:39:50 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_cssbtzfhyjs](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[Type] [varchar](20) NULL,

[OriOpinion] [varchar](500) NULL,

[Fact] [varchar](500) NULL,

[NeedChange] [varchar](20) NULL,

[UndoProp] [varchar](20) NULL,

[HandleOpition] [varchar](500) NULL,

[CBRYJ] [varchar](500) NULL,

[CBRYJ_Date] [datetime] NULL,

[CBJGSHYJ_IsAgree] [varchar](50) NULL,

[CBJGSHYJ_Reason] [varchar](200) NULL,

[CBJGSHYJ_Date] [datetime] NULL,

[XZJGFZRSPYJ_IsAgree] [varchar](50) NULL,

[XZJGFZRSPYJ_Date] [datetime] NULL,

[AuditRoleID] [int] NULL CONSTRAINT [DF_m_case_cssbtzfhyjs_AuditRoleID] DEFAULT ((1)),

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_cssbtzfhyjs_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_cssbtzfhyjs] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'Type'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_原处理意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'OriOpinion'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_当事人提出的事实' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'Fact'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_是否需要变更' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'NeedChange'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_变更撤销属性' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'UndoProp'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_拟处理意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'HandleOpition'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_复核人意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'CBRYJ'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_复核人意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'CBRYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_承办机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_承办机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_承办机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_机关负责人审批意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_机关负责人审批意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'陈述申辩、听证复核意见书_当前审核人职务ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'AuditRoleID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'陈述申辩、听证复核意见书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_cssbtzfhyjs'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_dcxwtzs

/****** Object: Table [dbo].[m_case_dcxwtzs] Script Date: 2023/2/15 0:40:23 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_dcxwtzs](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](2000) NULL,

[CauseAction] [varchar](2000) NULL,

[NoticeDate] [datetime] NULL,

[OrganAddress] [varchar](2000) NULL,

[Other] [varchar](2000) NULL,

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_dcxwtzs_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_dcxwtzs] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调查（询问）通知书_反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调查（询问）通知书_案由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'CauseAction'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调查（询问）通知书_通知时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'NoticeDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调查（询问）通知书_机构地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'OrganAddress'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调查（询问）通知书_其他' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'Other'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调查（询问）通知书_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'调查（询问）通知书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_dcxwtzs'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_laspb

/****** Object: Table [dbo].[m_case_laspb] Script Date: 2023/2/15 0:41:02 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_laspb](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[CauseFromID] [int] NULL,

[Back] [varchar](2000) NULL,

[AJJYQK] [varchar](2000) NULL,

[CBRYJ_Date] [datetime] NULL,

[CBJGSHYJ_IsAgree] [varchar](2000) NULL,

[CBJGSHYJ_Reason] [varchar](2000) NULL,

[CBJGSHYJ_Date] [datetime] NULL,

[FZJGSHYJ_IsAgree] [varchar](2000) NULL,

[FZJGSHYJ_Date] [datetime] NULL,

[XZJGFZRSPYJ_IsAgree] [varchar](2000) NULL,

[XZJGFZRSPYJ_Date] [datetime] NULL,

[AuditRoleID] [int] NULL CONSTRAINT [DF_m_case_laspb_AuditRoleID] DEFAULT ((1)),

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_laspb_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_laspb] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件来源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'CauseFromID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'立案审批表反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件简要情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'AJJYQK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'承办人意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'CBRYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'承办机构审核意见_是否立案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'承办机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'承办机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法制机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法制机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政机关负责人审批意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政机关负责人审批意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'立案审批表_当前审核人职务ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'AuditRoleID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'立案审批表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_laspb'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_latzs

/****** Object: Table [dbo].[m_case_latzs] Script Date: 2023/2/15 0:41:31 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_latzs](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](2000) NULL,

[CauseAction] [varchar](2000) NULL,

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_latzs_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_latzs] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_latzs', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'立案通知书_反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_latzs', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'立案通知书_案由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_latzs', @level2type=N'COLUMN',@level2name=N'CauseAction'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'立案通知书_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_latzs', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_latzs', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_latzs', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'立案通知书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_latzs'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_tztzs

/****** Object: Table [dbo].[m_case_tztzs] Script Date: 2023/2/15 0:41:51 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_tztzs](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[TakeDate] [datetime] NULL,

[CauseAction] [varchar](200) NULL,

[HoldDate] [datetime] NULL,

[Address] [varchar](60) NULL,

[Secret] [varchar](10) NULL,

[Anchor] [varchar](10) NULL,

[Listener1] [varchar](10) NULL,

[Listener2] [varchar](10) NULL,

[Recorder] [varchar](10) NULL,

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_tztzs_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_tztzs] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_提出时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'TakeDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_案由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'CauseAction'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_举行时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'HoldDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_举行地点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'Address'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_公开/不公开' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'Secret'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_主持人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'Anchor'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_听证员1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'Listener1'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_听证员2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'Listener2'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_记录人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'Recorder'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'听证通知书_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'听证通知书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_tztzs'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_xczpjsm

/****** Object: Table [dbo].[m_case_xczpjsm] Script Date: 2023/2/15 0:42:24 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_xczpjsm](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](500) NULL,

[Arrange] [int] NULL CONSTRAINT [DF_m_case_xczpjsm_T11_Arrange] DEFAULT ((0)),

[PhotoContext] [varchar](2000) NULL,

[PhotoDate] [datetime] NULL,

[Address] [varchar](2000) NULL,

[Photo] [varchar](2000) NULL,

[Bak] [varchar](2000) NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_xczpjsm_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_xczpjsm] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场照片拍摄说明反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0.竖版 1.横版' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'Arrange'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'PhotoContext'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场照片拍摄说明_开始时间1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'PhotoDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场照片拍摄说明_拍摄地点1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'Address'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场照片拍摄说明_现场照片1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'Photo'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现场照片拍摄说明_备注1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'Bak'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'现场照片及说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xczpjsm'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_xzcfgzspb

/****** Object: Table [dbo].[m_case_xzcfgzspb] Script Date: 2023/2/15 0:42:48 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_xzcfgzspb](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[Fact] [varchar](2000) NULL,

[Opinion] [varchar](200) NULL,

[Base] [varchar](2000) NULL,

[CBRYJ] [varchar](2000) NULL,

[CBRYJ_Date] [datetime] NULL,

[CBJGSHYJ_IsAgree] [varchar](50) NULL,

[CBJGSHYJ_Reason] [varchar](200) NULL,

[CBJGSHYJ_Date] [datetime] NULL,

[FZJGSHYJ_IsAgree] [varchar](50) NULL,

[FZJGSHYJ_Date] [datetime] NULL,

[XZJGFZRSPYJ_IsAgree] [varchar](50) NULL,

[XZJGFZRSPYJ_Date] [datetime] NULL,

[AuditRoleID] [int] NULL CONSTRAINT [DF_m_case_xzcfgzspb_AuditRoleID] DEFAULT ((1)),

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_xzcfgzspb_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_xzcfgzspb] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_案件事实经过及证据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'Fact'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当事人意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'Opinion'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_执法人员处理意见及依据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'CBRYJ'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_执法人员处理意见及依据_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'CBRYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_承办机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_承办机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_承办机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_法制机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_法制机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_机关负责人审批意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_机关负责人审批意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_当前审核人职务ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'AuditRoleID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'行政处罚告知审批表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfgzspb'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_xzcfjds

/****** Object: Table [dbo].[m_case_xzcfjds] Script Date: 2023/2/15 0:43:11 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_xzcfjds](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[DangShiRen] [varchar](200) NULL,

[Effect] [varchar](200) NULL,

[Regular] [varchar](100) NULL,

[Action] [varchar](500) NULL,

[Evidence] [varchar](200) NULL,

[Violate] [varchar](500) NULL,

[Base] [varchar](500) NULL,

[IllegalAct] [varchar](100) NULL,

[Standard] [varchar](500) NULL,

[Penalty] [varchar](50) NULL,

[Deal] [varchar](200) NULL,

[CauseAction] [varchar](200) NULL,

[Lower] [decimal](18, 2) NULL,

[Type] [varchar](20) NULL,

[Whereas] [varchar](200) NULL,

[TakeDate] [datetime] NULL,

[Argue] [varchar](100) NULL,

[Consider] [varchar](100) NULL,

[Opinion] [varchar](200) NULL,

[Believe] [varchar](50) NULL,

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_xzcfjds_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_xzcfjds] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_当事人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'DangShiRen'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_实施了' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Effect'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_规定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Regular'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_行为' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Action'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_证据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Evidence'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_违反' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Violate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_根据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Base'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_违法行为' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'IllegalAct'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_裁量标准' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Standard'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_罚款' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Penalty'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_处理' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Deal'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_案由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'CauseAction'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_罚款小写' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Lower'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_其他处罚方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Type'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_鉴于' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Whereas'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_提出陈述时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'TakeDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_辩称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Argue'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_本机关认为' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Consider'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Opinion'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_予以（未予）采信' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'Believe'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚决定书_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'行政处罚决定书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjds'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_xzcfjdspb

/****** Object: Table [dbo].[m_case_xzcfjdspb] Script Date: 2023/2/15 0:43:36 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_xzcfjdspb](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[Fact] [varchar](1000) NULL,

[Evidence] [varchar](500) NULL,

[Inform] [varchar](1000) NULL,

[Base] [varchar](1000) NULL,

[CBRYJ] [varchar](1000) NULL,

[CBRYJ_Date] [datetime] NULL,

[CBJGSHYJ_IsAgree] [varchar](50) NULL,

[CBJGSHYJ_Reason] [varchar](200) NULL,

[CBJGSHYJ_Date] [datetime] NULL,

[FZJGSHYJ_IsAgree] [varchar](50) NULL,

[FZJGSHYJ_Reason] [varchar](200) NULL,

[FZJGSHYJ_Date] [datetime] NULL,

[XZJGFZRSPYJ_IsAgree] [varchar](50) NULL,

[XZJGFZRSPYJ_Date] [datetime] NULL,

[AuditRoleID] [int] NULL CONSTRAINT [DF_m_case_xzcfjdspb_AuditRoleID] DEFAULT ((1)),

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_xzcfjdspb_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_xzcfjdspb] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_相关证据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'Evidence'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'履行告知及当事人陈述申辩或者听证情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'Inform'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_执法人员处理意见及依据_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'CBRYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_承办机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_承办机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_承办机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_法制机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_法制机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_法制机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'FZJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_机关负责人审批意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_机关负责人审批意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚审批表_当前审核人职务ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'AuditRoleID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'行政处罚决定审批表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfjdspb'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_xzcfsxgzs

/****** Object: Table [dbo].[m_case_xzcfsxgzs] Script Date: 2023/2/15 0:43:58 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_xzcfsxgzs](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[BasicCase] [varchar](500) NULL,

[Action] [varchar](500) NULL,

[Violate] [varchar](500) NULL,

[Evidence] [varchar](500) NULL,

[Base] [varchar](500) NULL,

[IllegalAct] [varchar](500) NULL,

[Standard] [varchar](500) NULL,

[Deal] [varchar](500) NULL,

[Lower] [decimal](18, 2) NULL,

[Type] [varchar](50) NULL CONSTRAINT [DF_Table_1_T21_Type] DEFAULT ((1)),

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_xzcfsxgzs_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_xzcfsxgzs] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_基本案情' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'BasicCase'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_行为' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Action'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_违反' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Violate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_证据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Evidence'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_根据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Base'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_违法行为' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'IllegalAct'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_裁量标准' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Standard'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_处理' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Deal'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_罚款小写' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Lower'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_类型（1.事先 2.听证）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'Type'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行政处罚事先告知书_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'行政处罚事先告知书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzcfsxgzs'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_xzjdlxcgs

/****** Object: Table [dbo].[m_case_xzjdlxcgs] Script Date: 2023/2/15 0:44:23 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_xzjdlxcgs](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[Person] [varchar](200) NULL,

[Context] [varchar](2000) NULL,

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_xzjdlxcgs_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_xzjdlxcgs] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzjdlxcgs', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'催告书反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzjdlxcgs', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'催告书_被催告人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzjdlxcgs', @level2type=N'COLUMN',@level2name=N'Person'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'催告书_内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzjdlxcgs', @level2type=N'COLUMN',@level2name=N'Context'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'催告书_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzjdlxcgs', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzjdlxcgs', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzjdlxcgs', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'行政决定履行催告书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_xzjdlxcgs'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_zybyfqspb

/****** Object: Table [dbo].[m_case_zybyfqspb] Script Date: 2023/2/15 0:44:44 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_zybyfqspb](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[Brief] [varchar](500) NULL,

[Reason] [varchar](500) NULL,

[CBRYJ] [varchar](100) NULL,

[CBRYJ_Date] [datetime] NULL,

[CBJGSHYJ_IsAgree] [varchar](50) NULL,

[CBJGSHYJ_Reason] [varchar](200) NULL,

[CBJGSHYJ_Date] [datetime] NULL,

[XZJGFZRSPYJ_IsAgree] [varchar](50) NULL,

[XZJGFZRSPYJ_Date] [datetime] NULL,

[AuditRoleID] [int] NULL CONSTRAINT [DF_m_case_zybyfqspb_AuditRoleID] DEFAULT ((1)),

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_zybyfqspb_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_zybyfqspb] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_简要案情' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'Brief'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_移送法律依据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_承办人意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'CBRYJ'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_承办人意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'CBRYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_承办机构审核意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_承办机构审核意见_理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Reason'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_承办机构审核意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'CBJGSHYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_机关负责人审批意见_是否同意' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_IsAgree'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_机关负责人审批意见_日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'XZJGFZRSPYJ_Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予(不予)分期缴纳罚款审批表_当前审核人职务ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'AuditRoleID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'准予（不予）分期审批表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zybyfqspb'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case_zyfqjntzs

/****** Object: Table [dbo].[m_case_zyfqjntzs] Script Date: 2023/2/15 0:45:13 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case_zyfqjntzs](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CaseID] [int] NULL,

[Back] [varchar](50) NULL,

[SendDate] [datetime] NULL,

[PunishMoney] [varchar](50) NULL,

[PayType] [int] NULL,

[ExtendDate] [datetime] NULL,

[Period1] [int] NULL,

[Period1Date] [datetime] NULL,

[Period1Money] [varchar](50) NULL,

[Period2] [int] NULL,

[Period2Date] [datetime] NULL,

[Period2Money] [varchar](50) NULL,

[SaveDate] [datetime] NULL,

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_zyfqjntzs_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case_zyfqjntzs] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'CaseID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_反馈信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'Back'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_送达时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'SendDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_处罚金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'PunishMoney'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1.延期缴纳罚款 2.分期缴纳罚款' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'PayType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_延长至' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'ExtendDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_第1期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'Period1'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_第1期分期至' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'Period1Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_第1期缴纳罚款金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'Period1Money'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_第2期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'Period2'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_第2期分期至' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'Period2Date'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_第2期缴纳罚款金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'Period2Money'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'准予分期缴纳罚款通知书_保存时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'SaveDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除（0.否 1.是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'IsDelete'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs', @level2type=N'COLUMN',@level2name=N'CreateDate'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'准予分期缴纳通知书' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case_zyfqjntzs'

USE [ZongHeZhiFa2.0_ShangQiu]

drop table m_case

/****** Object: Table [dbo].[m_case] Script Date: 2023/2/15 0:46:15 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[m_case](

[ID] [int] IDENTITY(1,1) NOT NULL,

[AdminID] [int] NULL,

[DepartID] [int] NULL,

[CauseActionID] [int] NULL,

[CauseFromID] [int] NULL,

[PersonType] [int] NULL CONSTRAINT [DF_m_case_PersonType] DEFAULT ((1)),

[Num] [varchar](20) NULL,

[DocNum] [varchar](50) NULL,

[NoteNum] [int] NULL CONSTRAINT [DF_m_case_NoteNum] DEFAULT ((0)),

[WhichOne] [varchar](20) NULL,

[RealName] [varchar](50) NULL,

[LegalName] [varchar](10) NULL,

[Birthday] [datetime] NULL,

[Sex] [varchar](2) NULL,

[Age] [int] NULL,

[CardType] [varchar](20) NULL,

[IDCard] [varchar](30) NULL,

[Duty] [varchar](30) NULL,

[Mobile] [varchar](15) NULL,

[Address] [varchar](100) NULL,

[WorkUnit] [varchar](60) NULL,

[AFDate] [datetime] NULL,

[LADate] [datetime] NULL,

[JADate] [datetime] NULL,

[XQGZDate] [datetime] NULL,

[ZCZFDate] [datetime] NULL,

[ZLGZQSQK] [varchar](50) NULL,

[IsDB] [int] NULL,

[DBNum] [varchar](10) NULL,

[AFAddress] [varchar](100) NULL,

[WFQK] [varchar](500) NULL,

[FirstBeginDate] [datetime] NULL,

[FirstEndDate] [datetime] NULL,

[FirstAddress] [varchar](60) NULL,

[FirstCZW] [varchar](50) NULL,

[FirstPhotoCount] [varchar](10) NULL,

[ZBRRealName] [varchar](10) NULL,

[ZBRLawNum] [varchar](20) NULL,

[XBRRealName] [varchar](10) NULL,

[XBRLawNum] [varchar](20) NULL,

[ZDZRealName] [varchar](10) NULL,

[ZDZLawNum] [varchar](20) NULL,

[FGLDRealName] [varchar](10) NULL,

[FGLDLawNum] [varchar](20) NULL,

[DWLDRealName] [varchar](10) NULL,

[DWLDLawNum] [varchar](20) NULL,

[SHRRealName] [varchar](10) NULL,

[SHRLawNum] [varchar](20) NULL,

[FZKZRealName] [varchar](10) NULL,

[FZKZLawNum] [varchar](20) NULL,

[JLRRealName] [varchar](10) NULL,

[JLRLawNum] [varchar](20) NULL,

[Grade] [varchar](20) NULL,

[State] [int] NULL CONSTRAINT [DF_m_case_State] DEFAULT ((1)),

[Type] [int] NULL CONSTRAINT [DF_m_case_Type] DEFAULT ((1)),

[DeleteType] [int] NULL CONSTRAINT [DF_m_case_DeleteType] DEFAULT ((0)),

[SettleID] [int] NULL CONSTRAINT [DF_m_case_SettleID] DEFAULT ((0)),

[OrderDate] [datetime] NULL,

[SendDate] [datetime] NULL,

[IsAudit] [int] NULL CONSTRAINT [DF_m_case_IsAudit] DEFAULT ((0)),

[IsDelete] [int] NULL CONSTRAINT [DF_m_case_IsDelete] DEFAULT ((0)),

[CreateDate] [datetime] NULL,

CONSTRAINT [PK_m_case] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'AdminID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案由ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'CauseActionID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案件来源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'CauseFromID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当事人类型（1.个人 2.企业 3.个体工商户）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'PersonType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第几号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Num'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'DocNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第几个节点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'NoteNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第几条' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'WhichOne'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'RealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'LegalName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生年月' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Birthday'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Sex'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Age'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'CardType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份证' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'IDCard'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职务' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Duty'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话/手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Mobile'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址/住址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Address'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'WorkUnit'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'受案日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'AFDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案发时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'LADate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结案时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'JADate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'限期改正时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'XQGZDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'再次执法时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'ZCZFDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'责令改正签收情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'ZLGZQSQK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否督办' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'IsDB'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'督办号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'DBNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'案发地点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'AFAddress'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'违法情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'WFQK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次拍摄开始时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FirstBeginDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次拍摄结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FirstEndDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次拍摄地点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FirstAddress'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次参照物' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FirstCZW'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次照片张数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FirstPhotoCount'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主办人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'ZBRRealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主办人执法证编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'ZBRLawNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'协办人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'XBRRealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'协办人执法证编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'XBRLawNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'中队长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'ZDZRealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'中队长执法证编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'ZDZLawNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分管领导' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FGLDRealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分管领导执法证编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FGLDLawNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位领导' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'DWLDRealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位领导执法证编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'DWLDLawNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'SHRRealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核人执法证编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'SHRLawNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法制科长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FZKZRealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法制科长执法证编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'FZKZLawNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'JLRRealName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录人执法证编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'JLRLawNum'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'违法等次' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Grade'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态（1.未结案 2.待结案 3.已结案）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'State'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型（1.简易程序 2.一般程序）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'Type'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除方式（1.删除该案件后，该案件编号之后的编号自动向前补齐 2.删除该案件后，该案件编号留给下次新建的案件）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'DeleteType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结案人员ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'SettleID'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'送达时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'SendDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否审核（0.未审核 1.已审核，不能删除）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case', @level2type=N'COLUMN',@level2name=N'IsAudit'

EXEC sys.sp_addextendedproperty @name=N'brief', @value=N'案件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'm_case'