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