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