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