DM_01

Tables (9)

Copy Of DM_MASTER_REVENUE (CopyOfFACT0)

  • seq (Key) — Primary key — NOT NULL
  • standard_date (Field) — YYYY-MM-dd
  • country (Field4)
  • city (Field5)
  • brand (Field2)
  • store_name (dup)
  • store_type (Field3)
  • frame_name (Field8)
  • frame_type (Field7)
  • color_type (Field9)
  • Field12
  • revenue (Field10)
  • price (Field6)
  • fee (Field11)

DM_COUNTRY_REVENUE (FACT2)

  • seq (Key) — Primary key — NOT NULL
  • standard_date (Field) — YYYY-MM-dd
  • country (Field2)
  • revenue (Field3)

DM_FRAME (DMS2)

  • frame_id (Key) — Primary key — NOT NULL
  • frame_name (Field)
  • frame_type (Field2)
  • op_start_date (Field3)
  • op_end_date (Field4)

DM_FRAME_REVENUE (FACT3)

  • seq (Key) — Primary key — NOT NULL
  • standard_date (Field) — YYYY-MM-dd
  • frame_type (Field4)
  • frame_name (Field2)
  • revenue (Field3)

DM_MASTER_REVENUE (FACT0)

  • seq (Key) — Primary key — NOT NULL
  • standard_date (Field) — YYYY-MM-dd
  • country (Field4)
  • city (Field5)
  • latitude (Field6)
  • longitude (Field2)
  • store_name (dup)
  • store_type (Field3)
  • frame_name (Field8)
  • frame_type (Field7)
  • ? (Field9)
  • revenue (Field10)

DM_STORE (DMS1)

  • store_id (Key) — Primary key — NOT NULL
  • store_name (Field2)
  • store_type (Field)
  • open_date (Field3)
  • map_id (FK) — Foreign key → META_MAP.map_id — NOT NULL

DM_STORE_REVENUE (FACT1)

  • seq (Key) — Primary key — NOT NULL
  • standard_date (Field) — YYYY-MM-dd
  • store_name (Field2)
  • revenue (Field3)

DM_TOTAL_REVENUE (FACT4)

  • seq (Key) — Primary key — NOT NULL
  • standard_date (Field) — YYYY-MM-dd — NOT NULL
  • revenue (Field2)

META_MAP (META)

  • map_id (PK) — Primary key — NOT NULL
  • country (Field3)
  • city (Field4)
  • detail (Field5)
  • latitude (Field)
  • longitude (Field2)