1 -- 这是依据系统自动生成的create脚本，填入所需字段来创建表
2
3 USE [csnprod]
4 GO
5
6 /****** Object: Table [dbo].[message_master] Script Date: 2023/8/25 12:57:06 ******/
7 SET ANSI_NULLS ON
8 GO
9
10 SET QUOTED_IDENTIFIER ON
11 GO
12
13 SET ANSI_PADDING ON
14 GO
15 -- 创建主表：主键、所需字段、创建人和修改人
16 CREATE TABLE [dbo].[mes_master](
17 [mes_id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
18
19 [mes_title] [varchar](50) NOT NULL,
20 [mes_grade] [varchar](20) NOT NULL,
21
22 [create_user] [varchar](20) NOT NULL,
23 [create_time] [datetime] NOT NULL,
24
25 [trans_user] [varchar](20) NOT NULL,
26 [trans_time] [datetime] NOT NULL,
27 CONSTRAINT [PK_mes_master] PRIMARY KEY CLUSTERED
28 (
29 [mes_id] ASC
30 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
31 ) ON [PRIMARY]
32
33 GO
34
35 SET ANSI_PADDING OFF
36 GO
37 ---------------------------------------------------------------------------------------------
38 ---------------------------------------------------------------------------------------------
39
40 --明细表：有自己的主键、与主表有同名关联字段、所需字段、创建人和修改人
41 CREATE TABLE [dbo].[mes_details](
42 [id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
43
44 [mes_id] [numeric](18, 0) NOT NULL,
45
46 [mes_notifier] [varchar](50) NOT NULL,
47 [noti_department] [varchar](20) NOT NULL,
48
49 [create_user] [varchar](20) NOT NULL,
50 [create_time] [datetime] NOT NULL,
51
52 [trans_user] [varchar](20) NOT NULL,
53 [trans_time] [datetime] NOT NULL,
54 CONSTRAINT [PK_mes_details] PRIMARY KEY CLUSTERED
55 (
56 [id] ASC
57 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
58 ) ON [PRIMARY]
59
60 GO
61
62 SET ANSI_PADDING OFF
63 GO