qryProjects


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
CompanyName nvarchar 100 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
sProjectId uniqueidentifier 16 null
ProjectNo nvarchar 100 null
ProjectNo2 nvarchar 100 null
ProjectType nvarchar 40 null
Title nvarchar 510 null
LocationId uniqueidentifier 16 null
JupiterId int 4 null
DataOwner nvarchar 40 null
Location nvarchar 100 null
Description1 nvarchar 510 null
Description2 nvarchar 510 null
Description3 nvarchar 2147483647 null
Status nvarchar 100 null
Address nvarchar 240 null
Town nvarchar 240 null
Postalcode nvarchar 40 null
PostalCodes.PostalCode Implied Constraint R
RegionNo int 4 null
Regions.RegionNo Implied Constraint R
Region nvarchar 240 null
MunicipalityNo int 4 null
Municipalities.MunicipalityNo Implied Constraint R
Municipality nvarchar 240 null
MunicipalityNo2 int 4 null
Client nvarchar 240 null
Contractor nvarchar 160 null
Initials1 nvarchar 100 null
Initials2 nvarchar 100 null
Report nvarchar 510 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
XUTM32EUREF89 float 8 null
YUTM32EUREF89 float 8 null
DateStart datetime 16 null
DateEnd datetime 16 null
SyntaxId uniqueidentifier 16 null
Syntaxes.SyntaxId Implied Constraint R
Interpretation nvarchar 100 null
Interpretations.Interpretation Implied Constraint R
SeriesId uniqueidentifier 16 null
LayerSeries.SeriesId Implied Constraint R
AutoGenerateStrata bit 1 null
AutoGenerateStrataAtSamples bit 1 null
AutoGenerateStrataIgnoreNoMatch bit 1 null
MaxInterpolationLength real 4 null
Interpretation2 nvarchar 100 null
SeriesId2 uniqueidentifier 16 null
AutoGenerateStrata2 bit 1 null
AutoGenerateStrataAtSamples2 bit 1 null
AutoGenerateStrataIgnoreNoMatch2 bit 1 null
MaxInterpolationLength2 real 4 null
Setup nvarchar 40 null
Setups.Setup Implied Constraint R
LinkId int 4 null
Locked bit 1 null
Url nvarchar 510 null
ProjectFolder nvarchar 510 null
Active bit 1 null
Wkt nvarchar 2147483647 null
Geom geometry 2147483647 null
FRef nvarchar 510 null
FRefCom nvarchar 100 null
FRefJob nvarchar 510 null
Company nvarchar 160 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views