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