Entity Specialty

DescriptionA listing of specialized branches of medical science or patient care.

Attributes
Specialty NameSpecialty Name

Relationship
Specialty SubSpecialty FKSpecialty SubSpecialty FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Specialty Name
DescriptionText description of a practitioner's specialty.

For Example:
Dermatology
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Specialty SubSpecialty FK
Is Identifying Relationshiptrue
Child TableSpecialty
Child Role Namehas subspecialty
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSpecialty
Parent Role Nameis subspecialty
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE