☑Kizspy.me
1. User table: Account
2 of 2
Paper No: 1
Zoom
Field Name Type
Constrain
username
varchar(50)
password
fullName
Primary key,
not null
nvarchar(100) Not null
nvarchar(100) Not null
phone
nvarchar(20)
Description
used for system login
Password used for login
Member's full name
Phone number of the user
email
nvarchar(100)
status
role
bit
DefaultO
1:Active 0: Block
int
Default 2
1: Supervisor 2: Member
2. Rental room info table: RoomForRent
Field Name Type
id
INT
Constrain
Primary Key,
Validation
Description
Room ID: an integer that auto-increments.
+ 100%
Close
