[go: up one dir, main page]
Scribd
Upload
34 views4 pages

Script ISP392

Uploaded by

namteoccqt572003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
34 views4 pages

Script ISP392

Uploaded by

namteoccqt572003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 4

create database ISP392_Gr3_Project;

use ISP392_Gr3_Project;

----------------------------------------
ITER1------------------------------------------
CREATE TABLE Role (
ID INT IDENTITY(1,1) PRIMARY KEY,
Position VARCHAR(255) NOT NULL,
--them
isDelete bit,-- xoa thi ddoi sang true (chi de an di thoi khong duoc phep
xoa)
CreatedAt DATETIME,
CreatedBy VARCHAR(255),
UpdatedAt DATETIME,
DeletedAt DATETIME,
DeletedBy VARCHAR(255),
)

INSERT INTO Role (Position, isDelete, CreatedAt, CreatedBy, UpdatedAt, DeletedAt,


DeleteBy)
VALUES
('Base User', 0, GETDATE(), 'System', NULL, NULL, NULL),
('Admin', 0, GETDATE(), 'System', NULL, NULL, NULL);

CREATE TABLE UserInfor (


ID INT PRIMARY KEY IDENTITY,
IDRole INT,
FirstName NVARCHAR(255),
LastName NVARCHAR(255),
DateOfBirth DATETIME,
UserName NVARCHAR(255),
Password NVARCHAR(255),
PhoneNumber NVARCHAR(255),
Email NVARCHAR(255),
Address NVARCHAR(255),
FOREIGN KEY (IDRole) REFERENCES Role(ID),
isDelete bit,-- xoa thi ddoi sang true (chi de an di thoi khong duoc phep
xoa)
CreatedAt DATETIME,
CreatedBy VARCHAR(255),
UpdatedAt DATETIME,
DeletedAt DATETIME,
DeletedBy VARCHAR(255),
);
drop table UserInfor

INSERT INTO UserInfor (IDRole,FirstName,LastName,DateOfBirth,UserName, Password,


PhoneNumber, Email, Address,isDelete, CreatedAt, CreatedBy, UpdatedAt, DeletedAt,
DeletedBy)
VALUES
(2, 'Thang', 'Do', '2003-10-23', 'thangdo',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0954354363','thangdo@gmail.com', 'Ha Long/Quang Ninh ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Khai', 'Luong', '2003-04-10', 'khaidz',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0385773289','khaidz@gmail.com', 'Na Sam/Lang Son ',0, GETDATE() , 'System', NULL,
NULL, NULL),
(1, 'Dat', 'Nguyen', '2003-07-19', 'dat2003',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0967529501','dat2003gmail.com', 'Nhan Hoa/Bac Ninh ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Nam', 'Nguyen', '2003-03-22', 'nam22',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0966537258','nam22@gmail.com', 'Bang An/Long An ',0, GETDATE() , 'System', NULL,
NULL, NULL),
(1, 'Long', 'Ta', '2003-12-5', 'long0cong',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0387654321','long0cong@gmail.com', 'Bim Son/Thanh Hoa ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Hoa', 'Nguyen', '2003-11-20', 'hoacute',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0984565425','hoacute@gmail.com', 'Thanh Xuan/Ha Noi ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Tien', 'Do', '2003-02-25', 'atien',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0906484963','atien@gmail.com', 'Quan 1/Ho Chi Minh ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Quynh', 'Nguyen', '2003-04-23', 'quynhxinh',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0359386035','quynhxinh@gmail.com', 'Thach That/Ha Noi ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Ha', 'Do', '2003-12-13', 'hapro',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0364164371','hapro@gmail.com', 'Hoai Duc/Ha Noi ',0, GETDATE() , 'System', NULL,
NULL, NULL),
(1, 'Hung', 'Nguyen', '2003-10-15', 'hungg',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0976432853','hungg@gmail.com', 'Phu Lang/Bac Giang ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Van', 'Chu', '2003-08-18', 'vanchu',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0836254871','vanchu@gmail.com', 'Rach Cheo/Ca Mau ',0, GETDATE() , 'System', NULL,
NULL, NULL),
(1, 'Linh', 'Bui', '2003-01-21', 'linhbui',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0964829503','linhbui@gmail.com', 'Dong Anh/Ha Noi ',0, GETDATE() , 'System', NULL,
NULL, NULL),
(1, 'Nam', 'Dang', '2003-09-30', 'namono',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0395884319','namono@gmail.com', 'Tan Hai/Hai Duong ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Duong', 'Le', '2003-11-16', 'duongdz',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0327493439','duongdz@gmail.com', 'Vu Ban/Nam Dinh ',0, GETDATE() , 'System', NULL,
NULL, NULL),
(1, 'Thai', 'Nguyen', '2003-06-25', 'thai2562003',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0978443821','thai2562003@gmail.com', 'Phu ly/Ha Nam ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Phuc', 'Nguyen', '2003-04-1', 'phucbo',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0305825034','phucbo@gmail.com', 'Van Lang/Lang Son ',0, GETDATE() , 'System',
NULL, NULL, NULL),
(1, 'Lan', 'Nguyen', '2003-12-28', 'lancan',
'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f',
'0966771508','lancan@gmail.com', 'Thuan Thanh/Bac Ninh ',0, GETDATE() , 'System',
NULL, NULL, NULL)

-------------------------------------------------
ITER2-------------------------------------

CREATE TABLE [Notification] (


ID INT IDENTITY(1,1) PRIMARY KEY,
IDUser INT,
Content NVARCHAR(MAX),
isDelete bit,
CreatedAt DATETIME,
CreatedBy VARCHAR(255),
UpdatedAt DATETIME,
DeletedAt DATETIME,
DeletedBy VARCHAR(255),
FOREIGN KEY (IDUser) REFERENCES UserInfor(ID)
)

CREATE TABLE Debtor (


ID INT IDENTITY(1,1) PRIMARY KEY,
FirstName NVARCHAR(255),
LastName NVARCHAR(255),
DateOfBirth DATETIME,
PhoneNumber NVARCHAR(255),
Email NVARCHAR(255),
Address NVARCHAR(255),
Amount float,
isDelete bit,
CreatedAt DATETIME,
CreatedBy VARCHAR(255),
UpdatedAt DATETIME,
DeletedAt DATETIME,
DeletedBy VARCHAR(255)
)

CREATE TABLE TypeDebt (


ID INT IDENTITY(1,1) PRIMARY KEY,
[Type] VARCHAR(255),
isDelete bit,
CreatedAt DATETIME,
CreatedBy VARCHAR(255),
UpdatedAt DATETIME,
DeletedAt DATETIME,
DeletedBy VARCHAR(255)
)

CREATE TABLE DebtBill (


ID INT IDENTITY(1,1) PRIMARY KEY,
IDDebtor INT,
IDTypeDebt INT,
Amount Float,
[Description] VARCHAR(MAX),
EvidenceImg VARBINARY(MAX),
DebtTerm DATETIME,
isDelete bit,
CreatedAt DATETIME,
CreatedBy VARCHAR(255),
UpdatedAt DATETIME,
DeletedAt DATETIME,
DeletedBy VARCHAR(255),
FOREIGN KEY (IDDebtor) REFERENCES Debtor(ID),
FOREIGN KEY (IDTypeDebt) REFERENCES TypeDebt(ID)
)

You might also like