ㄴㄴㄴ
테이블 (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