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