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