ㅇㄹ
Tables (4)
bookmarks
- bookmark_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- website_id — BIGINT — Foreign key → websites.website_id — NOT NULL
- created_at — DATETIME
comments
- comment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- website_id — BIGINT — Foreign key → websites.website_id — NOT NULL
- parent_comment_id — BIGINT — Foreign key → comments.comment_id
- content — TEXT — NOT NULL
- created_at — DATETIME
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20)
- profile_image — VARCHAR(500)
- refresh_token — VARCHAR(255)
- provider — VARCHAR(20)
- provider_id — VARCHAR(255)
- created_at — DATETIME
websites
- website_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- url — VARCHAR(500) — NOT NULL
- description — TEXT
- logo_url — VARCHAR(500)
- category — VARCHAR(50)
- view_count — BIGINT
- bookmark_count — BIGINT
- comment_count — BIGINT
- status — VARCHAR(20)
- created_at — DATETIME