kakao
Tables (6)
auth
- auth_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- refresh_token — VARCHAR(512) — NOT NULL
- expired_at — DATETIME — NOT NULL
- revoked_at — DATETIME
- created_at — DATETIME — NOT NULL
comments
- comment_id — BIGINT
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
files
- file_id — BIGINT
- uploaded_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- size_bytes — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
post_likes
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- created_at — DATETIME — NOT NULL
posts
- post_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- image_file_id — BIGINT — Foreign key → files.file_id
- title — VARCHAR(26) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_file_id — BIGINT — Foreign key → files.file_id
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME