sweep

테이블 (11)

Perspectives (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • battle_id (Key2) — 외래 키 → 배틀.id — NOT NULL
  • user_id (Key3) — 외래 키 → Users.id — NOT NULL
  • option_id (Key4) — 외래 키 → 배틀 옵션.id — NOT NULL
  • context (Field)
  • like_count (Field2)
  • comment_count (Field3)
  • status (Field4)
  • created_at (Field5)
  • updated_at (Field6)

Users (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • email (Field)
  • nickname (Field2)
  • character_id (Field3)
  • role (Field4)
  • status (Field5)
  • created_at (Field6)
  • updated_at (Field7)

관점 댓글 (Untitled11)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (Field)
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • perspective_id (Key2) — 외래 키 → Perspectives.id — NOT NULL
  • user_id (Key3) — 외래 키 → Users.id — NOT NULL

배틀 (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • title (Field)
  • summary (Field2)
  • description (Field3)
  • thumbnail_url (Field4)
  • target_date (Field5)
  • status (Field6)
  • creator_type (Field7)
  • creator_id (Field8)
  • reject_reason (Field9)
  • created_at (Field10)
  • updated_at (Field11)

배틀 옵션 (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • battle_id (Field)
  • label (Field2)
  • title (Field3)
  • stance (Field4)
  • representative (Field5)
  • quote (Field6)
  • keywords (Field7)
  • image_url (Field8)

배틀-태그 (Untitled8)

  • id (Key2) — 외래 키 → 태그.id — NOT NULL
  • id (Key) — 외래 키 → 배틀.id — NOT NULL

시나리오 (Untitled5)

  • Key — 기본 키 — NOT NULL
  • battle_id (Field)
  • creator_id (Field2)
  • creator_type (Field3)
  • is_interactive (Field4)
  • status (Field5)
  • reject_reason (Field6)
  • created_at (Field7)
  • updated_at (Field8)

시나리오 노드 (Untitled6)

  • id (Key) — 기본 키 — NOT NULL
  • scenario_id (Field)
  • node_name (Field2)
  • audio_url (Field3)
  • audio_duration (Field4)
  • is_start_node (Field5)
  • interactive_options (Field6)

퀴즈 (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • Field

태그 (Untitled7)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • created_at (Field2)

투표이력 (Untitled9)

  • id (Key) — 기본 키 — NOT NULL
  • pre_vote_option_id (Field3)
  • post_vote_option_id (Field4)
  • mind_changed (Field5)
  • reward_credits (Field6)
  • status (Field7)
  • created_at (Field8)
  • updated_at (Field9)
  • user_id (Key2) — 외래 키 → Users.id — NOT NULL
  • battle_id (Key3) — 외래 키 → 배틀.id — NOT NULL
  • id (Key4) — 외래 키 → 배틀 옵션.id — NOT NULL