qryLegPenetrations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
JackupId uniqueidentifier 16 null
Jackups.JackupId Implied Constraint R
PenetrationId uniqueidentifier 16 null
LegPenetrations.PenetrationId Implied Constraint R
LegNo int 4 null
ZInitial real 4 null
Depth real 4 null
LegLoad real 4 null
LegArea real 4 null
X float 8 null
Y float 8 null
XR float 8 null
YR float 8 null
Description nvarchar 510 null
Rig nvarchar 100 null
Rigs.Rig Implied Constraint R
JackupDate datetime 16 null
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
ProjectNo nvarchar 100 null
PointNo nvarchar 160 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
DateEnd datetime 16 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
VerticalRefId1 nvarchar 100 null
Z1 real 4 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
VerticalRefId2 nvarchar 100 null
Z2 real 4 null
Active bit 1 null
Locked bit 1 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views