index

Tables (4)

index_const (Untitled2)

  • id_No (Key) — Primary key — NOT NULL
  • indexid (Field) — varchar
  • datadate (date) — date
  • seckey (varchar) — varcahr
  • weight (float) — float

index_exposure (Untitled4)

  • id_no (Key) — number — Primary key — NOT NULL
  • indexid (Field) — varchar
  • datadate (Field2) — date
  • type (Field3) — varchr(2)
  • item (Field4) — varchar
  • itemvalue (Field5) — varchar
  • value (Field6) — float
  • version (Field7) — varchar(1)

index_index (Untitled3)

  • id_no (number) — Primary key — NOT NULL
  • indexid (varchar)
  • datadate (Field) — date
  • priceindex (Field2) — float
  • totalindex (Field3) — float
  • netindex (Field4) — float
  • price_return (Field5) — float
  • total_return (Field6) — float
  • net_return (Field7) — float

index_meta (Untitled)

  • id_no (Key) — Primary key — NOT NULL
  • indexid (Field2)
  • status (Field)
  • index_name (Field3)