DTW_REG_REL_ACCOUNT_PARTY


Description

Relationship between account and party

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_REG_ACC_MEMB_FEATURE.RELATIONSHIP_ID DTW_REG_ACC_M_F_R_ACC_P_ID_FK C

Identifies the relationship
PARTY_ID CHAR 36 null
DTW_REG_PARTY.ID DTW_REG_REL_ACC_PARTY_ID_FK C

Identifies the party related to the record
ACCOUNT_ID CHAR 36 null
DTW_REG_ACCOUNT.ID DTW_REG_REL_ACC_ACC_ID_FK C

Identifies the account related to the record
KIND VARCHAR 255 null

Identifies the relationship kind between account and party

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_REG_REL_ACC_ACC_ID_IDX Performance Asc ACCOUNT_ID
DTW_REG_REL_ACC_PARTY_ID_IDX Performance Asc PARTY_ID
DTW_REG_REL_ACCPARTY_ID_IDX Performance Asc/Asc ACCOUNT_ID + PARTY_ID

Relationships

Close relationships within degrees of separation