Entities and attributes for logical data models

Entity Name Entity Type Entity Attribute Name Entity Attribute Required Entity Attribute Is PK Entity Attribute Is FK Entity Attribute Domain Name
AGENT Dependent PARTY ID Yes Yes Yes ID
AGENT Dependent ROLE TYPE ID Yes Yes Yes ID
ASSOCIATION Dependent PARTY ID Yes Yes Yes ID
ASSOCIATION Dependent ROLE TYPE ID Yes Yes Yes ID
BILL TO CUSTOMER Dependent PARTY ID Yes Yes Yes ID
BILL TO CUSTOMER Dependent ROLE TYPE ID Yes Yes Yes ID
COMPETITOR Dependent PARTY ID Yes Yes Yes ID
COMPETITOR Dependent ROLE TYPE ID Yes Yes Yes ID
CONTACT Dependent PARTY ID Yes Yes Yes ID
CONTACT Dependent ROLE TYPE ID Yes Yes Yes ID
CONTRACTOR Dependent PARTY ID Yes Yes Yes ID
CONTRACTOR Dependent ROLE TYPE ID Yes Yes Yes ID
CUSTOMER Dependent PARTY ID Yes Yes Yes ID
CUSTOMER Dependent ROLE TYPE ID Yes Yes Yes ID
CUSTOMER RELATIONSHIP Dependent PARTY ID FROM Yes Yes Yes ID
CUSTOMER RELATIONSHIP Dependent PARTY ID TO Yes Yes Yes ID
CUSTOMER RELATIONSHIP Dependent FROM DATE Yes Yes Yes Datetime
CUSTOMER RELATIONSHIP Dependent ROLE TYPE ID FROM Yes Yes Yes ID
CUSTOMER RELATIONSHIP Dependent ROLE TYPE ID TO Yes Yes Yes ID
DEPARTMENT Dependent PARTY ID Yes Yes Yes ID
DEPARTMENT Dependent ROLE TYPE ID Yes Yes Yes ID
DISTRIBUTION CHANNEL Dependent PARTY ID Yes Yes Yes ID
DISTRIBUTION CHANNEL Dependent ROLE TYPE ID Yes Yes Yes ID
DISTRIBUTION CHANNEL RELATIONSHIP Dependent PARTY ID TO Yes Yes Yes ID
DISTRIBUTION CHANNEL RELATIONSHIP Dependent PARTY ID FROM Yes Yes Yes ID
DISTRIBUTION CHANNEL RELATIONSHIP Dependent FROM DATE Yes Yes Yes Datetime
DISTRIBUTION CHANNEL RELATIONSHIP Dependent ROLE TYPE ID FROM Yes Yes Yes ID
DISTRIBUTION CHANNEL RELATIONSHIP Dependent ROLE TYPE ID TO Yes Yes Yes ID
DISTRIBUTOR Dependent PARTY ID Yes Yes Yes ID
DISTRIBUTOR Dependent ROLE TYPE ID Yes Yes Yes ID
DIVISION Dependent PARTY ID Yes Yes Yes ID
DIVISION Dependent ROLE TYPE ID Yes Yes Yes ID
EMPLOYEE Dependent PARTY ID Yes Yes Yes ID
EMPLOYEE Dependent ROLE TYPE ID Yes Yes Yes ID
EMPLOYMENT Dependent PARTY ID FROM Yes Yes Yes ID
EMPLOYMENT Dependent PARTY ID TO Yes Yes Yes ID
EMPLOYMENT Dependent FROM DATE Yes Yes Yes Datetime
EMPLOYMENT Dependent ROLE TYPE ID TO Yes Yes Yes ID
EMPLOYMENT Dependent ROLE TYPE ID FROM Yes Yes Yes ID
EMPLOYMENT Dependent TERMINATION REASON ID No No Yes ID
EMPLOYMENT Dependent TERMINATION TYPE ID No No Yes ID
END USER CUSTOMER Dependent PARTY ID Yes Yes Yes ID
END USER CUSTOMER Dependent ROLE TYPE ID Yes Yes Yes ID
FAMILY MEMBER Dependent PARTY ID Yes Yes Yes ID
FAMILY MEMBER Dependent ROLE TYPE ID Yes Yes Yes ID
HOUSEHOLD Dependent PARTY ID Yes Yes Yes ID
HOUSEHOLD Dependent ROLE TYPE ID Yes Yes Yes ID
INTERNAL ORGANIZATION Dependent PARTY ID Yes Yes Yes ID
INTERNAL ORGANIZATION Dependent ROLE TYPE ID Yes Yes Yes ID
ORGANIZATION Dependent PARTY ID Yes Yes Yes ID
ORGANIZATION Dependent NAME Yes No No Name
ORGANIZATION CONTACT RELATIONSHIP Dependent PARTY ID FROM Yes Yes Yes ID
ORGANIZATION CONTACT RELATIONSHIP Dependent PARTY ID TO Yes Yes Yes ID
ORGANIZATION CONTACT RELATIONSHIP Dependent FROM DATE Yes Yes Yes Datetime
ORGANIZATION CONTACT RELATIONSHIP Dependent ROLE TYPE ID TO Yes Yes Yes ID
ORGANIZATION CONTACT RELATIONSHIP Dependent ROLE TYPE ID FROM Yes Yes Yes ID
ORGANIZATION ROLE Dependent PARTY ID Yes Yes Yes ID
ORGANIZATION ROLE Dependent ROLE TYPE ID Yes Yes Yes ID
ORGANIZATION ROLLUP Dependent PARTY ID TO Yes Yes Yes ID
ORGANIZATION ROLLUP Dependent PARTY ID FROM Yes Yes Yes ID
ORGANIZATION ROLLUP Dependent FROM DATE Yes Yes Yes Datetime
ORGANIZATION ROLLUP Dependent ROLE TYPE ID FROM Yes Yes Yes ID
ORGANIZATION ROLLUP Dependent ROLE TYPE ID TO Yes Yes Yes ID
ORGANIZATION UNIT Dependent PARTY ID Yes Yes Yes ID
ORGANIZATION UNIT Dependent ROLE TYPE ID Yes Yes Yes ID
OTHER ORGANIZATION UNIT Dependent PARTY ID Yes Yes Yes ID
OTHER ORGANIZATION UNIT Dependent ROLE TYPE ID Yes Yes Yes ID
PARENT ORGANIZATION Dependent PARTY ID Yes Yes Yes ID
PARENT ORGANIZATION Dependent ROLE TYPE ID Yes Yes Yes ID
PARTNER Dependent PARTY ID Yes Yes Yes ID
PARTNER Dependent ROLE TYPE ID Yes Yes Yes ID
PARTNERSHIP Dependent PARTY ID TO Yes Yes Yes ID
PARTNERSHIP Dependent PARTY ID FROM Yes Yes Yes ID
PARTNERSHIP Dependent FROM DATE Yes Yes Yes Datetime
PARTNERSHIP Dependent ROLE TYPE ID FROM Yes Yes Yes ID
PARTNERSHIP Dependent ROLE TYPE ID TO Yes Yes Yes ID
PARTY Independent PARTY ID Yes Yes No ID
PARTY RELATIONSHIP Dependent PARTY ID FROM Yes Yes Yes ID
PARTY RELATIONSHIP Dependent PARTY ID TO Yes Yes Yes ID
PARTY RELATIONSHIP Dependent FROM DATE Yes Yes No Datetime
PARTY RELATIONSHIP Dependent ROLE TYPE ID TO Yes Yes Yes ID
PARTY RELATIONSHIP Dependent ROLE TYPE ID FROM Yes Yes Yes ID
PARTY RELATIONSHIP Dependent STATUS TYPE ID Yes No Yes ID
PARTY RELATIONSHIP Dependent PRIORITY TYPE ID Yes No Yes ID
PARTY RELATIONSHIP Dependent PARTY RELATIONSHIP TYPE ID Yes No Yes ID
PARTY RELATIONSHIP Dependent THRU DATE No No No Datetime
PARTY RELATIONSHIP Dependent COMMENTS No No No Comment
PARTY RELATIONSHIP TYPE Independent PARTY RELATIONSHIP TYPE ID Yes Yes No ID
PARTY RELATIONSHIP TYPE Independent ROLE TYPE ID VALID TO Yes No Yes ID
PARTY RELATIONSHIP TYPE Independent ROLE TYPE ID VALID FROM Yes No Yes ID
PARTY RELATIONSHIP TYPE Independent DESCRIPTION Yes No No Description
PARTY RELATIONSHIP TYPE Independent NAME Yes No No Name
PARTY ROLE Dependent PARTY ID Yes Yes Yes ID
PARTY ROLE Dependent ROLE TYPE ID Yes Yes Yes ID
PARTY ROLE Dependent PARTY ROLE ID Yes No No ID
PARTY ROLE TYPE Dependent ROLE TYPE ID Yes Yes Yes ID
PERSON Dependent PARTY ID Yes Yes Yes ID
PERSON Dependent CURRENT LAST NAME No No No Name
PERSON Dependent CURRENT FIRST NAME No No No Name
PERSON Dependent CURRENT MIDDLE NAME No No No Name
PERSON Dependent CURRENT PERSONAL TITLE No No No Name
PERSON Dependent CURRENT SUFFIX No No No Name
PERSON Dependent CURRENT NICKNAME No No No Name
PERSON Dependent GENDER No No No Indicator
PERSON Dependent BIRTH DATE No No No Datetime
PERSON Dependent HEIGHT No No No Numeric
PERSON Dependent WEIGHT No No No Numeric
PERSON Dependent MOTHER’S MADIEN  NAME No No No Name
PERSON Dependent MARTIAL STATUS No No No Indicator
PERSON Dependent SOCIAL SECURITY NUMBER No No No Numeric
PERSON Dependent CURRENT PASSPORT NUMBER No No No Numeric
PERSON Dependent CURRENT PASSPORT EXPIRE DATE No No No Datetime
PERSON Dependent TOTAL YEARS WORK EXPERIENCE No No No Numeric
PERSON Dependent COMMENTS No No No Comment
PERSON ROLE Dependent PARTY ID Yes Yes Yes ID
PERSON ROLE Dependent ROLE TYPE ID Yes Yes Yes ID
PROSPECT Dependent PARTY ID Yes Yes Yes ID
PROSPECT Dependent ROLE TYPE ID Yes Yes Yes ID
REGULATORY AGENCY Dependent PARTY ID Yes Yes Yes ID
REGULATORY AGENCY Dependent ROLE TYPE ID Yes Yes Yes ID
ROLE TYPE Independent ROLE TYPE ID Yes Yes No ID
ROLE TYPE Independent DESCRIPTION Yes No No Description
SHAREHOLDER Dependent PARTY ID Yes Yes Yes ID
SHAREHOLDER Dependent ROLE TYPE ID Yes Yes Yes ID
SHIP TO CUSTOMER Dependent PARTY ID Yes Yes Yes ID
SHIP TO CUSTOMER Dependent ROLE TYPE ID Yes Yes Yes ID
SUBSIDIARY Dependent PARTY ID Yes Yes Yes ID
SUBSIDIARY Dependent ROLE TYPE ID Yes Yes Yes ID
SUPPLIER Dependent PARTY ID Yes Yes Yes ID
SUPPLIER Dependent ROLE TYPE ID Yes Yes Yes ID
SUPPLIER RELATIONSHIP Dependent PARTY ID TO Yes Yes Yes ID
SUPPLIER RELATIONSHIP Dependent PARTY ID FROM Yes Yes Yes ID
SUPPLIER RELATIONSHIP Dependent FROM DATE Yes Yes Yes Datetime
SUPPLIER RELATIONSHIP Dependent ROLE TYPE ID FROM Yes Yes Yes ID
SUPPLIER RELATIONSHIP Dependent ROLE TYPE ID TO Yes Yes Yes ID