CHATRPA
Tables (20)
accessory_codes
- accessory_code — VARCHAR(20) — Primary key — NOT NULL
- explanation — VARCHAR(50)
category_codes
- category_code — VARCHAR(10) — Primary key
- category_name — VARCHAR(20)
color_codes
- color_code — VARCHAR(10) — Primary key
- color_name — VARCHAR(20)
department_types
- department_type_code — INTEGER — Primary key
- department_type_name — VARCHAR(20)
distribution_types
- distribution_type_code — INTEGER — Primary key
- distribution_type_name — VARCHAR(20)
floating_population
- id — SERIAL — Primary key
- sensor_code — INTEGER — Foreign key → floating_sensor.sensor_code
- measured_at — DATE — NOT NULL
- venue_type — VARCHAR(50)
- district — VARCHAR(100)
- visitor_count — INTEGER — NOT NULL
- recorded_at — DATE — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
floating_sensor
- sensor_code — INTEGER — Primary key
- address — VARCHAR(100)
- latitude — FLOAT — NOT NULL
- longitude — FLOAT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
homeshopping_product_variants
- id — SERIAL — Primary key
- product_code — SERIAL — Foreign key → homeshopping_products.id
- category_code — VARCHAR(10) — Foreign key → homeshopping_products.category_code
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- is_set — BOOLEAN
- prod_composition — VARCHAR(30)
- prod_fabric — VARCHAR(30)
- color_text — VARCHAR(30)
- size_text — VARCHAR(30)
homeshopping_products
- id — SERIAL — Primary key
- category_code — VARCHAR(10) — Foreign key → category_codes.category_code
- product_name — VARCHAR(200) — NOT NULL
- live_date — DATE — NOT NULL
- live_url — VARCHAR(300)
- live_title — VARCHAR(200)
- live_source — VARCHAR(50)
- live_time — DATE — NOT NULL
- live_category — VARCHAR(100)
- live_media_url — VARCHAR(300)
- live_media_title — VARCHAR(200)
- main — BOOLEAN
- live_originalprice — INTEGER
- live_sellprice — INTEGER
- live_liveprice — INTEGER
- live_product_title — VARCHAR(200)
- live_product_url — VARCHAR(300)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
inventory_changes
- id — SERIAL — Primary key
- product_code — VARCHAR(50) — Foreign key → products.product_code
- store_code — VARCHAR(20) — Foreign key → stores.store_code
- varient_id — SERIAL — Foreign key → product_variants.id
- quantity — INTEGER — NOT NULL
- change_date — DATE
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
management_teams
- team_code — INTEGER — Primary key
- team_name — VARCHAR(20)
product_sales
- id — SERIAL — Primary key
- product_code — VARCHAR(50) — Foreign key → products.product_code
- store_code — VARCHAR(20) — Foreign key → stores.store_code
- varient_id — SERIAL — Foreign key → product_variants.id
- quantity — INTEGER — NOT NULL
- price — INTEGER — NOT NULL
- sale_date — DATE
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
product_variants
- id — SERIAL — Primary key
- product_code — VARCHAR(50) — Foreign key → products.product_code
- color_code — VARCHAR(10) — Foreign key → color_codes.color_code
- size_code — VARCHAR(10) — Foreign key → size_codes.size_code
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
production_types
- production_code — VARCHAR(10) — Primary key
- production_name — VARCHAR(20)
products
- product_code — VARCHAR(50) — Primary key
- production_code — VARCHAR(10) — Foreign key → production_types.production_code
- season_code — VARCHAR(10) — Foreign key → seasons.season_code
- category_code — VARCHAR(10) — Foreign key → category_codes.category_code
- accessory_code — VARCHAR(20) — Foreign key → accessory_codes.accessory_code — NOT NULL
- month — INTEGER
- name — VARCHAR(100) — NOT NULL
- cost — INTEGER
- tag_price — INTEGER
- normal_price — INTEGER
- first_out — DATE
- first_sales — DATE
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
region_codes
- region_code — INTEGER — Primary key — NOT NULL
- region_name — VARCHAR(20)
seasons
- season_code — VARCHAR(10) — Primary key
- season_name — VARCHAR(20)
size_codes
- size_code — VARCHAR(10) — Primary key
- size_name — VARCHAR(10)
stores
- store_code — VARCHAR(20) — Primary key
- region_code — INTEGER — Foreign key → region_codes.region_code — NOT NULL
- department_type_code — INTEGER — Foreign key → department_types.department_type_code
- distribution_type_code — INTEGER — Foreign key → distribution_types.distribution_type_code
- management_team_code — INTEGER — Foreign key → management_teams.team_code
- store_name — VARCHAR(50) — NOT NULL
- validity — BOOLEAN — NOT NULL
- is_headquater_included — BOOLEAN — NOT NULL
- open_date — DATE — NOT NULL
- close_date — DATE
- postal_code — VARCHAR(20)
- address — VARCHAR(200)
- latitude — FLOAT
- longitude — FLOAT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
weather
- id — SERIAL
- tm — TIMESTAMPTZ — NOT NULL
- stn — INTEGER — NOT NULL
- ta_avg — FLOAT — NOT NULL
- ta_max — FLOAT — NOT NULL
- ta_min — FLOAT — NOT NULL
- rn_day — FLOAT — NOT NULL
- ws_max — FLOAT — NOT NULL
- ws_avg — FLOAT — NOT NULL
- hm_avg — FLOAT — NOT NULL
- ss_day — FLOAT — NOT NULL
- si_day — FLOAT — NOT NULL