| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| contact_id | NUMBER | 39 | 0 |
entity_id |
Entity |
Contact ID | |
| date_last_modified | TIMESTAMP | Date last modified | |||||
| isinactive | VARCHAR2 | 3 | Item is inactive | ||||
| name | VARCHAR2 | 31 | Name | ||||
| owner_id | NUMBER | 39 | 0 |
entity_id |
Entity |
Owner ID | |
| parent_id | NUMBER | 39 | 0 | Child of | |||
| shared_0 | VARCHAR2 | 3 | Contacts are shared |
| FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
|---|---|---|---|---|
| contact_types_entity_fk | contact_id | Entity | entity_id | 1 |
| contact_types_entity_fk_2 | owner_id | Entity | entity_id | 1 |