GuessGuest

Tables (3)

house (Untitled2)

  • house_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • reserve_url (Field2) — varchar
  • total_user (Field3) — int
  • male (Field4) — int
  • female (Field5) — int
  • korean (Field6) — int
  • chinese (Field7) — int
  • japanese (Field8) — int
  • mbti_e (Field9) — int
  • mbti_i (Field10) — int
  • age_20 (Field11) — int
  • age_30 (Field12) — int
  • age_40 (Field13) — int
  • solo (Field14) — int
  • not_solo (Field15) — int

reservation (Untitled3)

  • reservation_id (Key3) — int — Primary key — NOT NULL
  • user_id (Key) — int — Foreign key → user.user_id — NOT NULL
  • house_id (Key2) — int — Foreign key → house.house_id — NOT NULL
  • start_date (Field) — date
  • end_date (Field2) — date

user (Untitled)

  • user_id (Key) — int — Primary key — NOT NULL
  • nickname (Field) — varchar
  • phone_number (Field6) — varchar
  • gender (Field2) — boolean
  • age (Field3) — int
  • is_solo (Field4) — boolean
  • hate (Field5) — int
  • food (Field8) — enum
  • mbti (Field7) — enum
  • visit_place (Field9) — varchar
  • description (Field10) — text