Climacast
Tables (12)
BATCH_JOB_EXECUTION
- JOB_EXECUTION_ID — bigint — NOT NULL
- VERSION — bigint
- JOB_INSTANCE_ID — bigint — NOT NULL
- CREATE_TIME — datetime(6) — NOT NULL
- START_TIME — datetime(6)
- END_TIME — datetime(6)
- STATUS — varchar(10)
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
BATCH_JOB_EXECUTION_CONTEXT
- JOB_EXECUTION_ID — bigint — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
BATCH_JOB_EXECUTION_PARAMS
- JOB_EXECUTION_ID — bigint — NOT NULL
- PARAMETER_NAME — varchar(100) — NOT NULL
- PARAMETER_TYPE — varchar(100) — NOT NULL
- PARAMETER_VALUE — varchar(2500)
- IDENTIFYING — char — NOT NULL
BATCH_JOB_EXECUTION_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char — NOT NULL
BATCH_JOB_INSTANCE
- JOB_INSTANCE_ID — bigint — NOT NULL
- VERSION — bigint
- JOB_NAME — varchar(100) — NOT NULL
- JOB_KEY — varchar(32) — NOT NULL
BATCH_JOB_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char — NOT NULL
BATCH_STEP_EXECUTION
- STEP_EXECUTION_ID — bigint — NOT NULL
- VERSION — bigint — NOT NULL
- STEP_NAME — varchar(100) — NOT NULL
- JOB_EXECUTION_ID — bigint — NOT NULL
- CREATE_TIME — datetime(6) — NOT NULL
- START_TIME — datetime(6)
- END_TIME — datetime(6)
- STATUS — varchar(10)
- COMMIT_COUNT — bigint
- READ_COUNT — bigint
- FILTER_COUNT — bigint
- WRITE_COUNT — bigint
- READ_SKIP_COUNT — bigint
- WRITE_SKIP_COUNT — bigint
- PROCESS_SKIP_COUNT — bigint
- ROLLBACK_COUNT — bigint
- EXIT_CODE — varchar(2500)
- EXIT_MESSAGE — varchar(2500)
- LAST_UPDATED — datetime(6)
BATCH_STEP_EXECUTION_CONTEXT
- STEP_EXECUTION_ID — bigint — NOT NULL
- SHORT_CONTEXT — varchar(2500) — NOT NULL
- SERIALIZED_CONTEXT — text
BATCH_STEP_EXECUTION_SEQ
- ID — bigint — NOT NULL
- UNIQUE_KEY — char — NOT NULL
Weather
- childRegion — varchar(255) — Primary key — NOT NULL
- parentRegion — varchar(255) — Primary key — NOT NULL
- time — varchar(255) — Primary key — NOT NULL
- DTYPE — varchar(31) — NOT NULL
- createdAt — datetime(6)
- updatedAt — datetime(6)
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- status — enum
- humidity2m — int
- temperature120m — double
- temperature180m — double
- temperature2m — double
- temperature80m — double
- weatherCode — int
- windSpeed10m — double
- windSpeed120m — double
- windSpeed180m — double
- windSpeed80m — double
- daylightDuration — double
- maxApparentTemperature — double
- maxPrecipitationProbability — double
- maxTemperature2m — double
- maxUvIndex — double
- maxUvIndexClearSky — double
- maxWindGusts10m — double
- maxWindSpeed10m — double
- minApparentTemperature — double
- minTemperature2m — double
- precipitationHours — double
- precipitationSum — double
- rainSum — double
- refEvapotranspiration — double
- showersSum — double
- snowfallSum — double
- sumOfShortwaveRadiation — double
- sunrise — datetime(6)
- sunset — datetime(6)
- sunshineDuration — double
- windDirection10m — int
subscription
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- intervals — enum
- method — enum
- status — bit — NOT NULL
- email — varchar(255)
- phone_number — varchar(255)
- weather_type — enum
subscription_regions
- subscription_id — bigint — Foreign key → subscription.id — NOT NULL
- regions — varchar(255)