??USE [test]
GO
/****** Object: Table [dbo].[user] Script Date: 2023.08.18. 23:05:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[user](
[Id] [int] IDENTITY(1,1) NOT NULL,
[LoginName] [varchar](100) NULL,
[Password] [varchar](100) NULL,
[LastLoginDateTime] [datetime] NULL,
[IsLogged] [tinyint] NOT NULL,
[IsDeleted] [tinyint] NOT NULL,
CONSTRAINT [PK_user] 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
/****** Object: Table [dbo].[user_userrolescollection] Script Date: 2023.08.18. 23:05:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[user_userrolescollection](
[Id] [int] IDENTITY(1,1) NOT NULL,
[User] [int] NOT NULL,
[UserRole] [int] NOT NULL,
[IsDeleted] [tinyint] NOT NULL,
CONSTRAINT [PK__user_use__3214EC07139C4111] 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
/****** Object: Table [dbo].[userrole] Script Date: 2023.08.18. 23:05:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userrole](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Code] [varchar](50) NOT NULL,
[Name] [varchar](100) NOT NULL,
[IsDeleted] [tinyint] NOT NULL,
CONSTRAINT [PK__userrole__3214EC07DE834AB3] 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
/****** Object: Table [dbo].[userrole_userrolesettingscollection] Script Date: 2023.08.18. 23:05:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userrole_userrolesettingscollection](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UserRole] [int] NOT NULL,
[UserRoleSetting] [int] NOT NULL,
[Value] [varchar](100) NULL,
[IsDeleted] [tinyint] NOT NULL,
CONSTRAINT [PK__user_use__3214EC0779CD1A8E] 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
/****** Object: Table [dbo].[userrolesetting] Script Date: 2023.08.18. 23:05:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userrolesetting](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](100) NOT NULL,
[DefaultValue] [varchar](100) NULL,
[IsDeleted] [tinyint] NOT NULL,
CONSTRAINT [PK__usersett__3214EC07E74868B6] 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
|
