☑Kizspy.me
2 of 2
Paper No: 1
Zoom
Field Name Type
username
varchar(50)
Constrain
Primary key,
not null
Description
used for system login
Password used for login
Member's full name
Phone number of the user
password
nvarchar(100) Not null
fullName
nvarchar(100) Not null
phone
nvarchar(20)
email
nvarchar(100)
status
role
bit
DefaultO
int
Default 2
1: Supervisor 2: Member
1:Active 0: Block
2. Rental room info table: RoomForRent
Field Name Type
Constrain
Validation
Description
id
INT
Primary Key, Room ID: an integer that auto-increments.
not null,
IDENTITY(1,1)
title
nvarchar(100) Not null
price
decimal(10,2) Not null
location nvarchar(150) Not null
description nvarchar(MAX) Not null
posted Date datetime
Title (e.g., "Phòng trọ 25m2, Q1")
Rental price (VND/month)
Rental address (House number, Street name,
District name, City)
Detailed description of the room for rent
Listing date and time
status
+ 100%
Int
Default 0
Listing status:
Close
