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)