DB 명세서
테이블 (8)
AlertLogs
- log_id — INT
- alert_id — INT — NOT NULL
- triggered_at — TIMESTAMP
- message — TEXT — NOT NULL
AnalysisReports
- report_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- generated_at — TIMESTAMP
ExternalAPIs
- api_id — INT
- service_name — VARCHAR(100) — NOT NULL
- endpoint_url — VARCHAR(255) — NOT NULL
- api_key — VARCHAR(255)
- last_used — TIMESTAMP
FinancialData
- data_id — INT
- symbol — VARCHAR(10) — NOT NULL
- price — DECIMAL(15, 4) — NOT NULL
- volume — INT — NOT NULL
- change_percent — DECIMAL(6, 2)
- timestamp — DATETIME
- INDEX — idx_symbol_timestamp
SystemLogs
- log_id — INT
- log_type — ENUM('info', 'warning', 'error') — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP
UserAlerts
- alert_id — INT
- user_id — INT — NOT NULL
- symbol — VARCHAR(10) — NOT NULL
- condition — ENUM('above', 'below') — NOT NULL
- threshold — DECIMAL(15, 4) — NOT NULL
- is_active — BOOLEAN
- created_at — TIMESTAMP
Users
- user_id (Key) — 기본 키 — NOT NULL
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — ENUM('admin', 'analyst', 'viewer')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
VisualizationMetadata
- metadata_id — INT
- user_id — INT — NOT NULL
- chart_type — ENUM('line', 'bar', 'pie', 'scatter') — NOT NULL
- chart_data — JSON — NOT NULL
- created_at — TIMESTAMP