테스트

테이블 (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