fisaschool
Tables (16)
ACCOUNT
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- cash_balance — DECIMAL(18, 2) — NOT NULL
- available_balance — DECIMAL(18, 2) — NOT NULL
- created_at — DATETIME — NOT NULL
AUDIT_LOG
- id — BIGINT — Primary key — NOT NULL
- admin_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- action — VARCHAR(100) — NOT NULL
- target_type — VARCHAR(50)
- target_id — BIGINT
- reason — TEXT
- created_at — DATETIME — NOT NULL
CONTEST
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- initial_seed — DECIMAL(18, 2) — NOT NULL
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
CONTEST_PARTICIPATION
- id — BIGINT — Primary key — NOT NULL
- contest_id — BIGINT — Foreign key → CONTEST.id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- seed_money — DECIMAL(18, 2) — NOT NULL
- profit_rate — DECIMAL(10, 4) — NOT NULL
- rank — INT
- joined_at — DATETIME — NOT NULL
CONTEST_STOCK
- id — BIGINT — Primary key — NOT NULL
- contest_id — BIGINT — Foreign key → CONTEST.id — NOT NULL
- stock_id — BIGINT — Foreign key → STOCK.id — NOT NULL
EXECUTION
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → ORDER_BOOK.id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- stock_id — BIGINT — Foreign key → STOCK.id — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(18, 2) — NOT NULL
- executed_at — DATETIME — NOT NULL
HOLDING
- id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Foreign key → ACCOUNT.id — NOT NULL
- stock_id — BIGINT — Foreign key → STOCK.id — NOT NULL
- quantity — INT — NOT NULL
- avg_price — DECIMAL(18, 2) — NOT NULL
- updated_at — DATETIME — NOT NULL
MEMBER
- id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255)
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- phone — VARCHAR(20)
- provider — VARCHAR(20)
- provider_id — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- login_fail_count — INT — NOT NULL
- email_verified — BOOLEAN — NOT NULL
- locked_at — DATETIME
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
NOTICE
- id — BIGINT — Primary key — NOT NULL
- admin_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- is_pinned — BOOLEAN — NOT NULL
- start_at — DATETIME
- end_at — DATETIME
- created_at — DATETIME — NOT NULL
NOTIFICATION
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- body — TEXT
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
NOTIFICATION_SETTING
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- execution_alert — BOOLEAN — NOT NULL
- order_cancel_alert — BOOLEAN — NOT NULL
- market_open_alert — BOOLEAN — NOT NULL
- contest_end_alert — BOOLEAN — NOT NULL
- updated_at — DATETIME — NOT NULL
ORDER_BOOK
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- account_id — BIGINT — Foreign key → ACCOUNT.id — NOT NULL
- stock_id — BIGINT — Foreign key → STOCK.id — NOT NULL
- order_type — VARCHAR(20) — NOT NULL
- side — VARCHAR(10) — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(18, 2) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- kafka_topic — VARCHAR(100)
- created_at — DATETIME — NOT NULL
RANKING
- id — BIGINT — Primary key — NOT NULL
- contest_id — BIGINT — Foreign key → CONTEST.id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- profit_rate — DECIMAL(10, 4) — NOT NULL
- rank — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
SEED_HISTORY
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- admin_id — BIGINT — Foreign key → MEMBER.id
- amount — DECIMAL(18, 2) — NOT NULL
- reason — VARCHAR(200)
- created_at — DATETIME — NOT NULL
STOCK
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(20) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- market — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
WATCHLIST
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBER.id — NOT NULL
- stock_id — BIGINT — Foreign key → STOCK.id — NOT NULL
- created_at — DATETIME — NOT NULL