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)