Support for user-defined foreign keys? #48
jechterhoff
started this conversation in
General
Replies: 1 comment 1 reply
-
|
That would be possible if including a raw constraint when creating the attributes table (from geopackage-java or geopackage-android). Enforcement would then provided by SQLite. There would be nothing restricting reading a GeoPackage set up that way. |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Thank you very much, Brian! |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hello,
Does the API support the creation of user-defined foreign keys? For example, a column in an attributes-table defined with foreign key constraint that references a particular features-table?
The standards-compliant solution would be to use the GeoPackage Related-Tables-Extension, but some communities appear to be using foreign keys to encode relationships within a GeoPackage. So I am wondering if the NGA GeoPackage Java API would support that particular encoding approach.
Best regards,
Johannes Echterhoff
Beta Was this translation helpful? Give feedback.
All reactions