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