script.sql

USE [dbTask]
GO
/****** Object:  Table [dbo].[ActivityLogs]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ActivityLogs](
	[LogID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NULL,
	[Action] [nvarchar](255) NULL,
	[ActionTime] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED 
(
	[LogID] 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].[Comments]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Comments](
	[CommentID] [int] IDENTITY(1,1) NOT NULL,
	[TaskID] [int] NULL,
	[UserID] [int] NULL,
	[Content] [nvarchar](max) NULL,
	[CommentDate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[CommentID] 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].[ConversationParticipants]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ConversationParticipants](
	[ConversationID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[JoinedAt] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ConversationID] ASC,
	[UserID] 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].[Conversations]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Conversations](
	[ConversationID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](255) NULL,
	[CreatedAt] [datetime] NOT NULL,
	[LastMessageAt] [datetime] NULL,
	[DepartmentID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[ConversationID] 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].[Departments]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Departments](
	[DepartmentID] [int] IDENTITY(1,1) NOT NULL,
	[DepartmentName] [nvarchar](100) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[DepartmentID] 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].[Messages]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Messages](
	[MessageID] [int] IDENTITY(1,1) NOT NULL,
	[ConversationID] [int] NOT NULL,
	[SenderID] [int] NOT NULL,
	[ReceiverID] [int] NULL,
	[Content] [nvarchar](max) NOT NULL,
	[SentAt] [datetime] NOT NULL,
	[IsRead] [bit] NOT NULL,
	[Status] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[MessageID] 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].[Notifications]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Notifications](
	[NotificationID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NULL,
	[Message] [nvarchar](255) NULL,
	[IsRead] [bit] NULL DEFAULT ((0)),
	[CreatedAt] [datetime] NULL DEFAULT (getdate()),
	[MessageID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[NotificationID] 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].[Projects]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Projects](
	[ProjectID] [int] IDENTITY(1,1) NOT NULL,
	[ProjectName] [nvarchar](200) NOT NULL,
	[Description] [nvarchar](1000) NULL,
	[StartDate] [date] NULL,
	[EndDate] [date] NULL,
	[Status] [nvarchar](50) NULL,
	[CreatedBy] [int] NULL,
	[CreatedAt] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED 
(
	[ProjectID] 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].[Roles]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Roles](
	[RoleID] [int] IDENTITY(1,1) NOT NULL,
	[RoleName] [nvarchar](50) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[RoleID] 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].[TaskAssignments]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaskAssignments](
	[AssignmentID] [int] IDENTITY(1,1) NOT NULL,
	[TaskID] [int] NULL,
	[AssigneeID] [int] NULL,
	[AssignedAt] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED 
(
	[AssignmentID] 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].[Tasks]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tasks](
	[TaskID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](200) NULL,
	[Description] [nvarchar](max) NULL,
	[CreatorID] [int] NULL,
	[DepartmentID] [int] NULL,
	[StartDate] [date] NULL,
	[EndDate] [date] NULL,
	[Priority] [nvarchar](20) NULL,
	[StatusID] [int] NULL,
	[CreatedAt] [datetime] NULL DEFAULT (getdate()),
	[ProjectID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[TaskID] 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].[TaskStatistics]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaskStatistics](
	[StatID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NULL,
	[TotalTasks] [int] NULL DEFAULT ((0)),
	[CompletedTasks] [int] NULL DEFAULT ((0)),
	[LateTasks] [int] NULL DEFAULT ((0)),
	[UpdatedAt] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED 
(
	[StatID] 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].[TaskStatuses]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaskStatuses](
	[StatusID] [int] IDENTITY(1,1) NOT NULL,
	[StatusName] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[StatusID] 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].[Users]    Script Date: 26/08/2025 4:16:46 CH ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Users](
	[UserID] [int] IDENTITY(1,1) NOT NULL,
	[FullName] [nvarchar](100) NULL,
	[Email] [nvarchar](100) NULL,
	[Password] [nvarchar](100) NULL,
	[RoleID] [int] NULL,
	[DepartmentID] [int] NULL,
	[Status] [bit] NULL DEFAULT ((1)),
	[CreatedAt] [datetime] NULL DEFAULT (getdate()),
	[Avatar] [nvarchar](255) NULL,
	[Mobile] [varchar](15) NULL,
	[Address] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED 
(
	[UserID] 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
SET IDENTITY_INSERT [dbo].[ActivityLogs] ON 

INSERT [dbo].[ActivityLogs] ([LogID], [UserID], [Action], [ActionTime]) VALUES (1, 13, N'Đăng nhập hệ thống', CAST(N'2025-07-17 22:48:16.777' AS DateTime))
INSERT [dbo].[ActivityLogs] ([LogID], [UserID], [Action], [ActionTime]) VALUES (2, 14, N'Phân công công việc cho nhân viên', CAST(N'2025-07-17 22:48:16.777' AS DateTime))
INSERT [dbo].[ActivityLogs] ([LogID], [UserID], [Action], [ActionTime]) VALUES (3, 15, N'Bình luận trong công việc', CAST(N'2025-07-17 22:48:16.777' AS DateTime))
SET IDENTITY_INSERT [dbo].[ActivityLogs] OFF
SET IDENTITY_INSERT [dbo].[Departments] ON 

INSERT [dbo].[Departments] ([DepartmentID], [DepartmentName]) VALUES (6, N'Phòng Kỹ thuật')
INSERT [dbo].[Departments] ([DepartmentID], [DepartmentName]) VALUES (7, N'Phòng Nhân sự')
INSERT [dbo].[Departments] ([DepartmentID], [DepartmentName]) VALUES (8, N'Phòng Kế toán')
INSERT [dbo].[Departments] ([DepartmentID], [DepartmentName]) VALUES (9, N'Ban Giám Đốc')
INSERT [dbo].[Departments] ([DepartmentID], [DepartmentName]) VALUES (10, N'Phòng IT')
SET IDENTITY_INSERT [dbo].[Departments] OFF
SET IDENTITY_INSERT [dbo].[Notifications] ON 

INSERT [dbo].[Notifications] ([NotificationID], [UserID], [Message], [IsRead], [CreatedAt], [MessageID]) VALUES (1, 13, N'Bạn được giao công việc "Thiết kế UI"', 0, CAST(N'2025-07-17 22:47:53.907' AS DateTime), NULL)
INSERT [dbo].[Notifications] ([NotificationID], [UserID], [Message], [IsRead], [CreatedAt], [MessageID]) VALUES (2, 14, N'Bạn được giao công việc "Test hệ thống"', 0, CAST(N'2025-07-17 22:47:53.907' AS DateTime), NULL)
INSERT [dbo].[Notifications] ([NotificationID], [UserID], [Message], [IsRead], [CreatedAt], [MessageID]) VALUES (3, 15, N'Trạng thái công việc đã được cập nhật', 0, CAST(N'2025-07-17 22:47:53.907' AS DateTime), NULL)
SET IDENTITY_INSERT [dbo].[Notifications] OFF
SET IDENTITY_INSERT [dbo].[Projects] ON 

INSERT [dbo].[Projects] ([ProjectID], [ProjectName], [Description], [StartDate], [EndDate], [Status], [CreatedBy], [CreatedAt]) VALUES (8, N'Dự án Hệ Thống Quản Lý Sinh Viên', N'Nâng cấp website', CAST(N'2025-06-01' AS Date), CAST(N'2027-12-01' AS Date), N'Hoàn thành', 13, CAST(N'2025-08-25 02:06:09.703' AS DateTime))
INSERT [dbo].[Projects] ([ProjectID], [ProjectName], [Description], [StartDate], [EndDate], [Status], [CreatedBy], [CreatedAt]) VALUES (13, N'Phân tích và thiết kế hệ thống App Todolist', N'Thực hiện công việc theo đúng chuẩn app Todo , sắp xếp, bố trí các thư mục hợp lý để người dùng dễ dàng thao tác', CAST(N'2025-12-31' AS Date), CAST(N'2027-01-11' AS Date), N'Hoàn thành', 13, CAST(N'2025-08-08 21:28:46.317' AS DateTime))
INSERT [dbo].[Projects] ([ProjectID], [ProjectName], [Description], [StartDate], [EndDate], [Status], [CreatedBy], [CreatedAt]) VALUES (18, N'Dự án Phầm mềm chấm bài thi', N'Dự án phải hoàn thành sơm hơn dự kiến', CAST(N'2025-09-08' AS Date), CAST(N'2028-12-08' AS Date), N'Đang thực hiện', 13, CAST(N'2025-08-08 21:28:20.130' AS DateTime))
SET IDENTITY_INSERT [dbo].[Projects] OFF
SET IDENTITY_INSERT [dbo].[Roles] ON 

INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (7, N'Giám đốc')
INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (8, N'Trưởng phòng')
INSERT [dbo].[Roles] ([RoleID], [RoleName]) VALUES (9, N'Nhân viên')
SET IDENTITY_INSERT [dbo].[Roles] OFF
SET IDENTITY_INSERT [dbo].[TaskAssignments] ON 

INSERT [dbo].[TaskAssignments] ([AssignmentID], [TaskID], [AssigneeID], [AssignedAt]) VALUES (39, 17, 33, CAST(N'2025-08-02 03:16:32.410' AS DateTime))
INSERT [dbo].[TaskAssignments] ([AssignmentID], [TaskID], [AssigneeID], [AssignedAt]) VALUES (41, 19, 21, CAST(N'2025-08-02 06:08:40.543' AS DateTime))
INSERT [dbo].[TaskAssignments] ([AssignmentID], [TaskID], [AssigneeID], [AssignedAt]) VALUES (42, 20, 23, CAST(N'2025-08-02 07:02:14.303' AS DateTime))
INSERT [dbo].[TaskAssignments] ([AssignmentID], [TaskID], [AssigneeID], [AssignedAt]) VALUES (43, 21, 16, CAST(N'2025-08-02 08:12:10.377' AS DateTime))
INSERT [dbo].[TaskAssignments] ([AssignmentID], [TaskID], [AssigneeID], [AssignedAt]) VALUES (45, 23, 24, CAST(N'2025-08-08 14:25:29.877' AS DateTime))
INSERT [dbo].[TaskAssignments] ([AssignmentID], [TaskID], [AssigneeID], [AssignedAt]) VALUES (46, 24, 30, CAST(N'2025-08-08 14:31:28.920' AS DateTime))
INSERT [dbo].[TaskAssignments] ([AssignmentID], [TaskID], [AssigneeID], [AssignedAt]) VALUES (47, 25, 32, CAST(N'2025-08-22 08:15:58.103' AS DateTime))
SET IDENTITY_INSERT [dbo].[TaskAssignments] OFF
SET IDENTITY_INSERT [dbo].[Tasks] ON 

INSERT [dbo].[Tasks] ([TaskID], [Title], [Description], [CreatorID], [DepartmentID], [StartDate], [EndDate], [Priority], [StatusID], [CreatedAt], [ProjectID]) VALUES (17, N'Xuất báo cáo tháng 8', N'Phải hoàn thành sớm nhất để tổng hợp báo cáo lên Ban giám đốc', 38, 8, CAST(N'2025-08-02' AS Date), CAST(N'2025-08-03' AS Date), N'Trung bình', 9, CAST(N'2025-08-02 03:16:32.380' AS DateTime), 13)
INSERT [dbo].[Tasks] ([TaskID], [Title], [Description], [CreatorID], [DepartmentID], [StartDate], [EndDate], [Priority], [StatusID], [CreatedAt], [ProjectID]) VALUES (19, N'Thiết kế giao diện', N'Phải hoàn thành trước ngày 10', 14, 10, CAST(N'2025-09-08' AS Date), CAST(N'2025-12-10' AS Date), N'Trung bình', 9, CAST(N'2025-08-02 06:08:40.523' AS DateTime), 18)
INSERT [dbo].[Tasks] ([TaskID], [Title], [Description], [CreatorID], [DepartmentID], [StartDate], [EndDate], [Priority], [StatusID], [CreatedAt], [ProjectID]) VALUES (20, N'Trực tiếp phỏng vấn thực tập sinh tháng 9', N'Ưu tiên các trường gần khu vực', 13, 7, CAST(N'2025-08-03' AS Date), CAST(N'2025-08-05' AS Date), N'Trung bình', 10, CAST(N'2025-08-02 07:02:14.197' AS DateTime), 8)
INSERT [dbo].[Tasks] ([TaskID], [Title], [Description], [CreatorID], [DepartmentID], [StartDate], [EndDate], [Priority], [StatusID], [CreatedAt], [ProjectID]) VALUES (21, N'Cấu hình Domain', N'Cấu hình Domain chuẩn', 13, 6, CAST(N'2025-08-02' AS Date), CAST(N'2025-09-09' AS Date), N'Trung bình', 9, CAST(N'2025-08-02 08:12:10.370' AS DateTime), 18)
INSERT [dbo].[Tasks] ([TaskID], [Title], [Description], [CreatorID], [DepartmentID], [StartDate], [EndDate], [Priority], [StatusID], [CreatedAt], [ProjectID]) VALUES (23, N'Triển khai hệ thống cơ sỡ dữ liệu cho app chấm bài thi', N'Hoàn thành trước thời hạn sớm hơn 1 ngày để review cho khách hàng.', 40, 10, CAST(N'2025-08-08' AS Date), CAST(N'2025-09-08' AS Date), N'Trung bình', 9, CAST(N'2025-08-08 14:25:29.850' AS DateTime), 18)
INSERT [dbo].[Tasks] ([TaskID], [Title], [Description], [CreatorID], [DepartmentID], [StartDate], [EndDate], [Priority], [StatusID], [CreatedAt], [ProjectID]) VALUES (24, N'Thống kê ngân sách của dự án trong tháng 8', N'Ngoài ngân sách còn các khoản khác tính riêng một file', 19, 8, CAST(N'2025-08-09' AS Date), CAST(N'2025-08-22' AS Date), N'Khẩn cấp', 10, CAST(N'2025-08-08 14:31:28.917' AS DateTime), 18)
INSERT [dbo].[Tasks] ([TaskID], [Title], [Description], [CreatorID], [DepartmentID], [StartDate], [EndDate], [Priority], [StatusID], [CreatedAt], [ProjectID]) VALUES (25, N'Triển khai backend cho hệ thống', N'Đẩy nhanh tiến độ', 40, 10, CAST(N'2025-08-22' AS Date), CAST(N'2026-12-22' AS Date), N'Trung bình', 8, CAST(N'2025-08-22 08:15:58.000' AS DateTime), 8)
SET IDENTITY_INSERT [dbo].[Tasks] OFF
SET IDENTITY_INSERT [dbo].[TaskStatistics] ON 

INSERT [dbo].[TaskStatistics] ([StatID], [UserID], [TotalTasks], [CompletedTasks], [LateTasks], [UpdatedAt]) VALUES (1, 13, 5, 3, 1, CAST(N'2025-07-17 22:47:34.200' AS DateTime))
INSERT [dbo].[TaskStatistics] ([StatID], [UserID], [TotalTasks], [CompletedTasks], [LateTasks], [UpdatedAt]) VALUES (2, 14, 4, 2, 0, CAST(N'2025-07-17 22:47:34.200' AS DateTime))
INSERT [dbo].[TaskStatistics] ([StatID], [UserID], [TotalTasks], [CompletedTasks], [LateTasks], [UpdatedAt]) VALUES (3, 15, 6, 4, 2, CAST(N'2025-07-17 22:47:34.200' AS DateTime))
SET IDENTITY_INSERT [dbo].[TaskStatistics] OFF
SET IDENTITY_INSERT [dbo].[TaskStatuses] ON 

INSERT [dbo].[TaskStatuses] ([StatusID], [StatusName]) VALUES (8, N'Chưa bắt đầu')
INSERT [dbo].[TaskStatuses] ([StatusID], [StatusName]) VALUES (9, N'Đang thực hiện')
INSERT [dbo].[TaskStatuses] ([StatusID], [StatusName]) VALUES (10, N'Hoàn thành')
SET IDENTITY_INSERT [dbo].[TaskStatuses] OFF
SET IDENTITY_INSERT [dbo].[Users] ON 

INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (13, N'Đoàn Trung Quý', N'giamdoc@example.com', N'$2a$11$89tZdxk5hD7fy8Ec30RW1uON.pFGmdzR0Z.f1pWTh1dF/78kZqhre', 7, 9, 1, CAST(N'2025-08-08 21:03:09.193' AS DateTime), N'https://localhost:7143/FileUploads/3ea24901-1e29-4265-a8d0-d1ce9ef8aa65.jpg', N'0865510677', N'Hồ Chí Minh')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (14, N'Nguyễn Dương Quế ', N'truongphong@example.com', N'$2a$11$92GHMANoxmFOdQWPTwVtLe758Mf9H8gcoTWI793Mid3q0ECgCoRXa', 8, 7, 1, CAST(N'2025-08-08 21:06:05.713' AS DateTime), N'https://localhost:7143/FileUploads/d827375d-e738-4c06-b4b0-8d78cee95951.jpg', N'0987239997', N'Cần Thơ')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (15, N'Sử Hoàng Đô', N'nhanvien@example.com', N'$2a$11$hkjUbBVkAO6Q0W.uoVWF8e7ad9DtH8RgbkAr15pQwpMNUHXr.6s2C', 9, 7, 1, CAST(N'2025-07-31 13:33:51.573' AS DateTime), N'', N'0943285673', N'Đồng Tháp')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (16, N'Nguyễn Văn An', N'nv.an@example.com', N'$2a$11$mf0ZlP1uXd9aCS97y47FhOWOFP0uxAEl7SXeaIeD23LjBqfybQATK', 9, 6, 1, CAST(N'2025-08-08 21:13:54.820' AS DateTime), N'https://localhost:7143/FileUploads/42ab2504-7c91-450f-b761-b6f2284c7122.jpg', N'0901234561', N'Hà Nội')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (17, N'Trần Thị Bình', N'tt.binh@example.com', N'123456', 9, 8, 1, CAST(N'2025-08-08 21:11:49.637' AS DateTime), N'https://localhost:7143/FileUploads/c6f6e729-57d3-4a5a-a3e1-0ede669fa9d0.jpg', N'0912345671', N'Đà Nẵng')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (18, N'Lê Văn Cường', N'lv.cuong@example.com', N'123456', 9, 6, 1, CAST(N'2025-08-08 21:13:09.720' AS DateTime), N'https://localhost:7143/FileUploads/ed318f08-49e1-41c8-af26-50d0662ca803.jpg', N'0923456781', N'Hồ Chí Minh')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (19, N'Phạm Thị Dung', N'pt.dung@example.com', N'$2a$11$zABIPSfiztnZv12P.cC6HOMNVvRZoXZrwDBVKi9Zq65arGzXl7Sgu', 8, 8, 1, CAST(N'2025-08-08 21:06:20.480' AS DateTime), N'https://localhost:7143/FileUploads/84d354d1-d363-4199-a605-0e92387b2e49.jpg', N'0934567891', N'Cần Thơ')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (20, N'Hoàng Văn Em', N'hv.em@example.com', N'123456', 9, 7, 1, CAST(N'2025-08-08 21:15:40.757' AS DateTime), N'https://localhost:7143/FileUploads/95dd486e-0164-48f0-872d-147ebf80fc27.jpg', N'0945678912', N'Hải Phòng')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (21, N'Vũ Thị Gấm', N'vt.gam@example.com', N'$2a$11$8MG1AM4S.lS5DzspJ/bJ1ORqOcq.fLCMFUCbWqdLrOF3nuXkwvVhS', 9, 10, 1, CAST(N'2025-08-22 20:45:37.690' AS DateTime), N'https://localhost:7143/FileUploads/2e703bd6-3973-4388-bf86-4db01bf17159.jpg', N'0956789123', N'Huế')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (22, N'Dương Văn Hòa', N'dv.hoa@example.com', N'$2a$11$8zrYGN719fqnCZ/JwejEWOE6daNb6bvLJGT8GFFLCVBvllZ1ChvUO', 9, 8, 1, CAST(N'2025-08-08 21:11:00.573' AS DateTime), N'https://localhost:7143/FileUploads/8361a738-5418-421e-8795-501af31ed92c.jpg', N'0967891234', N'Nha Trang')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (23, N'Nguyễn Văn Tiến Dũng', N'anguyen@gmail.com', N'$2a$11$6j.oxojV.v2cCpuU7pYHYevw4NoDqwgHIxYivHPhiXYf4tHns5Oma', 9, 7, 1, CAST(N'2025-08-08 21:16:16.200' AS DateTime), N'https://localhost:7143/FileUploads/a2a7a9a6-907d-4e14-913a-31aa5ec55a2c.jpg', N'0987654321', N'Thuận giao 18, Thuận giao, Thuận An, Bình Dương')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (24, N'Ngô Văn Huy', N'nv.huy@example.com', N'$2a$11$47KzzSOyMHRIh8.uZEwqpuBwtRpJ4yQcsBy0lwzjkGA8W1ga92Wjm', 9, 10, 1, CAST(N'2025-08-25 02:05:48.340' AS DateTime), N'https://localhost:7143/FileUploads/a1838fc2-74f7-4684-b8a6-da7e84e25879.jpg', N'0989123456', N'Quảng Ninh')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (25, N'Lý Thị Lan', N'lt.lan@example.com', N'123456', 9, 7, 1, CAST(N'2025-08-08 21:15:58.913' AS DateTime), N'https://localhost:7143/FileUploads/f356406b-4751-495b-929f-60ac77879829.jpg', N'0991234567', N'Đà Lạt')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (26, N'Trịnh Văn Nam', N'tv.nam@example.com', N'$2a$11$jawguPIC4HpCXTtTd3Gc7OhoBEti/8hRMu24s1FDa/JGauu1QcTU6', 9, 10, 1, CAST(N'2025-08-22 20:45:59.433' AS DateTime), N'https://localhost:7143/FileUploads/39e794b7-ea1e-4470-a115-8be78932d529.jpg', N'0902345678', N'Buôn Ma Thuột')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (27, N'Đỗ Thị Oanh', N'dt.oanh@example.com', N'$2a$11$cUKRpp2ALG0BXl7bSguWcOFZ22jgfWiDd8iFuFmgteBWqIhfkvPne', 9, 8, 1, CAST(N'2025-08-08 21:11:14.493' AS DateTime), N'https://localhost:7143/FileUploads/74b65962-59e9-41e5-8960-4403d3c22504.jpg', N'0913456789', N'Phan Thiết')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (28, N'Phan Văn Quang', N'pv.quang@example.com', N'123456', 9, 7, 1, CAST(N'2025-07-29 21:15:51.047' AS DateTime), N'', N'0924567890', N'Rạch Giá')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (29, N'Tạ Thị Rosa', N'tt.rosa@example.com', N'123456', 9, 7, 0, CAST(N'2025-07-29 21:18:41.513' AS DateTime), N'', N'0935678901', N'Cà Mau')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (30, N'Mai Văn Sơn', N'mv.son@example.com', N'123456', 9, 8, 1, CAST(N'2025-08-08 21:11:36.503' AS DateTime), N'https://localhost:7143/FileUploads/54f35837-ad24-43e2-8026-3a75c96882de.jpg', N'0946789012', N'Long Xuyên')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (31, N'Hoàng Thị Tuyết', N'ht.tuyet@example.com', N'$2a$11$juHe6/GQ/5my5zN/UKjx3eFp75RvxnBadCyjtlqNA/NwRQrgsjcSa', 9, 6, 1, CAST(N'2025-08-08 21:12:53.520' AS DateTime), N'https://localhost:7143/FileUploads/8c441427-2031-4169-aed2-d354746b9027.jpg', N'0957890123', N'Bạc Liêu')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (32, N'Nguyễn Văn Út', N'nv.ut@example.com', N'$2a$11$l2StpqxnexCcgxCcTL7XKuU4c/7RLko0PnTNSAdtgZA2Nkbbg88li', 9, 10, 1, CAST(N'2025-08-22 15:16:14.260' AS DateTime), N'https://localhost:7143/FileUploads/fef084ca-1dcb-4270-bd44-e9449c63b9bc.jpg', N'0968901234', N'Sóc Trăng')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (33, N'Trần Thị Vân', N'tt.van@example.com', N'$2a$11$sYYXOuaxPcCN634XpBRPZeA2pk8WlO3EpmYZPrCGY9VX0E84aIQBK', 9, 8, 1, CAST(N'2025-08-08 21:12:11.547' AS DateTime), N'https://localhost:7143/FileUploads/d1973f02-7011-4b0c-a577-ca406bf9a485.jpg', N'0979012345', N'Trà Vinh')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (34, N'Lê Văn Xuân', N'lv.xuan@example.com', N'123456', 9, 6, 1, CAST(N'2025-08-08 21:13:28.120' AS DateTime), N'https://localhost:7143/FileUploads/6cde90b6-0d43-4cb1-936d-6cff4607d3ad.jpg', N'0980123456', N'Tiền Giang')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (35, N'Phạm Thị Yến', N'pt.yen@example.com', N'123456', 9, 6, 1, CAST(N'2025-08-08 21:14:17.513' AS DateTime), N'https://localhost:7143/FileUploads/aa205e9f-d0a0-409e-9b34-7d5b8be6dc4b.jpg', N'0991234568', N'Bến Tre')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (38, N'Dương Tiễn', N'batla1@gmail.com', N'$2a$11$iflCq1ioMV93QE1EU5v6yuYn3BTJJI6/LZ6SOW11/XBI1coakGaVm', 9, 10, 1, CAST(N'2025-08-25 01:30:21.333' AS DateTime), N'https://localhost:7143/FileUploads/9c3efaa2-5204-429e-a810-67431b88dffa.jpg', N'0945678971', N'Thiên Đình')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (39, N'Phan Văn Hùng', N'pv.hung@gmail.com', N'$2a$11$lJcJ6QN80F5DuzF4y0GDKeqnb7fVXyt6yMtBkenywjdCc/Qr7Tjyq', 8, 6, 1, CAST(N'2025-08-08 21:08:00.160' AS DateTime), N'https://localhost:7143/FileUploads/0d0efb5f-cd6d-42c3-80d9-ce5ab774be41.jpg', N'0972445667', N'Làng Trái Tim, Xã Kẹo Ngọt, Huyện Phiêu Lưu, Tỉnh Ooo ')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (40, N'Nguyễn Văn STiêu Vền', N'steven@gmail.com', N'$2a$11$gBG/EI5yaPzRc.nyo8WgluMnvb2xoorA6bIUgFXSsDaK7soGvIhxS', 8, 10, 1, CAST(N'2025-08-08 21:03:53.697' AS DateTime), N'https://localhost:7143/FileUploads/dbd1ffdc-84b2-4d86-bc81-29cedb603036.jpg', N'0909994884', N' Beach City ')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (41, N'Trần Quốc Việt', N'tranquocviet.k@gmail.com', N'$2a$11$TF2kypBwyO9cDmr.L57dPOK1Kj7R9OTyyNU2dZlU8r3sC9H/Jl2.K', 9, 10, 1, CAST(N'2025-08-08 21:10:36.717' AS DateTime), N'https://localhost:7143/FileUploads/d01ce873-73b8-4eeb-8e80-ae6cfaa8a0d7.jpg', N'0890546823', N'Hồ Chí Minh')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (47, N'Đoàn Điền Đôn', N'dd.don@gmail.com', N'$2a$11$4.GdgzmDHoiOFm2dtk0bI.5yTJWKj6h6G/3zugr8M3DnqMCT9VIXC', 9, 10, 1, CAST(N'2025-08-08 21:09:35.543' AS DateTime), N'https://localhost:7143/FileUploads/863427db-ef07-44ec-bf0e-c6527ca3839d.jpg', N'0967891234', N'Thuận giao 18, Thuận giao, Thuận An, Bình Dương')
INSERT [dbo].[Users] ([UserID], [FullName], [Email], [Password], [RoleID], [DepartmentID], [Status], [CreatedAt], [Avatar], [Mobile], [Address]) VALUES (48, N'Đinh Thị Thu Lê', N'dtt.le@gmail.com', N'$2a$11$N8ursVNXKy7GoJvGr057aeiI12IhMEZXv7mcdP2A6LoHpPPWNfuCi', 9, 8, 1, CAST(N'2025-08-08 21:09:50.350' AS DateTime), N'https://localhost:7143/FileUploads/5c005eec-7743-4c4d-ad90-caf851b40a69.jpg', N'0987346789', N'Tháp Nghệ')
SET IDENTITY_INSERT [dbo].[Users] OFF
SET ANSI_PADDING ON

GO
/****** Object:  Index [UQ__Users__A9D105349F4BA099]    Script Date: 26/08/2025 4:16:46 CH ******/
ALTER TABLE [dbo].[Users] ADD UNIQUE NONCLUSTERED 
(
	[Email] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Comments] ADD  DEFAULT (getdate()) FOR [CommentDate]
