☑Kizspy.me
phone
nvarchar(20)
email
status
nvarchar(100)
bit
DefaultO
Phone number of the user
1:Active 0: Block
role
int
Default 2
1: Supervisor 2: Member
Zoom
2. Rental room info table: RoomForRent
Field Name Type
Validation Description
Constrain
id
INT
title
price
location
Default 0
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
Primary Key, Room ID: an integer that auto-increments.
not null,
IDENTITY(1,1)
nvarchar(100) Not null
decimal(10,2) Not null
nvarchar(150) Not null
Listing status:
-2: Deleted
-1: Reported
0: Available
1: Rented
2: Expired
Room listing poster (reference to the Account
username varchar(50)
Notnull,
foreign key
table)
Requirements:
+100%
Close
