dashborad
Tables (4)
comments
- id — BIGINT
- post_id — BIGINT — Foreign key — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- id (id2) — BIGINT — Foreign key → users.id
- id (id3) — BIGINT — Foreign key → users.id
- Key — Foreign key → posts.id — NOT NULL
files
- id — BIGINT
- post_id — BIGINT — Foreign key — NOT NULL
- original_name — VARCHAR(255)
- stored_name — VARCHAR(255)
- file_path — VARCHAR(500)
- file_size — BIGINT
- content_type — VARCHAR(100)
- created_at — DATETIME
- id (id2) — BIGINT — Foreign key → users.id
- id (id3) — BIGINT — Foreign key → users.id
- Key — Foreign key → posts.id — NOT NULL
posts
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- is_pinned — BOOLEAN
- id (id2) — BIGINT — Foreign key → users.id
- id (id3) — BIGINT — Foreign key → users.id
users
- id — BIGINT — Primary key
- user_id — BIGINT
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME