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