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