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