Columns
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
dbprop_pkey | Primary key | Asc | dbprop_id |
dbprop_c1 | Must be unique | Asc/Asc/Asc | db_id + type_id + rank |
dbprop_idx1 | Performance | Asc | db_id |
dbprop_idx2 | Performance | Asc | type_id |
Schema Version: 1.3
An external database can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible. There is a unique constraint, dbprop_c1, for the combination of db_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
dbprop_pkey | Primary key | Asc | dbprop_id |
dbprop_c1 | Must be unique | Asc/Asc/Asc | db_id + type_id + rank |
dbprop_idx1 | Performance | Asc | db_id |
dbprop_idx2 | Performance | Asc | type_id |