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)