DataTide

Tables (6)

ground_weather (지상 날씨)

  • ground_pk (PK) — BIGINT — Primary key — NOT NULL
  • month_date (날짜) — Date
  • temperature (평균기온) — float
  • rain (강수량) — float

item (품목)

  • item_pk (품목 pk) — int — Primary key — NOT NULL
  • item_name (품목명) — varchar(20)

item_predict (품목별 생산/수입/판매 예측)

  • predict_pk (pk) — BIGINT — Primary key — NOT NULL
  • item_pk (품목 pk) — int — Foreign key → item.item_pk — NOT NULL
  • month_date (날짜) — Date
  • production (생산) — int
  • inbound (수입) — int
  • sales (판매) — int

item_retail (품목별 생산/수입/판매)

  • retail_pk (pk) — BIGINT — Primary key — NOT NULL
  • item_pk (품목 pk) — int — Foreign key → item.item_pk — NOT NULL
  • month_date (날짜) — Date
  • production (생산) — int
  • inbound (수입) — int
  • sales (판매) — int

location (지역 위치)

  • local_pk (위치 pk) — int — Primary key — NOT NULL
  • local_name (지역명) — varchar(30)

sea_weather (해양 날씨)

  • sea_pk (PK) — BIGINT — Primary key — NOT NULL
  • local_pk (위치 pk) — int — Foreign key → location.local_pk — NOT NULL
  • month_date (날짜) — Date
  • temperature (평균수온) — float
  • wind (평균풍속) — float
  • salinity (평균염분) — float
  • wave_height (유의파고) — float
  • wave_period (유의파주기) — float
  • wave_speed (유속) — float
  • rain (강수량) — float
  • snow (적설량) — float