ERD
Tables (10)
base_glossary
- id — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
base_guide
- id — int(11) — Primary key — NOT NULL
- station_id — varchar(30) — NOT NULL
- season — int(2) — NOT NULL
- degree — int(1)
- largescale — varchar(10)
- largescaleadd — varchar(255)
- adjective — varchar(10)
- predictor — varchar(10)
- area — varchar(100)
- areaadd — varchar(255)
base_station
- id — int(11) — Primary key — NOT NULL
- country — varchar(100) — NOT NULL
- station_id — varchar(30) — NOT NULL
- station_name — varchar(100) — NOT NULL
- latitude — float — NOT NULL
- longitude — float — NOT NULL
- raw_properties — text
- use_default_image — bit(1) — NOT NULL
- image_default — longblob
- image_upload — longblob
daou_obs_statistics
- id — int(11) — Primary key — NOT NULL
- station_id — varchar(30) — NOT NULL
- season — int(2) — NOT NULL
- hindcast_year_start — int(4) — NOT NULL
- hindcast_year_end — int(4) — NOT NULL
- obs_mean — float — NOT NULL
- obs_standard_deviation — float — NOT NULL
- obs_lower_bound — float — NOT NULL
- obs_upper_bound — float — NOT NULL
daou_pdf
- id — int(11) — Primary key — NOT NULL
- station_id — varchar(30) — NOT NULL
- year — int(4) — NOT NULL
- season — int(2) — NOT NULL
- hindcast_year_start — int(4) — NOT NULL
- hindcast_year_end — int(4) — NOT NULL
- start — float — NOT NULL
- diff — float — NOT NULL
- obs_lower_bound — float — NOT NULL
- obs_upper_bound — float — NOT NULL
- frequency — blob
daou_pmme_tp
- id — int(11) — Primary key — NOT NULL
- station_id — varchar(30) — NOT NULL
- year — int(4) — NOT NULL
- season — int(2) — NOT NULL
- below_normal — float — NOT NULL
- normal — float — NOT NULL
- above_normal — float — NOT NULL
- forecast — varchar(2) — NOT NULL
daou_tp
- id — int(11) — Primary key — NOT NULL
- station_id — varchar(30) — NOT NULL
- year — int(4) — NOT NULL
- season — int(2) — NOT NULL
- hindcast_year_start — int(4) — NOT NULL
- hindcast_year_end — int(4) — NOT NULL
- below_normal — float — NOT NULL
- normal — float — NOT NULL
- above_normal — float — NOT NULL
- forecast — varchar(2) — NOT NULL
- category — varchar(10) — NOT NULL
- fcst_min — float — NOT NULL
- fcst_max — float — NOT NULL
- fcst_middle — float — NOT NULL
- fcst_mean — float — NOT NULL
- fcst_standard_deviation — float — NOT NULL
- fcst_lower_bound — float — NOT NULL
- fcst_upper_bound — float — NOT NULL
- fcst_lx — float — NOT NULL
- fcst_ux — float — NOT NULL
data_copics
- id — int(11) — Primary key — NOT NULL
- year — int(4) — NOT NULL
- season — int(2) — NOT NULL
- data — longblob
data_guidance_fig
- id — int(11) — Primary key — NOT NULL
- station_id — varchar(30) — NOT NULL
- season — int(2) — NOT NULL
- predictor — varchar(10)
- image — longblob
info_picaso
- id — int(11) — Primary key — NOT NULL
- name — varchar(40) — NOT NULL
- value — varchar(40) — NOT NULL
- created_at — datetime
- updated_at — datetime
- deployment_status — int(1) — false / true