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