☑Kizspy.me
Field Name Type
username
varchar(50)
password
not null
nvarchar(100) Not null
fullName
nvarchar(100) Not null
phone
nvarchar(20)
email
nvarchar(100)
status
bit
Default
Constrain
Primary key,
Description
used for system login
Password used for login
Member's full name
Phone number of the user
1:Active 0: Block
role
int
Default 2
1: Supervisor 2: Member
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,
title
price
location
IDENTITY(1,1)
nvarchar(100) Not null
decimal(10,2) Not null
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
Zoom
+ 100%
Int
Default 0
Listing status:
-2: Deleted
-1: Reported
0: Available
1. Rented
Close
