语言表

[xiaowei8858]

--语言种类
CREATE TABLE [dbo].[CM_Language](
[LanguageGuid] [int] IDENTITY(1,1) NOT NULL,
[LanguageCnText] [nvarchar](32) COLLATE Chinese_PRC_CI_AS NULL,
[LanguageText] [nvarchar](32) COLLATE Chinese_PRC_CI_AS NULL,
[LanguageCode] [smallint] NOT NULL,
[Remark] [nvarchar](512) COLLATE Chinese_PRC_CI_AS NULL,
[SystemLanguage] [varchar](32) COLLATE Chinese_PRC_CI_AS NULL,
[IsCheck] [bit] NOT NULL DEFAULT ((0)),
CONSTRAINT [CM_Language_PK] PRIMARY KEY CLUSTERED
(
[LanguageCode] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

---弹出信息
CREATE TABLE [dbo].[CM_DictMsg](
[DictMsgGuid] [int] IDENTITY(1,1) NOT NULL,
[ModuleName] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[ModuleMethod] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[MsgCode] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[MsgText] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[ReferenceText] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[Remark] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[LanguageCode] [smallint] NULL,
[IsCheck] [bit] NOT NULL DEFAULT ((0)),
CONSTRAINT [CM_DictMsg_PK] PRIMARY KEY CLUSTERED
(
[DictMsgGuid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
--窗体表
CREATE TABLE [dbo].[CM_DictFrm](
[DictFrmGuid] [int] IDENTITY(1,1) NOT NULL,
[ModuleName] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[FrmFunction] [nvarchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[FrmName] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[ControlName] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[ControlText] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[ReferenceText] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[Remark] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[LanguageCode] [smallint] NULL,
[IsCheck] [bit] NOT NULL DEFAULT ((0)),
CONSTRAINT [CM_DictFrm_PK] PRIMARY KEY CLUSTERED
(
[DictFrmGuid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[CM_DictData](
[DictDataGuid] [int] IDENTITY(1,1) NOT NULL,
[ModuleName] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[DataName] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[DataCode] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[DataText] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[ReferenceText] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[Remark] [nvarchar](2048) COLLATE Chinese_PRC_CI_AS NULL,
[LanguageCode] [smallint] NULL,
[IsCheck] [bit] NOT NULL DEFAULT ((0)),
[ParentDataCode] [varchar](64) COLLATE Chinese_PRC_CI_AS NULL,
[SortCode] [int] NULL,
CONSTRAINT [CM_DictData_PK] PRIMARY KEY CLUSTERED
(
[DictDataGuid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

[wujinjian2008n]

看不懂