policyNews_new!
테이블 (4)
Article
- article — id` — 기본 키 — NOT NULL
- result — code`
- result — msg`
- article — status`
- modify — Id`
- modify — date`
- approve — date`
- approver — name`
- EmbargoDate — DATETIME
- grouping — code`
- title — varchar
- subtitle1 — varchar
- subtitle2 — varchar
- subtitle3 — varchar
- type — varchar
- contents — varchar
- minister — code`
- article — url`
- bookmark — cnt`
- create — date`
- update — date`
Bookmark
- bookmark — id` — 기본 키 — NOT NULL
- category — id` — NOT NULL
- article — id` — NOT NULL
- create — date`
- update — date`
Category
- category — id` — 기본 키 — NOT NULL
- user — id` — 기본 키 — NOT NULL
- category — name`
- create — date`
- update — date`
회원 (User)
- user — id` — 기본 키 — NOT NULL
- password — varchar
- created_date (create date) — DATETIME
- updated_date (update date) — DATETIME
- Field