NEWSLETTER

Tables (6)

Untitled (User-Keyword)

  • user_id — INT — Foreign key → User Table.user_id
  • Field (code) — INT — Foreign key → Untitled.Field

Untitled (Keyword)

  • Field (code) — INT — Primary key
  • Field (name) — VARCHAR

Untitled (News)

  • Field (news_id) — INT — Primary key
  • Field (category_id) — INT — Foreign key → Untitled.Field
  • Field (title) — VARCHAR
  • Field (press) — VARCHAR
  • Field (reporter) — VARCHAR
  • Field (content) — TEXT
  • Field (summary) — TEXT
  • Field (date) — DATETIME
  • Field (link) — VARCHAR
  • Field

Untitled (Category)

  • Field (category_id) — INT — Primary key
  • Field (name) — VARCHAR

Untitled (News-Keyword)

  • Field (news_id) — INT — Foreign key → Untitled.Field
  • Field (code) — INT — Foreign key → Untitled.Field

User Table (User)

  • user_id — INT — Primary key
  • id — VARCHAR
  • pw — VARCHAR
  • email — VARCHAR
  • date — DATETIME