청춘
테이블 (6)
bucket_items
- bucket_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- emoji_index — INT — NOT NULL
- color_index — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- started_at — DATETIME
- completed_at — DATETIME
friends
- friend_id — BIGINT — 기본 키 — NOT NULL
- requester_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- receiver_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
post_likes
- like_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → posts.post_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- created_at — DATETIME — NOT NULL
posts
- post_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- bucket_id — BIGINT — 외래 키 → bucket_items.bucket_id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- review_text — VARCHAR(255)
- visibility — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
posts_friends_tag
- posts_friends_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → posts.post_id — NOT NULL
- friend_id — BIGINT — 외래 키 → friends.friend_id — NOT NULL
users
- user_id — BIGINT — 기본 키 — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- challenged_count — INT — NOT NULL
- completed_count — INT — NOT NULL
- emoji_index — INT — NOT NULL
- color_index — INT — NOT NULL
- updated_at — DATETIME
- created_at — DATETIME — NOT NULL