142

Tables (18)

accounts

  • id — NUMBER(19)
  • user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • balance — NUMBER(19, 2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id

boards

  • id — NUMBER(19)
  • name — VARCHAR2(100) — NOT NULL
  • description — VARCHAR2(255)
  • created_at — TIMESTAMP

comments

  • id — NUMBER(19)
  • post_id — NUMBER(19) — Foreign key → posts.id — NOT NULL
  • user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • content — VARCHAR2(1000) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id

competitions

  • id — NUMBER(19)
  • title — VARCHAR2(200) — NOT NULL
  • description — CLOB
  • start_at — TIMESTAMP — NOT NULL
  • end_at — TIMESTAMP — NOT NULL
  • initial_seed_money — NUMBER(19, 2) — NOT NULL
  • max_participants — NUMBER(10)
  • status — VARCHAR2(20) — NOT NULL
  • is_public — NUMBER(1) — NOT NULL
  • created_by_admin_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id

favorite_stocks

  • id — NUMBER(19) — Primary key
  • user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id
  • id (id3) — NUMBER(19) — Foreign key → stocks.id
  • id (id4) — NUMBER(19) — Foreign key → stocks.id

holdings

  • id — NUMBER(19) — Primary key
  • account_id — NUMBER(19) — Foreign key → accounts.id — NOT NULL
  • quantity — NUMBER(19) — NOT NULL
  • avg_price — NUMBER(19, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → accounts.id
  • id (id3) — NUMBER(19) — Foreign key → stocks.id
  • id (id4) — NUMBER(19) — Foreign key → stocks.id

inquiries

  • id — NUMBER(19)
  • user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • title — VARCHAR2(255) — NOT NULL
  • content — CLOB — NOT NULL
  • status — VARCHAR2(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id

inquiry_answers

  • id — NUMBER(19)
  • inquiry_id — NUMBER(19) — Foreign key → inquiries.id — NOT NULL
  • admin_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • content — CLOB — NOT NULL
  • created_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id

notifications

  • id — NUMBER(19)
  • user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • message — VARCHAR2(500) — NOT NULL
  • is_read — NUMBER(1)
  • created_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id

orders

  • id — NUMBER(19) — Primary key
  • account_id — NUMBER(19) — Foreign key → accounts.id — NOT NULL
  • order_type — VARCHAR2(20) — NOT NULL
  • price — NUMBER(19, 2) — NOT NULL
  • quantity — NUMBER(19) — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → accounts.id
  • id (id3) — NUMBER(19) — Foreign key → stocks.id
  • id (id4) — NUMBER(19) — Foreign key → stocks.id

portfolio_snapshots

  • id — NUMBER(19)
  • account_id — NUMBER(19) — Foreign key → accounts.id — NOT NULL
  • total_value — NUMBER(19, 2)
  • snapshot_date — DATE
  • created_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → accounts.id

post_attachments

  • id — NUMBER(19)
  • post_id — NUMBER(19) — Foreign key → posts.id — NOT NULL
  • file_path — VARCHAR2(500) — NOT NULL
  • created_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → posts.id

posts

  • id — NUMBER(19)
  • board_id — NUMBER(19) — Foreign key → boards.id — NOT NULL
  • user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • title — VARCHAR2(255) — NOT NULL
  • content — CLOB
  • view_count — NUMBER(19)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id

price_alerts

  • id — NUMBER(19)
  • user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • target_price — NUMBER(19, 2) — NOT NULL
  • is_active — NUMBER(1)
  • created_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id
  • id (id3) — NUMBER(19) — Foreign key → stocks.id
  • id (id4) — NUMBER(19) — Foreign key → stocks.id

reports

  • id — NUMBER(19)
  • reporter_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • target_type — VARCHAR2(50) — NOT NULL
  • target_id — NUMBER(19) — NOT NULL
  • reason — VARCHAR2(500) — NOT NULL
  • created_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id

stocks

  • id — NUMBER(19) — Primary key
  • code — VARCHAR2(20) — NOT NULL
  • name — VARCHAR2(100) — NOT NULL
  • current_price — NUMBER(19, 2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — NUMBER(19) — Primary key
  • email — VARCHAR2(255) — NOT NULL
  • password — VARCHAR2(255) — NOT NULL
  • name — VARCHAR2(100)
  • role — VARCHAR2(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

votes

  • id — NUMBER(19)
  • user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
  • target_type — VARCHAR2(50) — NOT NULL
  • target_id — NUMBER(19) — NOT NULL
  • is_upvote — NUMBER(1) — NOT NULL
  • created_at — TIMESTAMP
  • id (id2) — NUMBER(19) — Foreign key → users.id