GDSC_DEVLOG

Tables (4)

article (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(100) — NOT NULL
  • content (Field2) — VARCHAR(50000) — NOT NULL
  • like_count (Field4) — INTEGER — NOT NULL
  • thumbnail_url (Key2) — VARCHAR(256) — NOT NULL
  • created_at (Field3) — TIMESTAMP — NOT NULL
  • updated_at (Field5) — TIMESTAMP

tag (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

taglist (Untitled3)

  • article_id (Key) — BIGINT — Foreign key → article.id — NOT NULL
  • tag_id (Key2) — Foreign key → tag.id — NOT NULL

view_log (Untitled4)

  • article_id (Key2) — BIGINT — Foreign key → article.id — NOT NULL
  • timestamp (Key) — TIMESTAMP — NOT NULL
  • ip_address (Key3) — CHAR(15) — NOT NULL