likes

Tables (3)

article

  • id — int — Primary key — NOT NULL
  • title — VARCHAR(30)
  • date — DATE
  • content — VARCHAR(255)

like

  • user_article — int — Primary key — NOT NULL
  • id (user_id) — int — Foreign key → users.id — NOT NULL
  • id (article_id) — int — Foreign key → article.id — NOT NULL

users

  • id — int — Primary key — NOT NULL
  • name — VARCHAR(30)
  • email — VARCAHR(50)