프로젝트1

테이블 (9)

Article

  • num — bigint — 기본 키 — NOT NULL
  • user_num — bigint — 외래 키 → users.num — NOT NULL
  • tripPackage_num — bigint — 외래 키 → TripPackage.num
  • title — varchar(100)
  • place — varchar(20)
  • content — MEDIUMTEXT
  • thumbnail — varchar(500)
  • temp — boolean
  • created_at — timestamp
  • date_start — timestamp
  • date_end — timestamp
  • like_count — int
  • views — int
  • user_nickname — varchar(15) — NOT NULL

BlogInfo

  • num — bigint — 기본 키 — NOT NULL
  • user_num — bigint — 외래 키 → users.num — NOT NULL
  • title — varchar(100)
  • title_img — varchar(500)
  • visit_count — int

Comment

  • num — bigint — 기본 키 — NOT NULL
  • user_num — bigint — 외래 키 → users.num — NOT NULL
  • article_num — bigint — 외래 키 → Article.num — NOT NULL
  • content — varchar(1000)
  • user_nickname — varchar(15) — NOT NULL
  • user_email — varchar(40) — NOT NULL
  • user_img — varchar(500)
  • created_at — timestamp
  • reply_num — bigint
  • paragraph — text

Pre_Article

  • num — bigint — 기본 키 — NOT NULL
  • user_num — bigint — 외래 키 → users.num — NOT NULL
  • date — timestamp
  • comment — varchar(1000)
  • place — varchar(20)
  • media — varchar(500) — NOT NULL

TripPackage

  • num — bigint — 기본 키 — NOT NULL
  • user_num — bigint — 외래 키 → users.num — NOT NULL
  • name — varchar(15)

TripPackageScooped

  • user_num — bigint — 외래 키 → users.num — NOT NULL
  • tripPackage_num — bigint — 외래 키 → TripPackage.num — NOT NULL

like_Article

  • user_num — bigint — 외래 키 → users.num — NOT NULL
  • article_num — bigint — 외래 키 → Article.num — NOT NULL

neighbor

  • num — bigint — 기본 키 — NOT NULL
  • user_num — bigint — 외래 키 → users.num — NOT NULL
  • neighbor_num — bigint
  • neighbor_nickname — varchar(15)

users

  • num — bigint — 기본 키 — NOT NULL
  • email — varchar(40)
  • name — varchar(40)
  • nickname — varchar(15)
  • password — varchar(100)
  • intro — varchar(1000) — NOT NULL
  • imageSrc — varchar(500) — NOT NULL
  • mainPost — int — NOT NULL
  • valid — boolean — NOT NULL
  • created_at — timestamp — NOT NULL