PPREFDEFREL
The PPREFDEFREL table defines the parent child relationship between two default privacy preference records, allowing for different privacy preference regulations to supersede other regulations that are based on different criteria.
This table is used by the following domain.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
PPREFDEFREL_ID | A unique, system-generated key that identifies a relationship that two privacy preference records can have between one another in the system. | BIGINT | Not Null | Yes |
PARENT_PPREF_ID | The primary key for the parent of the relationship. | BIGINT | Not Null | No |
CHILD_PPREF_ID | The primary key for the child of the relationship. | BIGINT | Not Null | No |
REL_DESC | Provides extra space for information that can be used for an additional definition or as free form comments to provide further meaning. | VARCHAR(255) | Null | No |
START_DT | The date when this record becomes active. | TIMESTAMP | Not Null | No |
END_DT | The date when this record becomes inactive. | TIMESTAMP | Null | No |
LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
LAST_UPDATE_TXN_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |