utoplan
Tables (5)
inquiry (Untitled2)
- inquiry_id (Key) — PK — Primary key — NOT NULL
- q_detail (Field)
- q_name (Field2)
- id (Key2) — PK — Foreign key → user.id — NOT NULL
place (Untitled4)
- id (Key) — PK — Primary key — NOT NULL
- image_url (Field)
- latitude (Field2)
- longitude (Field3)
- name (Field4)
- id (Key2) — PK — Foreign key → plan.id — NOT NULL
plan (Untitled3)
- id (Key) — PK — Primary key — NOT NULL
- date (Field)
- day (Field2)
- id (Key2) — PK — Foreign key → user.id — NOT NULL
trip
- trip_id (Key) — PK — Primary key — NOT NULL
- adult (Field)
- kid (Field2)
- end_date (Field3)
- start_date (Field4)
- trip_city (Field5)
- trip_name (Field6)
- trip_place (Field7)
- trip_style (Field8)
- id (Key2) — PK — Foreign key → user.id — NOT NULL
user (Untitled)
- id (Key) — PK — Primary key — NOT NULL
- user_email (Field)
- user_id (Field2)
- user_pw (Field3)