Municipalities


Columns

Column Type Size Nulls Auto Default Children Parents Comments
RegionNo int 4 null
Regions.RegionNo Municipalities_Regions_ForeignKey R
MunicipalityNo int 4 null
Points.MunicipalityNo Implied Constraint R
Projects.MunicipalityNo Implied Constraint R
qryAnalysisSamples.MunicipalityNo Implied Constraint R
qryAnalysisValues.MunicipalityNo Implied Constraint R
qryPoints.MunicipalityNo Implied Constraint R
qryProjects.MunicipalityNo Implied Constraint R
qryWaterLevels.MunicipalityNo Implied Constraint R
Municipality nvarchar 510 null
XUTMMin float 8 null
XUTMMax float 8 null
YUTMMin float 8 null
YUTMMax float 8 null
WWW nvarchar 510 null
Projection int 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
Active bit 1 null

Table contained 324 rows

Indexes

Constraint Name Type Sort Column(s)
Municipalities_PrimaryKey Primary key Asc MunicipalityNo
Municipalities_MunicipalityNo_Index Performance Asc MunicipalityNo
Municipalities_MunicipalityNo_UniqueKey Must be unique Asc MunicipalityNo
Municipalities_RegionNo_Index Performance Asc RegionNo

Relationships