Organisations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 null
AspNetUsers.OrganisationId FK_dbo.AspNetUsers_dbo.Organisations_OrganisationIdR
BreastSwitches.OrganisationId FK_dbo.BreastSwitches_dbo.Organisations_OrganisationIdR
Diagnosis.OrganisationId FK_dbo.Diagnosis_dbo.Organisations_OrganisationIdR
Investigations.OrganisationId FK_dbo.Investigations_dbo.Organisations_OrganisationIdR
Reviews.OrganisationId FK_dbo.Reviews_dbo.Organisations_OrganisationIdR
Staging.TNM_FI_OrganisationId FK_dbo.Staging_dbo.Organisations_TNM_FI_OrganisationIdR
OrganisationCode nvarchar 10 null
Description nvarchar 400 null
IsDeleted bit 1 null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Organisations Primary key Asc Id

Relationships