schema.sql

/* (Beta) Export of data model RevenueCollection of the subject dataModel.PublicAccountability for a PostgreSQL database. Pending translation of enumerations and multityped attributes */
CREATE TYPE RevenueCollection_type AS ENUM ('RevenueCollection');CREATE TYPE vehicleType_type AS ENUM ('agriculturalVehicle','anyVehicle','articulatedVehicle','autorickshaw','bicycle','binTrolley','BRT mini bus·','BRT bus','bus','car','caravan','carOrLightVehicle','carWithCaravan','carWithTrailer','cleaningTrolley','compactor','constructionOrMaintenanceVehicle','dumper','e-moped','e-scooter','e-motorcycle','fourWheelDrive','highSidedVehicle','hopper','lorry','minibus','moped','motorcycle','motorcycleWithSideCar','motorscooter','sweepingMachine','tanker','tempo','threeWheeledVehicle','tipper','trailer','tram','trolley','twoWheeledVehicle','van','vehicleWithoutCatalyticConverter','vehicleWithCaravan','vehicleWithTrailer','withEvenNumberedRegistrationPlates','withOddNumberedRegistrationPlates','other');
CREATE TABLE RevenueCollection (address JSON, alternateName TEXT, amountCollected NUMERIC, areaServed TEXT, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, dateObserved TIMESTAMP, description TEXT, enrollmentCertificateRecoveryAmount NUMERIC, id TEXT PRIMARY KEY, location JSON, month TEXT, municipalityInfo JSON, name TEXT, owner JSON, registrationCertificateRecoveryAmount NUMERIC, revenueCollectionType TEXT, seeAlso JSON, source TEXT, totalCount NUMERIC, type RevenueCollection_type, vehicleType vehicleType_type, vehicleTypeCode TEXT, year TEXT);