umc-hackathon-three-out

테이블 (3)

감정 기록 (record)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Field (sticker) — string
  • Field — string
  • Key (id2) — uuid — 외래 키 → 친구.Key — NOT NULL
  • Key (user_id) — uuid — 외래 키 → 유저.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

유저 (user)

  • Key (user_id) — uuid — 기본 키 — NOT NULL
  • Field (login_id) — string — NOT NULL
  • Field (password) — string — NOT NULL
  • Field (email) — string
  • Field (name) — string
  • Field (nickname) — string
  • Field (promise) — string
  • Field (status) — boolean
  • Field (inactive_date) — datetime
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (refresh_token)

친구 (friend)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Key (user_id) — uuid — 외래 키 → 유저.Key — NOT NULL
  • Field (name) — string — NOT NULL
  • Field (nickname) — string
  • Field (favor) — int
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)