| Table HLPDTEST.STATEGPS.T_GPS_NODE_MODEL_RELATIONS | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||
Table contained 14,218 rows at Thu Aug 13 01:05 IST 2020 | ||||||||||||||||||||||||||||||||||||||||
Indexes:
| Column(s) | Type | Sort | Constraint Name | Anomalies |
|---|---|---|---|---|
| NODE_MODEL_ID | Primary key | Asc | PK_T_GPS_NODE_MODEL_RLTS | |
| NODE_ID + MODEL_ID | Must be unique | Asc/Asc | SYS_C0014399 | These unique columns are also nullable |
| MODEL_ID | Performance | Asc | T_GPS_NDMDL_REL_MODEL_ID_CN3 | |
| NODE_ID | Performance | Asc | T_GPS_NDMDL_REL_NODE_ID_CN2 |
|