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