nuvibe

테이블 (15)

archive_board

  • id — BIGINT
  • member_id — BIGINT
  • name — VARCHAR(100) — NOT NULL

board_image

  • id — BIGINT
  • board_id — BIGINT
  • image_id — BIGINT

chat_member

  • id — BIGINT
  • member_id — BIGINT
  • tribe_chat_id — BIGINT
  • joined_at — DATETIME
  • Key — 외래 키 → image.Key — NOT NULL

chat_message

  • id — BIGINT
  • tribe_chat_id — BIGINT
  • member_id — BIGINT
  • image_id — BIGINT
  • created_at — DATETIME
  • Key — 외래 키 → image.Key — NOT NULL

emoji_reaction

  • Key — 기본 키 — NOT NULL
  • id — BIGINT
  • image_id — BIGINT
  • member_id — BIGINT
  • type — VARCHAR(20)

image

  • Key — 기본 키 — NOT NULL
  • id — BIGINT
  • member_id — BIGINT
  • tag_id — BIGINT
  • mission_id — BIGINT
  • url — TEXT — NOT NULL
  • created_at — DATETIME
  • Key (Key2) — 외래 키 → emoji_reaction.Key — NOT NULL
  • id (id2) — BIGINT — 외래 키 → 사용자.id — NOT NULL

member_term

  • Key — 기본 키 — NOT NULL
  • id — BIGINT
  • member_id — BIGINT
  • term_id — BIGINT
  • agreed_at — DATETIME

mission

  • id — BIGINT
  • content — TEXT — NOT NULL
  • target_date — DATE — NOT NULL

notification

  • id — BIGINT
  • member_id — BIGINT
  • type — VARCHAR(20)
  • content — TEXT
  • is_read — BOOLEAN
  • created_at — DATETIME

scrap

  • id — BIGINT
  • member_id — BIGINT
  • image_id — BIGINT
  • created_at — DATETIME

social_account

  • id — BIGINT
  • member_id — BIGINT
  • provider — VARCHAR(20)
  • provider_id — VARCHAR(255)

tag

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • image_url — TEXT

terms

  • Key — 기본 키 — NOT NULL
  • id — BIGINT
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • is_required — BOOLEAN

tribe_chat

  • id — BIGINT
  • tag_id — BIGINT
  • version — INT
  • current_count — INT

사용자 (member)

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME
  • Field