Models


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProjectId uniqueidentifier 16 null
Projects.ProjectId Models_Projects_ForeignKey C
ModelId uniqueidentifier 16 null
ModelCells.ModelId ModelCells_Models_ForeignKey C
qryModelCells.ModelId Implied Constraint R
qryModels.ModelId Implied Constraint R
Model nvarchar 100 null
Type nvarchar 100 null
Description nvarchar 510 null
Projection int 4 null
x1 float 8 null
y1 float 8 null
z1 float 8 null
x2 float 8 null
y2 float 8 null
z2 float 8 null
dx real 4 null
dy real 4 null
dz real 4 null
nx real 4 null
ny real 4 null
nz real 4 null
Rotation real 4 null
sModelId uniqueidentifier 16 null
SeriesId uniqueidentifier 16 null
LayerSeries.SeriesId Models_LayerSeries_ForeignKey R
mLayerId uniqueidentifier 16 null
bLayerId uniqueidentifier 16 null
pLayerId uniqueidentifier 16 null
FRef nvarchar 510 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
Models_PrimaryKey Primary key Asc ModelId
Models_FRef_Index Performance Asc FRef
Models_ModelId_Index Performance Asc ModelId
Models_ProjectId_Index Performance Asc ProjectId

Relationships