clonebnb

Tables (4)

Accommodation (Untitled2)

  • accId (Key) — String — Primary key — NOT NULL
  • userId (Key2) — String — Foreign key → User.userId — NOT NULL
  • photos (input1) — Array
  • accName (input2) — String
  • openAt (input3) — Date
  • closeAt (input4) — Date
  • address (input5) — Date
  • desc1_hanmadi (input6) — String
  • desc2_surroundings (input7) — String
  • desc3_notice (input8) — String
  • desc4_basics (input9) — String
  • facilities (input10) — Array
  • charge (input11) — Number
  • Vacancy (auto-create) — Object

Reservation (Untitled3)

  • reserveId (Key) — String — Primary key — NOT NULL
  • accId (Key2) — String — Foreign key → Accommodation.accId — NOT NULL
  • userId (Key3) — String — Foreign key → Accommodation.userId — NOT NULL
  • checkIn (input1) — Date
  • checkOut (input2) — Date
  • guests (input3) — Number
  • charge (input4) — Number
  • totalCharge (input5) — Number

Review (Untitled4)

  • reviewId (Key) — String — Primary key — NOT NULL
  • accId (Key2) — String — Foreign key → Accommodation.accId — NOT NULL
  • userId (Key3) — String — Foreign key → Accommodation.userId — NOT NULL
  • photos (input1) — Array
  • content (input2) — String
  • stars (input3) — Number

User (Untitled)

  • userId (Key) — String — Primary key — NOT NULL
  • password (input2) — String
  • name (input3) — String
  • birth (input4) — Date
  • gender (input5) — String
  • reservations (input6) — Array
  • accommodations (input7) — Array