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