테스트
테이블 (8)
AlertSettings
- alert_id — INT
- user_id — INT — NOT NULL
- condition_description — VARCHAR(255) — NOT NULL
- is_active — BOOLEAN
- created_at — TIMESTAMP
ApiLogs
- api_log_id — BIGINT
- endpoint — VARCHAR(100) — NOT NULL
- response_status — INT — NOT NULL
- response_time_ms — INT — NOT NULL
- requested_at — TIMESTAMP
FinancialData
- data_id — BIGINT
- symbol — VARCHAR(10) — NOT NULL
- market — VARCHAR(50) — NOT NULL
- price — DECIMAL(15, 2) — NOT NULL
- volume — BIGINT — NOT NULL
- timestamp — DATETIME — NOT NULL
- collected_at — TIMESTAMP
- INDEX — idx_symbol_market
MonitoringLogs
- log_id — BIGINT
- data_id — BIGINT — NOT NULL
- metric_name — VARCHAR(100) — NOT NULL
- metric_value — DECIMAL(15, 2) — NOT NULL
- log_timestamp — TIMESTAMP
Notifications
- notification_id — INT
- user_id — INT — NOT NULL
- message — VARCHAR(255) — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
Reports
- report_id — INT
- user_id — INT — NOT NULL
- report_title — VARCHAR(100) — NOT NULL
- report_content — TEXT — NOT NULL
- created_at — TIMESTAMP
UserSettings
- setting_id — INT
- user_id — INT — NOT NULL
- setting_key — VARCHAR(50) — NOT NULL
- setting_value — VARCHAR(255) — NOT NULL
- updated_at — TIMESTAMP
Users
- Key — 기본 키 — NOT NULL
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- Field