agent f

Tables (23)

accessory_codes

  • accessory_code — VARCHAR(20)
  • explanation — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

category_codes

  • category_code — VARCHAR(10)
  • category_name — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

color_codes

  • color_code — VARCHAR(10)
  • color_name — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

department_types

  • department_type_code — INTEGER
  • department_type_name — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

distribution_types

  • distribution_type_code — INTEGER
  • distribution_type_name — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

floating_population

  • id — SERIAL
  • sensor_code — INTEGER — NOT NULL
  • 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
  • address — VARCHAR(100)
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

homeshopping_detail_url

  • id — SERIAL
  • homeshopping_product_id — INTEGER — NOT NULL
  • detail_url — VARCHAR — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

homeshopping_product_variants

  • id — SERIAL
  • product_code — INTEGER
  • is_set — BOOLEAN
  • prod_composition — VARCHAR(30)
  • prod_fabric — VARCHAR(30)
  • color_text — VARCHAR(30)
  • size_text — VARCHAR(30)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

homeshopping_products

  • id — SERIAL
  • product_name — VARCHAR(200) — NOT NULL
  • live_date — DATE — NOT NULL
  • live_time — TIME
  • live_url — VARCHAR
  • live_title — VARCHAR(200)
  • live_source — VARCHAR(50)
  • live_category — VARCHAR(100)
  • live_media_url — VARCHAR
  • 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(500) — NOT NULL
  • category_code — VARCHAR(10)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

homeshopping_thumbnail_url

  • id — SERIAL
  • homeshopping_product_id — INTEGER — NOT NULL
  • thumbnail_url — VARCHAR — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

inventory_changes

  • id — SERIAL
  • product_code — VARCHAR(50) — NOT NULL
  • store_code — VARCHAR(20) — NOT NULL
  • variant_id — INTEGER — NOT NULL
  • quantity — INTEGER — NOT NULL
  • change_date — DATE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

management_teams

  • team_code — INTEGER
  • team_name — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

product_sales

  • id — SERIAL
  • product_code — VARCHAR(50) — NOT NULL
  • store_code — VARCHAR(20)
  • variant_id — INTEGER
  • quantity — INTEGER — NOT NULL
  • price — INTEGER — NOT NULL
  • sale_date — DATE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

product_variants

  • id — SERIAL
  • product_code — VARCHAR(50)
  • color_code — VARCHAR(10)
  • size_code — VARCHAR(10)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

production_types

  • production_code — VARCHAR(10)
  • production_name — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

products

  • product_code — VARCHAR(50)
  • season_code — VARCHAR(10) — NOT NULL
  • month — INTEGER
  • category_code — VARCHAR(10) — NOT NULL
  • production_type_code — VARCHAR(10) — NOT NULL
  • accessory_code — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • cost — INTEGER
  • tag_price — INTEGER
  • normal_price — INTEGER
  • plan_qty — INTEGER
  • order_qty — INTEGER
  • first_out — DATE
  • first_sales — DATE
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

region_codes

  • region_code — INTEGER
  • region_name — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

seasons

  • season_code — VARCHAR(10)
  • season_name — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

size_codes

  • size_code — VARCHAR(10)
  • size_name — VARCHAR(10)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

stores

  • store_code — VARCHAR(20)
  • store_name — VARCHAR(50) — NOT NULL
  • validity — BOOLEAN — NOT NULL
  • distribution_type_code — INTEGER — NOT NULL
  • management_team_code — INTEGER — NOT NULL
  • region_code — INTEGER — NOT NULL
  • department_type_code — INTEGER
  • is_headquater_included — BOOLEAN — NOT NULL
  • open_date — DATE — NOT NULL
  • close_date — DATE
  • postal_code — VARCHAR(20)
  • address — VARCHAR(200)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

weather

  • id — SERIAL
  • tm — TIMESTAMPTZ — NOT NULL
  • stn — INTEGER — NOT NULL
  • ta_avg — DOUBLE
  • ta_max — DOUBLE
  • ta_min — DOUBLE
  • rn_day — DOUBLE
  • ws_max — DOUBLE
  • ws_avg — DOUBLE
  • HM_avg — DOUBLE
  • ss_day — DOUBLE
  • si_day — DOUBLE
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

weather_station

  • id — INTEGER
  • stn_ko — VARCHAR(20) — NOT NULL
  • latitude — DOUBLE
  • longitude — DOUBLE
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL