Entity_role_map
Important: The Entity Role Map table has a unique constraint that allows NULL values in the role_id, entity_id, or contact_id columns, as long as the combination of the values is unique. Consequently, these columns can sometimes contain NULL values.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| contact_id |
NUMBER |
|
39 |
0 |
contact_id
|
Contacts
|
Contact ID |
| entity_id |
NUMBER |
|
39 |
0 |
entity_id
|
Entity
|
Entity ID |
| role_id |
NUMBER |
|
39 |
0 |
|
|
Role ID |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| entity_role_map_contacts_fk |
contact_id |
Contacts |
contact_id |
1 |
| entity_role_map_entity_fk |
entity_id |
Entity |
entity_id |
1 |