English
PostgreSQL / PostGIS table
A CREATE TABLE statement: columns are the attribute names in snake_case, with constraints for required attributes, allowed values and patterns; location is a geometry in SRID 4326 with a GiST index; descriptions and IRIs are in the comments. How to use them: guide.
| Subject | Type | File |
|---|---|---|
| Decision | Decision | /adapters/postgis/decision/Decision.sql |
| Disaster response | DesignatedShelter | /adapters/postgis/disaster/DesignatedShelter.sql |
| Disaster response | EvacuationShelter | /adapters/postgis/disaster/EvacuationShelter.sql |
| Disaster response | EvacuationSite | /adapters/postgis/disaster/EvacuationSite.sql |
| Facilities | AEDLocation | /adapters/postgis/facility/AEDLocation.sql |
| Facilities | Facility | /adapters/postgis/facility/Facility.sql |
| Facilities | MedicalInstitution | /adapters/postgis/facility/MedicalInstitution.sql |
| Facilities | PublicToilet | /adapters/postgis/facility/PublicToilet.sql |
| Task management | Milestone | /adapters/postgis/task/Milestone.sql |
| Task management | Project | /adapters/postgis/task/Project.sql |
| Task management | Task | /adapters/postgis/task/Task.sql |
| Transportation | RoadRestriction | /adapters/postgis/transportation/RoadRestriction.sql |