ㄴㄴㄴ

테이블 (6)

Copy Of 태그 (CopyOfTag)

  • tag_id (tag id) — varchar — 기본 키 — NOT NULL
  • name (tag name) — varchar
  • bookmark_id (bookmark id) — varchar — 외래 키 → 즐겨찾기.bookmark_id — NOT NULL
  • created_date (create date) — DATETIME
  • updated_date (update date) — DATETIME

기사 (Article)

  • id (article id) — varchar — 기본 키 — NOT NULL
  • result_code (result code) — varchar
  • result_msg (result msg) — varchar
  • status (article status) — varchar
  • mod_cnt (modify Id) — varchar
  • mod_date (modify date) — DATETIME
  • app_date (approve date) — DATETIME
  • app_name (approver name) — varchar
  • valid_date (EmbargoDate) — DATETIME
  • group_cd (grouping code) — varchar
  • title — varchar
  • s_title1 (subtitle1) — varchar
  • s_title2 (subtitle2) — varchar
  • s_title3 (subtitle3) — varchar
  • type — varchar
  • contents — varchar
  • minister_cd (minister code) — varchar
  • url (article url) — varchar
  • bookmark_cnt (bookmark cnt) — BIGINT
  • created_date (create date) — DATETIME
  • updated_date (update date) — DATETIME

즐겨찾기 (Bookmark)

  • bookmark_id (bookmark id) — varchar — 기본 키 — NOT NULL
  • created_date (create date) — DATETIME
  • updated_date (update date) — DATETIME
  • Field
  • category_id (category id) — varchar — 외래 키 → 카테고리.category_id — NOT NULL
  • id (article id) — varchar — 외래 키 → 기사.id — NOT NULL
  • id (article id2) — varchar — 외래 키 → 기사.id — NOT NULL
  • id (article id3) — varchar — 외래 키 → 기사.id — NOT NULL
  • id (article id32) — varchar — 외래 키 — NOT NULL

카테고리 (Category)

  • category_id (category id) — varchar — 기본 키 — NOT NULL
  • id (article id3) — varchar — 외래 키 → 기사.id — NOT NULL
  • name (category name) — varchar
  • created_date (create date) — DATETIME
  • updated_date (update date) — DATETIME
  • user_id (user id) — varchar — 외래 키 → 회원.user_id — NOT NULL
  • id (article id) — varchar — 외래 키 → 기사.id — NOT NULL
  • id (article id2) — varchar — 외래 키 → 기사.id — NOT NULL

태그 (Tag)

  • tag_id (tag id) — varchar — 기본 키 — NOT NULL
  • name (tag name) — varchar
  • bookmark_id (bookmark id) — varchar — 외래 키 → 즐겨찾기.bookmark_id — NOT NULL
  • created_date (create date) — DATETIME
  • updated_date (update date) — DATETIME

회원 (User)

  • user_id (user id) — varchar — 기본 키 — NOT NULL
  • name (user name) — varchar
  • password — varchar
  • created_date (create date) — DATETIME
  • updated_date (update date) — DATETIME