GO
ALTER TABLE [dbo].[ConversationParticipants] ADD  DEFAULT (getdate()) FOR [JoinedAt]
GO
ALTER TABLE [dbo].[Conversations] ADD  DEFAULT (getdate()) FOR [CreatedAt]
GO
ALTER TABLE [dbo].[Messages] ADD  DEFAULT (getdate()) FOR [SentAt]
GO
ALTER TABLE [dbo].[Messages] ADD  DEFAULT ((0)) FOR [IsRead]
GO
ALTER TABLE [dbo].[ActivityLogs]  WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Comments]  WITH CHECK ADD FOREIGN KEY([TaskID])
REFERENCES [dbo].[Tasks] ([TaskID])
GO
ALTER TABLE [dbo].[Comments]  WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[ConversationParticipants]  WITH CHECK ADD FOREIGN KEY([ConversationID])
REFERENCES [dbo].[Conversations] ([ConversationID])
GO
ALTER TABLE [dbo].[ConversationParticipants]  WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Conversations]  WITH CHECK ADD FOREIGN KEY([DepartmentID])
REFERENCES [dbo].[Departments] ([DepartmentID])
GO
ALTER TABLE [dbo].[Messages]  WITH CHECK ADD FOREIGN KEY([ConversationID])
REFERENCES [dbo].[Conversations] ([ConversationID])
GO
ALTER TABLE [dbo].[Messages]  WITH CHECK ADD FOREIGN KEY([ReceiverID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Messages]  WITH CHECK ADD FOREIGN KEY([SenderID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Notifications]  WITH CHECK ADD FOREIGN KEY([MessageID])
REFERENCES [dbo].[Messages] ([MessageID])
GO
ALTER TABLE [dbo].[Notifications]  WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Projects]  WITH CHECK ADD FOREIGN KEY([CreatedBy])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[TaskAssignments]  WITH CHECK ADD FOREIGN KEY([AssigneeID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[TaskAssignments]  WITH CHECK ADD FOREIGN KEY([TaskID])
REFERENCES [dbo].[Tasks] ([TaskID])
GO
ALTER TABLE [dbo].[Tasks]  WITH CHECK ADD FOREIGN KEY([CreatorID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Tasks]  WITH CHECK ADD FOREIGN KEY([DepartmentID])
REFERENCES [dbo].[Departments] ([DepartmentID])
GO
ALTER TABLE [dbo].[Tasks]  WITH CHECK ADD FOREIGN KEY([StatusID])
REFERENCES [dbo].[TaskStatuses] ([StatusID])
GO
ALTER TABLE [dbo].[Tasks]  WITH CHECK ADD  CONSTRAINT [FK_Tasks_Projects] FOREIGN KEY([ProjectID])
REFERENCES [dbo].[Projects] ([ProjectID])
GO
ALTER TABLE [dbo].[Tasks] CHECK CONSTRAINT [FK_Tasks_Projects]
GO
ALTER TABLE [dbo].[TaskStatistics]  WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Users]  WITH CHECK ADD FOREIGN KEY([DepartmentID])
REFERENCES [dbo].[Departments] ([DepartmentID])
GO
ALTER TABLE [dbo].[Users]  WITH CHECK ADD FOREIGN KEY([RoleID])
REFERENCES [dbo].[Roles] ([RoleID])
GO