tblAddress


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 null
lnkDiagnosisAddress.AddressID FK_lnkDiagnosisAddress_tblAddress1R
lnkPatientAddress.AddressID FK_lnkPatientAddress_tblAddressR
Address1 varchar 150 null
Address2 varchar 150 null
Address3 varchar 150 null
Address4 varchar 150 null
Address5 varchar 150 null
Postcode varchar 10 null

Indexes

Constraint Name Type Sort Column(s)
PK_tblAddress Primary key Asc ID

Relationships