Findex ERD - Initial Draft (based on Swagger Spec)
Tables (4)
AutoSyncSetting (auto_sync_setting)
- setting_id (Key) — VARCHAR(50) — Primary key — NOT NULL
- is_enabled (Field) — BOOLEAN
- interval (Field2) — INT
- last_run (Field3) — DATETIME
IndexData (index_data)
- date (Key) — VARCHAR(50) — Primary key — NOT NULL
- index_id (FK) — VARCHAR(50) — Foreign key → IndexInfo.index_id — NOT NULL
- open (Field) — FLOAT
- high (Field2) — FLOAT
- low (Field3) — FLOAT
- close (Field4) — FLOAT
- volume (Field5) — BIGINT
IndexInfo (index_info)
- index_id (Key) — VARCHAR(50) — Primary key — NOT NULL
- index_name (Field) — VARCHAR(100)
- index_classification (Field2) — VARCHAR(50)
- favorite (Field3) — BOOLEAN
SyncJob (sync_job)
- job_id (Key) — VARCHAR(50) — Primary key — NOT NULL
- status (Field) — VARCHAR(30)
- start_time (Field2) — DATETIME
- end_time (Field3) — DATETIME
- error_message (Field4) — TEXT