p2p방송

테이블 (14)

Block (Untitled2)

  • blocker (Key) — int — 외래 키 → User.user_idx — NOT NULL
  • blocked (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • blcoked_at (Field)

BookMark (Untitled6)

  • maker (Key) — int — 외래 키 → User.user_idx — NOT NULL
  • marked (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • create_at (Field)

Channel (Untitled5)

  • user_idx (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • title (Field)
  • bookmark (Field2)
  • like (Field3)
  • watch (Field4)
  • month_time (Field5)
  • total_time (Field6)
  • first_start_time (Field7)
  • last_broadcast_time (Field8)

Fan (Untitled9)

  • fan_idx (Key) — 기본 키 — NOT NULL
  • user_idx (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • ranking (Field)
  • level (Field2)
  • created_at (Field3)

FanGrade (Untitled10)

  • Key2 — 기본 키 — NOT NULL
  • user_idx (Key) — int — 외래 키 → User.user_idx — NOT NULL
  • level (Field)
  • mount (Field2)

Gift (Untitled4)

  • gift_idx (Key3) — 기본 키 — NOT NULL
  • sender (Key) — int — 외래 키 → User.user_idx — NOT NULL
  • receiver (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • coin (Field)
  • created_at (Field2)

IVS Channel (Untitled7)

  • user_idx (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • arn (Field)
  • ingestEndpoint (Field2)
  • name (Field3)
  • stream_key (Field5)
  • playback_url (Field4)

Notice (Untitled8)

  • notice_idx (Key2) — 기본 키 — NOT NULL
  • user_idx (Key) — int — 외래 키 → User.user_idx — NOT NULL
  • title (Field)
  • content (Field2)

Post (Untitled3)

  • post_idx (Key3) — 기본 키 — NOT NULL
  • sender (Key) — int — 외래 키 → User.user_idx — NOT NULL
  • receiver (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • content (Field)
  • isRead (Field2)
  • created_at (Field3)

Stream (Untitled14)

  • user_idx (Key) — int — 외래 키 → User.user_idx — NOT NULL
  • view_cnt (Field9)
  • play_cnt (Field2)
  • like_cnt (Field3)
  • thumbnail (Field5)
  • isAdult (Field6)
  • isLive (Field8)
  • isPw (Field7)
  • start_time (Field)
  • live_type (Field4)

Terms (Untitled13)

  • terms_idx (Key) — 기본 키 — NOT NULL
  • user_temr_idx (Key2) — 외래 키 → UserTerms.user_temr_idx — NOT NULL
  • version (Field)
  • content (Field2)
  • effectvie_date (Field3)
  • created_at (Field4)

User (Untitled)

  • user_idx (Key) — int — 기본 키 — NOT NULL
  • id (Field)
  • password (Field2) — string
  • nickname (Field3)
  • profileImg (Field7)
  • isBj (Field8)
  • coinHave (Field9)
  • coinUse (Field10)
  • profile_img (Field11)
  • oauth_provider (Field4)
  • oauth_provider_id (Field5)

UserDetail (Untitled11)

  • user_detail_idx (Key) — 기본 키 — NOT NULL
  • user_idx (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • name (Field)
  • sex (Field2)
  • phone (Field3)
  • resident_number (Field4)
  • email (Field5)
  • address (Field6)
  • created_at (Field7)

UserTerms (Untitled12)

  • user_temr_idx (Key) — 기본 키 — NOT NULL
  • user_idx (Key2) — int — 외래 키 → User.user_idx — NOT NULL
  • agreed_at (Field)