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