From dd18485d5e6a7605b58d667bab2e315fc33a3d4a Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 25 4月 2024 13:40:22 +0800 Subject: [PATCH] 编号自动生成 公共 方法 --- DBScript/01_DDL/01_DDL_TABLE.sql | 125 +++++++++++++++++++++++++++++++++++++++++ 1 files changed, 124 insertions(+), 1 deletions(-) diff --git a/DBScript/01_DDL/01_DDL_TABLE.sql b/DBScript/01_DDL/01_DDL_TABLE.sql index 2549633..d7bb0b7 100644 --- a/DBScript/01_DDL/01_DDL_TABLE.sql +++ b/DBScript/01_DDL/01_DDL_TABLE.sql @@ -1 +1,124 @@ -/* 杩欓噷鍐欏垱寤烘暟鎹簱鐨勮剼鏈� */ \ No newline at end of file +/* 杩欓噷鍐欏垱寤烘暟鎹簱鐨勮剼鏈� */ + + + +-- 缂栧彿鐢熸垚琛� 銆怑ditby shaocx,2023-07-27銆� + +/****** Object: Table [dbo].[Base_SerialRuleDetail] Script Date: 2023/7/27 14:34:45 ******/ +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +CREATE TABLE [dbo].[Base_SerialRuleDetail]( + [Id] [bigint] NOT NULL, + [SerialRuleNo] [nvarchar](50) NOT NULL, + [SerialType] [int] NOT NULL, + [ItemNo] [int] NOT NULL, + [SourceType] [nvarchar](50) NOT NULL, + [SerialLength] [int] NOT NULL, + [SearchStart] [int] NULL, + [DecimalType] [int] NULL, + [UserDefine] [nvarchar](50) NULL, + [SerialCodeFlag] [int] NULL, + [Description] [nvarchar](250) NULL, + [SerialTypeNo] [nvarchar](max) NULL, + [GetData] [int] NULL, + [PadLeft] [int] NOT NULL, + [IssueStatus] [int] NULL, + [CreatedTime] [datetimeoffset](7) NULL, + [UpdatedTime] [datetimeoffset](7) NULL, + [CreatedUserId] [bigint] NULL, + [CreatedUserName] [nvarchar](50) NULL, + [UpdatedUserId] [bigint] NULL, + [UpdatedUserName] [nvarchar](50) NULL, + [IsDeleted] [bit] NOT NULL, + CONSTRAINT [PK_Base_SerialRuleDetail] 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] TEXTIMAGE_ON [PRIMARY] +GO +/****** Object: Table [dbo].[Base_SerialSN] Script Date: 2023/7/27 14:34:45 ******/ +SET ANSI_NULLS ON +GO +SET QUOTED_IDENTIFIER ON +GO +CREATE TABLE [dbo].[Base_SerialSN]( + [Id] [bigint] NOT NULL, + [CurrentDate] [datetime2](7) NOT NULL, + [Sn] [int] NOT NULL, + [SerialType] [int] NOT NULL, + [CreatedTime] [datetimeoffset](7) NULL, + [UpdatedTime] [datetimeoffset](7) NULL, + [CreatedUserId] [bigint] NULL, + [CreatedUserName] [nvarchar](50) NULL, + [UpdatedUserId] [bigint] NULL, + [UpdatedUserName] [nvarchar](50) NULL, + [IsDeleted] [bit] NOT NULL, + CONSTRAINT [PK_Base_SerialSN] 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] +GO + + +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Id涓婚敭' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'Id' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍗曟嵁鍙风紪鍙�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'SerialRuleNo' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍗曟嵁鍙风被鍨�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'SerialType' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鐢熸垚椤哄簭鍙�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'ItemNo' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缁勫悎绫诲瀷' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'SourceType' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缁勫悎绫诲瀷闀垮害' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'SerialLength' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'瀛楃涓插唴瀹�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'UserDefine' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'绫诲瀷鎻忚堪' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'Description' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鏂囨湰闈犺竟鏂瑰悜' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'PadLeft' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍒涘缓鏃堕棿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'CreatedTime' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鏇存柊鏃堕棿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'UpdatedTime' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍒涘缓鑰匢d' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'CreatedUserId' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍒涘缓鑰呭悕绉�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'CreatedUserName' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淇敼鑰匢d' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'UpdatedUserId' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淇敼鑰呭悕绉�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'UpdatedUserName' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'杞垹闄ゆ爣璁�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail', @level2type=N'COLUMN',@level2name=N'IsDeleted' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍗曟嵁鍙风敓鎴愯鍒欓厤缃〃' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialRuleDetail' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Id涓婚敭' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'Id' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'娴佹按鍙锋椂闂�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'CurrentDate' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'娴佹按鍙�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'Sn' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍗曟嵁鍙风被鍨�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'SerialType' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍒涘缓鏃堕棿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'CreatedTime' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鏇存柊鏃堕棿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'UpdatedTime' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍒涘缓鑰匢d' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'CreatedUserId' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍒涘缓鑰呭悕绉�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'CreatedUserName' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淇敼鑰匢d' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'UpdatedUserId' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淇敼鑰呭悕绉�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'UpdatedUserName' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'杞垹闄ゆ爣璁�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN', @level2type=N'COLUMN',@level2name=N'IsDeleted' +GO +EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鍗曟嵁鍙锋祦姘村彿灞ュ巻琛�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SerialSN' +GO + -- Gitblit v1.9.3