Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | CHAR | 36 | null |
|
|
Identifies the relationship |
||
| PARTY_ID | CHAR | 36 | null |
|
|
Identifies the party related to the record |
||
| ACCOUNT_ID | CHAR | 36 | null |
|
|
Identifies the account related to the record |
||
| KIND | VARCHAR | 255 | null |
|
|
Identifies the relationship kind between account and party |
||
| REVISION_ID | BIGINT | 19 | null |
|
|
|||
| REVISION_TYPE | SMALLINT | 5 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | ID + REVISION_ID + REVISION_TYPE |
| DTW_REG_ACC_PARTY_AUD_NID_IDX | Must be unique | Asc/Asc/Asc | REVISION_ID + ACCOUNT_ID + PARTY_ID |
Relationships
Close relationships within degrees of separation
