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)