Coding With Fun
Home Docker Django Node.js Articles Python pip guide FAQ Policy

What do the gdb items and gdb itemrelationships tables represent?


Asked by Elijah Frazier on Dec 04, 2021 FAQ



The GDB_Items and GDB_ItemRelationships tables represent the user-defined schema within a particular geodatabase. The contents of the tables are modified as the schema of the geodatabase is modified. The GDB_ItemTypes and GDB_ItemRelationshipTypes tables are populated when you create the geodatabase and values are static within a software release.
Furthermore,
The GDB_ItemTypes and GDB_ItemRelationshipTypes tables are populated when you create the geodatabase and values are static within a software release. The following diagram illustrates the relationships between these four tables: See the XML Schema of the Geodatabase whitepaper for XML definitions.
Consequently, Item types are used to normalize the GDB_Items table (the type of an item in the GDB_Items table is represented as a UUID), to provide better support for future geodatabase functionality enhancements and define a type hierarchy. All parent types are abstract; therefore, parent items are not stored directly in the GDB_Items table.
Besides,
The system tables prefixed with GDB_ describe the geodatabase schema that specifies dataset definitions, rules, and relationships. These system tables contain and manage metadata required to implement geodatabase properties, data validation rules, and behaviors.
And,
The GDB_ItemTypes table contains the predefined set of recognized item types in the geodatabase. Item types are used to normalize the GDB_Items table (the type of an item in the GDB_Items table is represented as a UUID), to provide better support for future geodatabase functionality enhancements and define a type hierarchy.