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)