智慧商超管理系統(tǒng)使用人員

數(shù)據(jù)庫(kù)表格代碼

USE [cxy2017270402]
GO
/****** Object:  Table [dbo].[cxy_shouyingyuan]    Script Date: 10/31/2018 11:19:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cxy_shouyingyuan](
    [id] [int] NOT NULL,
    [name] [varchar](20) NULL,
    [gonfhao] [varchar](20) NULL,
    [mima] [varchar](10) NULL,
    [tol] [varchar](25) NULL,
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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[cxy_shouyingyuan] ([id], [name], [gonfhao], [mima], [tol]) VALUES (1, N'', N'', NULL, NULL)
INSERT [dbo].[cxy_shouyingyuan] ([id], [name], [gonfhao], [mima], [tol]) VALUES (2, NULL, NULL, NULL, NULL)
INSERT [dbo].[cxy_shouyingyuan] ([id], [name], [gonfhao], [mima], [tol]) VALUES (3, NULL, NULL, NULL, NULL)
INSERT [dbo].[cxy_shouyingyuan] ([id], [name], [gonfhao], [mima], [tol]) VALUES (4, NULL, NULL, NULL, NULL)
/****** Object:  Table [dbo].[cxy_shangpin]    Script Date: 10/31/2018 11:19:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cxy_shangpin](
    [id] [int] NOT NULL,
    [name] [varchar](20) NULL,
    [jiage] [varchar](50) NULL,
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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[cxy_kuguanyuan]    Script Date: 10/31/2018 11:19:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cxy_kuguanyuan](
    [id] [int] NOT NULL,
    [name] [varchar](20) NULL,
    [mima] [varchar](50) NULL,
    [tol] [varchar](25) NULL,
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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[cxy_gongyinshang]    Script Date: 10/31/2018 11:19:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cxy_gongyinshang](
    [id] [int] NOT NULL,
    [name] [varchar](20) NULL,
    [didian] [varchar](50) NULL,
    [lianxiren] [varchar](50) NULL,
    [tol] [varchar](25) NULL,
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
SET ANSI_PADDING OFF
GO

E-R圖

E-R圖.png

表格

表格.png