☑Kizspy.me
phone
nvarchar(20)
email
status
nvarchar(100)
bit
DefaultO
role
int
Default 2
Zoom
Phone number of the user
2. Rental room info table: RoomForRent
Field Name Type
1:Active
0: Block
1: Supervisor - 2: Member
Constrain
Validation
Description
id
INT
title
price
location
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
Rental price (VND/month)
description nvarchar(MAX) Not null
posted Date datetime
status
Int
Default 0
username
varchar(50)
Not null,
foreign key
Title (e.g., "Phòng trọ 25m2, Q1")
Rental address (House number, Street name,
District name, City)
Detailed description of the room for rent
Listing date and time
Listing status:
-2: Deleted
-1: Reported
0: Available
1: Rented
2: Expired
Room listing poster (reference to the Account
table)
Requirements:
Create a Java web application, which can be used to manage the Room for Rent. The application
have the following functions:
+ 100%
Close
