nomad
Tables (19)
Amenity (Untitled6)
- Key — Primary key — NOT NULL
- name (Field) — varchar
- description (Field2) — varchar
Booking (CopyOfUntitled11)
- booking_id (Key) — PK — Primary key — NOT NULL
- user (Key4) — FK — Foreign key → User.Key — NOT NULL
- name (Field) — varchar
- room (Key2) — manytomany — Foreign key → Room.room_id — NOT NULL
- experience (Key3) — manytomany — Foreign key → Experience.experience_id — NOT NULL
- check_in (Field2) — date
- check_out (Field3) — date
- experiences_time (Field4) — datetime
- guests (Field5) — Integer
BookingKindChoices (Untitled12)
- room (Field)
- experience (Field2)
- booking_id (Key) — PK — Foreign key → Booking.booking_id — NOT NULL
- user (Key4) — FK — Foreign key → Booking.user — NOT NULL
Category (Untitled)
- id — Primary key — NOT NULL
- name (Field) — varchar
- kind (Field2) — varchar
CategoryKindChoices (Enum)
- Rooms (Field)
- Experiences (Field2)
- id — Foreign key → Category.id — NOT NULL
ChattingRoom (Untitled14)
- chattingroom_id (Key2) — Integer — Primary key — NOT NULL
- user (Key) — manytomany — Foreign key → User.Key — NOT NULL
CurrencyChoices (Untitled10)
- WON (Field)
- USD (Field2)
- Key — Foreign key → User.Key — NOT NULL
Experience (Untitled3)
- experience_id (Key) — Integer — Primary key — NOT NULL
- country (Field) — varchar
- city (Field2) — varchar
- name (Field3) — varchar
- price (Field4) — PositiveInteger
- address (Field5) — varchar
- start (Field6) — Time
- end (Field7) — Time
- description (Field8) — text
- host (Field9) — User
- category (Field10) — Category
- perks (Field11) — Perk
GenderChoices (Untitled8)
- Male (Field)
- Female (Field2)
- Key — Foreign key → User.Key — NOT NULL
LanguageChoices (Untitled9)
- Korean (Field)
- English (Field2)
- Key — Foreign key → User.Key — NOT NULL
Message (Untitled15)
- user_id (Key) — Integer — Foreign key → User.Key — NOT NULL
- chattingroom_id (Key2) — Integer — Foreign key → ChattingRoom.chattingroom_id — NOT NULL
- text (Field) — text
Perk (Untitled5)
- Key — Primary key — NOT NULL
- name (Field) — varchar
- details (Field2) — varchar
- explanation (Field3) — text
- id (Key2) — Integer — Foreign key → Experience.experience_id — NOT NULL
Photo (Untitled13)
- photo_id (Key) — Integer — Primary key — NOT NULL
- experiece_id (Key2) — Integer — Foreign key → Experience.experience_id — NOT NULL
- room_id (Key3) — PK — Foreign key → Room.room_id — NOT NULL
- file (Field) — file
- description (Field2) — varchar
Reviews (Untitled4)
- Key — PK — Primary key — NOT NULL
- room (Key2) — FK — Foreign key → Room.room_id — NOT NULL
- user (Key3) — FK — Foreign key → User.Key — NOT NULL
- experience (Key4) — FK — Foreign key → Experience.experience_id — NOT NULL
- payload (Field4) — Text
- rating (Field5) — PositiveInteger
Room (Untitled2)
- room_id (Key) — PK — Primary key — NOT NULL
- name (Field) — varchar
- country (Field2) — varchar
- city (Field3) — varchar
- price (Field4) — PositiveInteger
- rooms (Field5) — PositiveInteger
- toilets (Field6) — PositiveInteger
- description (Field7) — Text
- address (Field8) — varchar
- pet_friendly (Field9) — Boolean
- kind (Field10) — varchar
- owner (Field11)
- amenities (Field12)
- Key (Key2) — Foreign key → Amenity.Key — NOT NULL
RoomKindChoices (Eclass)
- Key — Primary key — NOT NULL
- E ntire_place (Field)
- Private_room (Field2)
- Shared_room (Field3)
- Key (Key2) — Foreign key → Room.room_id — NOT NULL
User (Untitled7)
- Key — Primary key — NOT NULL
- firstname (Field) — varchar
- lastname (Field2) — varchar
- avatar (Field3) — Image
- name (Field4) — varchar
- ishost (Field5) — boolean
- gender (Field6) — Enum
- language (Field7) — Enum
- currency (Field8) — Enum
Video (CopyOfUntitled13)
- video_id (Key) — Integer — Primary key — NOT NULL
- experiece_id (Key2) — Integer — Foreign key → Experience.experience_id — NOT NULL
- file (Field) — file
- description (Field2) — varchar
Wishlist (Untitled11)
- Key — Primary key — NOT NULL
- user (Key4) — FK — Foreign key → User.Key — NOT NULL
- name (Field) — varchar
- room (Key2) — manytomany — Foreign key → Room.room_id — NOT NULL
- experience (Key3) — manytomany — Foreign key → Experience.experience_id — NOT NULL