스트리머
테이블 (10)
Chats
- id — INT
- user_id — INT
- stream_id — INT
- message — TEXT
- timestamp — TIMESTAMP
Comments
- id — INT
- post_id — INT
- user_id — INT
- content — TEXT
- timestamp — TIMESTAMP
Donations
- id — INT
- user_id — INT
- stream_id — INT
- amount — DECIMAL(10,2)
- message — TEXT
- timestamp — TIMESTAMP
OAuth
- id — INT
- user_id — INT
- provider — VARCHAR(255)
- provider_id — VARCHAR(255)
Payments
- id — INT
- user_id — INT
- amount — DECIMAL(10,2)
- timestamp — TIMESTAMP
Posts
- id — INT
- studio_id — INT
- title — VARCHAR(255)
- content — TEXT
- timestamp — TIMESTAMP
Streams
- id — INT
- title — VARCHAR(255)
- category — VARCHAR(255)
- start_time — TIMESTAMP
- viewer_count — INT
- streamer_id — INT
- streaming_type — ENUM('Cam', 'Screen')
Studios
- id — INT
- user_id — INT
- name — VARCHAR(255)
- description — TEXT
Subscriptions
- id — INT
- user_id — INT
- streamer_id — INT
Users
- id — INT
- password — VARCHAR(255)
- nickname — VARCHAR(255)
- email — VARCHAR(255)
- profile_picture — VARCHAR(255)
- role — ENUM('User', 'Streamer')