dev-blog

Tables (4)

Category

  • PK (id) — BIGINT — Primary key — NOT NULL
  • (name) — VARCHAR(50)
  • (description) — VARCHAR(100)
  • (created_at) — DATETIME
  • (modified_at) — DATETIME

Comment

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT
  • FK (post_id) — BIGINT
  • (content) — VARCHAR(255)
  • (created_at) — DATETIME
  • (modified_at) — DATETIME
  • (deleted_at) — DATETIME

Post

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT
  • FK (category_id) — VARCHAR(255)
  • (title) — VARCHAR(100)
  • (content) — TEXT
  • (post_image) — VARCHAR(255)
  • (created_at) — DATETIME
  • (modified_at) — DATETIME
  • (deleted_at) — VARCHAR(255)

User

  • PK (id) — BIGINT — Primary key — NOT NULL
  • (email) — VARCHAR(50)
  • (password) — VARCHAR(100)
  • (nickname) — VARCHAR(20)
  • (profile_image) — VARCHAR(255)
  • (user_role) — ENUM('USER', 'ADMIN')
  • (created_at) — DATETIME
  • (modified_at) — DATETIME
  • (deleted_at) — DATETIME