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