DB
Tables (5)
Account table (Account_tb)
- 유저 UUID (user_uuid) — UUID — Primary key — NOT NULL
- 유저 Email (user_email) — VARCHAR(255) — NOT NULL
- 유저 password (password) — VARCHAR(255) — NOT NULL
- 유저 ID (user_id) — VARCHAR(40) — NOT NULL
- 메인 세션 uuid (main_session_uuid) — UUID — 메인 세션
- is_premium — TINYINT(1) — NOT NULL — 0 : not premium 1 : premium
Account_portfolio (portfolio_tb)
- portfolio uuid (portfolio_uuid) — UUID — Primary key — NOT NULL
- 유저 UUID (user_uuid) — UUID — Foreign key → Account table.유저 UUID — NOT NULL
- portfolio file path (portfolio_file_path) — VARCHAR(225) — NOT NULL
Session table (session_tb)
- 세션 uuid (session_uuid) — UUID — Primary key — NOT NULL
- 세션 인원 (session_current) — INT(11) — NOT NULL
- 세션 비번 (session_password) — VARCJAR(255) — 비번이 없을경우 NULL
- 세션 최대 인원 (session_max_limit) — INT(11) — NOT NULL
Session_Account (Session_Account_tb)
- UUID (uuid) — UUID — Primary key — NOT NULL
- 유저 UUID (user_uuid) — UUID — Foreign key → Account table.유저 UUID — NOT NULL
- 세션 uuid (session_uuid) — UUID — Foreign key → Session table.세션 uuid — NOT NULL
- 세션 내 포지션 (position) — VARCHAR(40) — NOT NULL
- 알람 (Alert) — TINYINT(1) — NOT NULL — 0 : 알람 OFF 1 : 알람 ON
User Fllow table (user_follow_tb)
- follow uuid (follow_uuid) — UUID — Primary key — NOT NULL
- 유저 UUID (user_uuid) — UUID — Foreign key → Account table.유저 UUID — NOT NULL
- followeduser uuid (followeduser_uuid) — UUID — NOT NULL