EnjoyTrip
Tables (8)
Myplace (Untitled3)
- pk — int — Primary key — NOT NULL
- user_id (id) — varchar(20) — Foreign key → User.user_id — NOT NULL
- lat — varchar(32) — NOT NULL
- lon — varchar(32) — NOT NULL
- title — varchar(100) — NOT NULL
- content — varchar(1000) — NOT NULL
- hit — int — NOT NULL
- date — date — NOT NULL
- created_at — date — NOT NULL
- image — varchar(256) — NOT NULL
Plan (plan)
- pk — int — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- content — varchar(1000)
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- user_id — varchar(20) — Foreign key → User.user_id — NOT NULL
- hit — int — NOT NULL
- theme — varchar(20) — NOT NULL
Plan_like (plan_like)
- pk — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → User.user_id — NOT NULL
- plan_pk — int — Foreign key → Plan.pk — NOT NULL
Plan_places (Untitled)
- pk — int — Primary key — NOT NULL
- content_id — int — Foreign key → attraction.content_id — NOT NULL
- plan_pk — int — Foreign key → Plan.pk — NOT NULL
- order — int — NOT NULL — 해당 여행 계획에 있는 여행지들의 순서
QnA (qna)
- pk — int — Primary key — NOT NULL
- title — varchar(100)
- content — varchar(1000) — NOT NULL
- category (Field) — varchar(32)
- user_id — varchar(20) — Foreign key → User.user_id — NOT NULL
QnA_comment (qna_comment)
- pk — int — Primary key — NOT NULL
- user_id (id) — varchar(20) — Foreign key → User.user_id — NOT NULL
- qna_pk — int — Foreign key → QnA.pk — NOT NULL
- content — content
- parent — int — Foreign key → QnA_comment.pk
- created_at (Field)
User (members)
- user_id (id) — varchar(20) — Primary key — NOT NULL
- password — varchar(256) — NOT NULL
- name — varchar(20) — NOT NULL
- email_id — varchar(20) — NOT NULL
- email_domain — varchar(20) — NOT NULL
- join_date — date — NOT NULL
- admin — tinyint(1) — NOT NULL
attraction (Untitled2)
- content_id — int — Primary key — NOT NULL