Capstone No.1
Tables (7)
accommodation
- idAccommodation — int — Primary key — NOT NULL
- idUser — int — NOT NULL
- location — varchar(255) — NOT NULL
- price_per_night — decimal(10,2) — NOT NULL
- available_dates — date
- details — text
- photo — varchar(255)
- categories — enum('products','accomodation','products') — NOT NULL
- latitude — decimal(9,6)
- longitude — decimal(9,6)
answer
- idAnswer — int — Primary key — NOT NULL
- idRequest — int — Foreign key → request.idRequest — NOT NULL
- idProducts — int — Foreign key → products.idProducts
- idBids — int
- idAccomodation — int — Foreign key → accommodation.idAccommodation
- idTutoring — int — Foreign key → tutoring.idTutoring
board
- idUser — int
- location — varchar(255)
- price_per_night — decimal(10,2)
- available_dates — date
- details — text
- photo — varchar(255)
- idCategories — int
- idProducts — int
- title — varchar(255)
- price — decimal(10,2)
- status — varchar(100)
- idTutoring — int
- subject — varchar(255)
- price_per_hour — decimal(10,2)
- availability — text
products
- idProducts — int — Primary key — NOT NULL
- idUser — int — NOT NULL
- title — varchar(255) — NOT NULL
- price — decimal(10,2) — NOT NULL
- status — varchar(100) — NOT NULL
- details — text
- photo — varchar(255)
- categories — enum('products','accomodation','products') — NOT NULL
- latitude — decimal(9,6)
- longitude — decimal(9,6)
request
- idRequest — int — Primary key — NOT NULL
- idProducts — int — Foreign key → products.idProducts
- idAccomodation — int — Foreign key → accommodation.idAccommodation
- idTutoring — int — Foreign key → tutoring.idTutoring
- created_at — timestamp
- expires_at — timestamp — NOT NULL
- bid — decimal(10,2)
- status — varchar(50)
tutoring
- idTutoring — int — Primary key — NOT NULL
- idUser — int — NOT NULL
- subject — varchar(255) — NOT NULL
- price_per_hour — decimal(10,2) — NOT NULL
- availability — text
- details — text
- photo — varchar(255)
- categories — enum('products','accomodation','products') — NOT NULL
- latitude — decimal(9,6)
- longitude — decimal(9,6)
user
- idUser — int — Primary key — NOT NULL
- pw — varchar(255) — NOT NULL
- role — enum('consumer','provider','admin') — NOT NULL
- created_at — timestamp
- name — varchar(100) — NOT NULL
- age — int
- email — varchar(100) — NOT NULL
- nickname — varchar(45) — NOT NULL
- phonenumber — varchar(11) — NOT NULL
- profile_photo — varchar(255)