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