airbnb

Tables (4)

lodging (Untitled)

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(128)
  • location — VARCHAR(128)
  • latitude — DECIMAL(18, 15)
  • longitude — DECIMAL(18, 15)
  • imageUrl — VARCHAR(256)
  • startDate — DATE
  • endDate — DATE
  • maxPersonnel — INT
  • options — VARCHAR(128)
  • pricePerDay — INT
  • averageStar — DECIMAL(3, 2)
  • reviewCount — INT

reservation (Untitled3)

  • id — INT — Primary key — NOT NULL
  • userId — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • lodgingId — INT — Foreign key → lodging.id — NOT NULL
  • checkin — DATE
  • checkout — DATE
  • guestCount — INT
  • totalPrice — INT

user (Untitled2)

  • id — VARCHAR(32) — Primary key — NOT NULL
  • password — VARCHAR(128)
  • salt — VARCHAR(128)

wishlist (Untitled4)

  • userId — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • lodgingId — INT — Foreign key → lodging.id — NOT NULL