day sales

Tables (4)

lu_day

  • day_date — timestamp — Primary key — NOT NULL
  • month_id — int4 — Foreign key → lu_month.month_id — NOT NULL
  • quarter_id (quarter_id2) — int2 — Foreign key → lu_month.quarter_id
  • year_id (year_id2) — int2 — Foreign key → lu_month.year_id
  • prev_day_date — timestamp
  • lm_day_date — timestamp
  • lq_day_date — timestamp
  • ly_day_date — timestamp

lu_month

  • month_id — int4 — Primary key — NOT NULL
  • quarter_id — int2 — Foreign key → lu_quarter.quarter_id
  • year_id (year_id2) — int2 — Foreign key → lu_quarter.year_id
  • month_date — timestamp
  • month_desc — varchar(50)
  • month_of_year — int2
  • month_duration — int2
  • prev_month_id — int4
  • lq_month_id — int4
  • ly_month_id — int4
  • month_desc_de — varchar(50)
  • month_desc_fr — varchar(50)
  • month_desc_es — varchar(50)
  • month_desc_it — varchar(50)
  • month_desc_po — varchar(50)
  • month_desc_ja — varchar(50)
  • month_desc_sch — varchar(50)
  • month_desc_ko — varchar(50)

lu_quarter

  • quarter_id — int2 — Primary key
  • year_id — int2 — Foreign key → lu_year.year_id
  • quarter_date — timestamp
  • quarter_desc — varchar(50)
  • quarter_duration — int2
  • prev_quarter_id — int2
  • ly_quarter_id — int2
  • quarter_desc_de — varchar(50)
  • quarter_desc_fr — varchar(50)
  • quarter_desc_es — varchar(50)
  • quarter_desc_it — varchar(50)
  • quarter_desc_po — varchar(50)
  • quarter_desc_ja — varchar(50)
  • quarter_desc_sch — varchar(50)
  • quarter_desc_ko — varchar(50)

lu_year

  • year_id — int2 — Primary key
  • year_date — timestamp
  • year_duration — int2
  • prev_year_id — int2