clutterstock
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Room
0
rows
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
Id
int4
10
√
null
Item
.RoomId
FK_Item_Room_RoomId
C
LocationId
int4
10
null
Location
.Id
FK_Room_Location_LocationId
C
Name
varchar
200
null
Description
varchar
2000
√
null
CreatedAtUtc
timestamptz
35,6
null
UpdatedAtUtc
timestamptz
35,6
√
null
Indexes
Constraint Name
Type
Sort
Column(s)
PK_Room
Primary key
Asc
Id
IX_Room_LocationId
Performance
Asc
LocationId
Relationships
Close relationships within degrees of separation
One