viewtist
Tables (14)
Alarm
- id — Long — Primary key — NOT NULL
- live_streaming_id — Long — NOT NULL
- user_id — Long — NOT NULL
- content — String
- created_at — datetime
- modified_at — datetime
ChatRoom
- id — Long — Primary key — NOT NULL
- stream_key — String
- streamer_id (스트리머 아이디) — Long
- user_id (시청자아이디) — Long
User
- id — Long — Primary key — NOT NULL
- account_id — Long — NOT NULL
- email — String
- nickname — String
- password — String
- profile_photo_url — String
- is_email_verified — boolean
- email_verification_token — String
- type — String
- created_at — datetime
- modified_at — datetime
account
- id — Long — Primary key — NOT NULL
- account_number — String
- name — String
- bank_name — String
- created_at — datetime
- modified_at — datetime
comment
- id — Long — Primary key — NOT NULL
- post_id — Long — NOT NULL
- user_id — Long — NOT NULL
- content — String
- created_at — datetime
- modified_at — datetime
image
- id — Long — Primary key — NOT NULL
- image_url — String
live_chat
- id — Long — Primary key — NOT NULL
- live_streaming_id — Long — NOT NULL
- user_id — Long — NOT NULL
- content — String
- created_at — datetime
- modified_at — datetime
live_streaming
- id — Long — Primary key — NOT NULL
- user_id — Long — NOT NULL
- title — Srting
- category — String
- start_at — datetime
- viewer_count — Long
- created_at — datetime
- modified_at — datetime
post
- id — Long — Primary key — NOT NULL
- studio_id — Long — NOT NULL
- titile — String
- content — String
- created_at — datetime
- modified_at — datetime
recived
- id — Long — Primary key — NOT NULL
- live_streaming_id — Long — NOT NULL
- user_id — Long — NOT NULL
- amount — Long
- balance_snapshot — Long
- send_user_id — Long
- transaction_message — String
- is_exchange — boolean
- state — String
- created_at — datetime
- modified_at — datetime
studio
- id — Long — Primary key — NOT NULL
- user_id — Long — NOT NULL
- subscribe_id — Long — NOT NULL
- stream_key — String
- name — String
- content — String
- is_streaming — boolean
- create_at — datetime
- modified_at — datetime
subscribe
- id — Long — Primary key — NOT NULL
- user_id — Long — NOT NULL
- live_streaming_user_id — String
- created_at — datetime
- modified_at — datetime
token_blacklist
- id — Long — Primary key — NOT NULL
- token — String
transaction
- id — Long — Primary key — NOT NULL
- user_id — Long — NOT NULL
- transaction_type — String
- amount — Long
- balance_snapshot — Long
- state — String
- created_at — datetime
- modified_at — datetime