capstone

Tables (10)

FAQ (Untitled5)

  • q_num (Key) — int(4) — Primary key — NOT NULL
  • question (Field) — text(1000) — NOT NULL
  • answer (Field2) — text(1000) — NOT NULL

chat_record (Untitled4)

  • send_email (Key) — varchr(30) — Foreign key → user_info.email — NOT NULL
  • recieve_email (Key2) — varchr(30) — Foreign key → user_info.email — NOT NULL
  • message (Field) — text(255) — NOT NULL
  • send_time (Field2) — datetime — NOT NULL

contact (Untitled6)

  • email (Key) — varchr(30) — Foreign key → user_info.email — NOT NULL
  • time (Field) — date — NOT NULL
  • name (Field2) — varchar(20) — NOT NULL
  • text (Field3) — text(255) — NOT NULL

place_review (Untitled10)

  • place (Key) — varchar(20) — Foreign key → travel_place(?).place — NOT NULL
  • email (Key2) — varchr(30) — Foreign key → user_info.email — NOT NULL
  • review (Field) — text(255) — NOT NULL
  • time (Field2) — datetime — NOT NULL

plan_details(?) (Untitled7)

  • plan_num (Key) — int(10) — Foreign key → plan_info.plan_num — NOT NULL

plan_info (Untitled3)

  • plan_num (Key) — int(10) — Primary key — NOT NULL
  • leader_email (Key2) — varchr(30) — Foreign key → user_info.email — NOT NULL
  • plan_name (Field2) — varchar(20)
  • date_start (Field3) — date — NOT NULL
  • date_end (Field4) — date
  • num_of_people (Field5) — int(3)
  • concept(컨셉) (Field) — varchar(20)

travel_place(?) (Untitled8)

  • place (Key) — varchar(20) — Primary key — NOT NULL
  • address (Field) — varchar(30) — NOT NULL
  • group(?) (Field2) — varchar(30)
  • details(?) (Field3) — text(1000)

user_info (Untitled)

  • email (Key) — varchr(30) — Primary key — NOT NULL
  • password (Field) — varchar(20) — NOT NULL
  • name (Field2) — varchar(20) — NOT NULL
  • address (Field3) — varchar(30) — NOT NULL
  • mobile_num (Field4) — int(15) — NOT NULL
  • birthday (Field5) — date() — NOT NULL

user_interest_place (Untitled9)

  • email (Key) — varchr(30) — Foreign key → user_info.email — NOT NULL
  • place (Key2) — varchar(20) — Foreign key → travel_place(?).place — NOT NULL

user_profile (Untitled2)

  • email (Key2) — varchr(30) — Foreign key → user_info.email — NOT NULL
  • travel_preference (Field) — varchar(20)
  • picture (Field2) — BLOB
  • plan_num (Key) — int(10) — Foreign key → plan_info.plan_num — NOT NULL