MyBlog

Tables (3)

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • comment_id (parent_id) — BIGINT — Foreign key → comment.comment_id — NOT NULL
  • content — TEXT
  • like_count — INT
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • modified_at (modefied_at) — TIMESTAMP
  • depth — INT

post (post_id)

  • post_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • title — VARCHAR(50)
  • content — TEXT
  • thumbnail_url — VARCHAR(512)
  • view_count
  • like_count
  • is_published — BOOLEAN
  • create_at — TIMESTAMP
  • modified_at — TIMESTAMP

user

  • user_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50)
  • password — VARCHAR(255)
  • email — VARCHAR(100)
  • nickname — VARCHAR(50)
  • role — ENUM('ADMIN', 'GUEST')
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP