GLogs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId GLogs_Points_ForeignKey C
LogId uniqueidentifier 16 null
GLogDraw.LogId Implied Constraint R
GLogValues.LogId GLogValues_GLogs_ForeignKey C
Log nvarchar 240 null
LogType nvarchar 240 null
GLogTypes.LogType Implied Constraint R
Direction nvarchar 2 null
Probe nvarchar 510 null
Casing nvarchar 240 null
Reference nvarchar 100 null
ReferenceLevel real 4 null
Filename nvarchar 160 null
LogDate datetime 16 null
LogCompany nvarchar 100 null
LogInitials nvarchar 100 null
Description1 nvarchar 510 null
Description2 nvarchar 510 null
Description3 nvarchar 510 null
LogType1 nvarchar 40 null
Unit1 nvarchar 40 null
LogType2 nvarchar 40 null
Unit2 nvarchar 40 null
LogType3 nvarchar 40 null
Unit3 nvarchar 40 null
LogType4 nvarchar 40 null
Unit4 nvarchar 40 null
LogType5 nvarchar 40 null
Unit5 nvarchar 40 null
LogType6 nvarchar 40 null
Unit6 nvarchar 40 null
LogType7 nvarchar 40 null
Unit7 nvarchar 40 null
LogType8 nvarchar 40 null
Unit8 nvarchar 40 null
LogType9 nvarchar 40 null
Unit9 nvarchar 40 null
LogType10 nvarchar 40 null
Unit10 nvarchar 40 null
LogType11 nvarchar 40 null
Unit11 nvarchar 40 null
LogType12 nvarchar 40 null
Unit12 nvarchar 40 null
LogType13 nvarchar 40 null
Unit13 nvarchar 40 null
LogType14 nvarchar 40 null
Unit14 nvarchar 40 null
LogType15 nvarchar 40 null
Unit15 nvarchar 40 null
LogType16 nvarchar 40 null
Unit16 nvarchar 40 null
LogType17 nvarchar 40 null
Unit17 nvarchar 40 null
LogType18 nvarchar 40 null
Unit18 nvarchar 40 null
LogType19 nvarchar 40 null
Unit19 nvarchar 40 null
LogType20 nvarchar 40 null
Unit20 nvarchar 40 null
LogType21 nvarchar 40 null
Unit21 nvarchar 40 null
LogType22 nvarchar 40 null
Unit22 nvarchar 40 null
LogType23 nvarchar 40 null
Unit23 nvarchar 40 null
LogType24 nvarchar 40 null
Unit24 nvarchar 40 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
GLogs_PrimaryKey Primary key Asc LogId
GLogs_LogId_Index Performance Asc LogId
GLogs_PointId_Index Performance Asc PointId

Relationships