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