playground-erd
Tables (10)
answer
- id — BIGINT — Primary key
- question_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- accepted — BOOLEAN — NOT NULL
- deleted — BOOLEAN — NOT NULL
- report_count — INT — NOT NULL
- like_count — INT — NOT NULL
- dislike_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
comments
- id — BIGINT — Primary key
- answer_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- deleted — BOOLEAN — NOT NULL
- like_count — INT — NOT NULL
- dislike_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification
- id — BIGINT — Primary key
- receiver_id — BIGINT — NOT NULL
- sender_id — BIGINT
- type — VARCHAR(20) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
question
- id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- view_count — BIGINT — NOT NULL
- report_count — INT — NOT NULL
- like_count — INT — NOT NULL
- dislike_count — INT — NOT NULL
- accepted_answer_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
reaction
- id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT — NOT NULL
- reaction_type — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
refresh_tokens
- id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- token — VARCHAR(255) — NOT NULL
- expired_at — DATETIME — NOT NULL
reports
- id — BIGINT — Primary key
- reporter_user_id — BIGINT — NOT NULL
- reported_user_id — BIGINT — NOT NULL
- entity_id — BIGINT — NOT NULL
- entity_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- category — VARCHAR(20) — NOT NULL
- detail — TEXT
- created_at — DATETIME — NOT NULL
roles
- id — BIGINT — Primary key
- name — VARCHAR(50) — NOT NULL
user_roles
- id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- role_id — BIGINT — NOT NULL
users
- id — BIGINT — Primary key
- nickname — VARCHAR(100) — NOT NULL
- login_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100)
- joined_date — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
- deleted_at — DATETIME
- provider — VARCHAR(50)
- provider_id — VARCHAR(255)