Tables [dbo].[Employer]
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Employer_ID: IDIndexes ix_EmployerForeign Keys FK_Employer_ID_Business_Entity_ID: [dbo].[Business_Entity].IDIDnumeric(8,0)5NOT NULLKey to the Employer  table.
Indexes ix_EmployerNamevarchar(35)35NOT NULLEmployer name
NumberOfEmployeessmallint2NOT NULL(0)Number of Employees
Foreign Keys FK_Employer_ParentEmployerID_Employer_ID: [dbo].[Employer].ParentEmployerIDParentEmployerIDnumeric(8,0)5NOT NULLParent Employer. Link to Employer.ID