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)