LimSR12-log

Tables (6)

archives

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • source_url — VARCHAR(500)
  • type — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

categories

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

portfolios

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • thumbnail — VARCHAR(500)
  • github_url — VARCHAR(500)
  • demo_url — VARCHAR(500)
  • tech_stack — TEXT
  • started_at — DATE
  • ended_at — DATE
  • sort_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

post_tags

  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tags.id — NOT NULL

posts

  • id — BIGINT
  • category_id — BIGINT — Foreign key → categories.id
  • title — VARCHAR(255) — NOT NULL
  • slug — VARCHAR(300) — NOT NULL
  • content — TEXT — NOT NULL
  • summary — VARCHAR(500)
  • thumbnail — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • published_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

tags

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL