| Business Data Model Data Model |
| Description | An association between a profile and a property. |
| Attributes | |
Profile Property Seq |
|
Profile Property Value Txt |
|
| Relationship | |
Profile Property Value_Property_FK |
|
Profile Property Value_Profile_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Profile Property Seq
| Description | An incrementing number that allows a profile property to have multiple values. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Profile Property Value Txt
| Description | The precise representation for a property value. The value can be either a number or text and must conform to the definition rules as defined by the property itself. For example: If the profile property is time zone, then the profile property value text might be is EST. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Profile Property Value_Property_FK
| Is Identifying Relationship | true |
| Child Table | Profile Property Value |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Property |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Profile Property Value_Profile_FK
| Is Identifying Relationship | true |
| Child Table | Profile Property Value |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Profile |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |