cafe

Tables (8)

categories

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

comment_likes

  • id — BIGINT
  • comment_id — BIGINT — Foreign key → comments.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

comments

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • parent_id — BIGINT — Foreign key → comments.id
  • content — TEXT — NOT NULL
  • like_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

post_likes

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

posts

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

rank_categories

  • id — BIGINT
  • rank_id — BIGINT — Foreign key → ranks.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — NOT NULL
  • created_at — DATETIME — NOT NULL

ranks

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • birth_date — DATE
  • rank_id — BIGINT — Foreign key → ranks.id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME