schema.sql

/* (Beta) Export of data model WeatherForecast of the subject dataModel.Weather for a PostgreSQL database. Pending translation of enumerations and multityped attributes */
CREATE TYPE WeatherForecast_type AS ENUM ('WeatherForecast');
CREATE TABLE WeatherForecast (address JSON, alternateName TEXT, areaServed TEXT, atmosphericPressure NUMERIC, dataProvider TEXT, dateCreated TIMESTAMP, dateIssued TIMESTAMP, dateModified TIMESTAMP, dateRetrieved TIMESTAMP, dayMaximum JSON, dayMinimum JSON, description TEXT, feelsLikeTemperature NUMERIC, gustSpeed NUMERIC, id TEXT PRIMARY KEY, illuminance NUMERIC, location JSON, name TEXT, owner JSON, precipitation NUMERIC, precipitationProbability NUMERIC, refPointOfInterest TEXT, relativeHumidity NUMERIC, seeAlso JSON, source TEXT, temperature NUMERIC, type WeatherForecast_type, uVIndexMax NUMERIC, validFrom TIMESTAMP, validTo TIMESTAMP, validity TEXT, weatherType TEXT, windDirection NUMERIC, windSpeed NUMERIC);