Kizspy.me
Field Name Type
username
varchar(50)
password
not null
nvarchar(100) Not null
fullName
nvarchar(100) Not null
phone
nvarchar(20)
Constrain
Primary key,
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
Constrain
Validation
Description
Primary Key, Room ID: an integer that auto-increments.
null,
id
INT
not
title
price
location
nvarchar(100)
decimal(10,2)
nvarchar(150)
IDENTITY(1,1)
Not null
Not null
Not null
description nvarchar(MAX) Not null
posted Date
status
datetime
Int
| 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
Listing status:
Default 0
-2: Deleted
-1: Reported
0: Available
1: Rented
foreign key
2: Expired
Room listing poster (reference to the Account
table)
username varchar(50)
Not null,
Requirements:
Zoom
+ 90%
Close
