Database Reference
In-Depth Information
customer
country
store
customer_id
account_num
lname
fname
mi
address1
address2
address3
address4
city
state_province
postal_code
country
customer_region_id
phone1
phone2
birthdate
marital_status
yearly_income
gender
total_children
num_children_at_home
education
date_accnt_opened
member_card
occupation
houseowner
num_cars_owned
customer_geom
city_id
country_id
country_name
country_geom
store_id
store_type
region_id
store_name
store_number
store_street_address
store_city
store_state
store_postal_code
store_country
store_manager
store_phone
store_fax
first_opened_date
last_remodel_date
lease_sqft
store_sqft
grocery_sqft
frozen_sqft
meat_sqft
coffee_bar
video_store
salad_bar
prepared_food
florist
store_geom
city_id
state
state_id
state_name
state_geom
country_id
city
city_id
city_name
city_geom
state_id
promotion
promotion_id
promotion_district_id
promotion_name
media_type
cost
start_date
end_date
product
sales_fact
product_id
product_class_id
brand_name
product_name
SKU
SRP
gross_weight
net_weight
recyclable_package
low_fat
units_per_case
cases_per_pallet
shelf_width
shelf_height
shelf_depth
product_id
time_id
customer_id
promotion_id
store_id
store_sales
store_cost
unit_sales
time_by_day
time_id
the_date
the_day
the_month
the_year
day_of_month
week_of_year
month_of_year
quarter
fiscal_period
product_class
product_class_id
product_subcategory
product_category
product_department
product_family
Fig. 11.20
Relational schema of the GeoFoodmart data warehouse
Search WWH ::
Custom Search