easy-news
Tables (3)
Clicks (회원 클릭 관리)
- id (Key) — Auto Increment — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- news_id (Key3) — Foreign key → News.id — NOT NULL
- click_count (Field2)
News (뉴스)
- id (Key) — Auto Increment — Primary key — NOT NULL
- title (Field)
- content (Field2)
- category (Field3)
- sub_category (Field4)
- article_url (Field5)
- image_url (Field6) — nullable
- created_at (Field7)
User (회원)
- id (Key) — Auto Increment — Primary key — NOT NULL
- username (Field)
- password (Field2)
- nickname (Field3)
- interested_category (Field5)
- email (Field6)
- created_at (Field7)