청춘

테이블 (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