Schema Documentation

Source: dwh_ports OData endpoint — Cloud Insights

Tables found: 7 | Associations: 4

Table of Contents

Key Relationships
cardinals
connected_device_dimension
date_dimension
port_dimension
ports_fact
ports_fact_current
switch_dimension

Key Relationships Between Tables

ports_fact

Referenced (parent) table	FK column	Parent PK
connected_device_dimension	connectedDeviceTk	tk
date_dimension	dateTk	tk
port_dimension	portTk	tk
switch_dimension	switchTk	tk

Tables & Fields

PK Primary Key FK Foreign Key NOT NULL Required field

cardinals↑ top

Entity Set(s): cardinals

Field	Type	Nullable
digit	Int32	Yes

connected_device_dimension↑ top

Entity Set(s): connected_device_dimension

Field	Type	Nullable
tkPK	Int32	Yes
name	String	Yes
manufacturer	String	Yes
model	String	Yes
type	String	Yes
firmware	String	Yes
id	Int32	Yes
latest	String	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
ports_fact	ports_fact	many

date_dimension↑ top

Entity Set(s): date_dimension

Field	Type	Nullable
tk	Int32	Yes
fullDate	DateTimeOffset	Yes
dayInMonth	Byte	Yes
dayInYear	Int32	Yes
dateYear	Int32	Yes
yearLabel	String	Yes
monthNum	Byte	Yes
monthLabel	String	Yes
dayInWeekNum	Byte	Yes
quarter	Byte	Yes
quarterLabel	String	Yes
dayInQuarter	Int32	Yes
repQuarter	Byte	Yes
repMonth	Byte	Yes
repWeek	Byte	Yes
repDay	Byte	Yes
repMonthOrLatest	Byte	Yes
sspFlag	Byte	Yes
latest	String	Yes
future	String	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
ports_fact	ports_fact	many

port_dimension↑ top

Entity Set(s): port_dimension

Field	Type	Nullable
tk	Int32	Yes
wwn	String	Yes
name	String	Yes
gbicType	String	Yes
type	String	Yes
speed	String	Yes
isGenerated	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
ports_fact	ports_fact	many

ports_fact↑ top

Entity Set(s): ports_fact

Field	Type	Nullable
tkPK	Int32	Yes
dateTkFK → date_dimension.tk	Int32	Yes
switchTkFK → switch_dimension.tk	Int32	Yes
connectedDeviceTkFK → connected_device_dimension.tk	Int32	Yes
portTkFK → port_dimension.tk	Int32	Yes
fabric	String	Yes
speed	String	Yes
connectivityType	String	Yes
type	String	Yes
status	String	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
connected_device_dimension	connected_device_dimension	one JOIN: `connectedDeviceTk` = connected_device_dimension.`tk`
port_dimension	port_dimension	one JOIN: `portTk` = port_dimension.`tk`
date_dimension	date_dimension	one JOIN: `dateTk` = date_dimension.`tk`
switch_dimension	switch_dimension	one JOIN: `switchTk` = switch_dimension.`tk`

ports_fact_current↑ top

Entity Set(s): ports_fact_current

Field	Type	Nullable
tk	Int32	Yes
dateTk	Int32	Yes
switchTk	Int32	Yes
connectedDeviceTk	Int32	Yes
portTk	Int32	Yes
fabric	String	Yes
speed	String	Yes
connectivityType	String	Yes
type	String	Yes
status	String	Yes

switch_dimension↑ top

Entity Set(s): switch_dimension

Field	Type	Nullable
tk	Int32	Yes
wwn	String	Yes
name	String	Yes
identifier	String	Yes
ip	String	Yes
model	String	Yes
manufacturer	String	Yes
firmware	String	Yes
serialNumber	String	Yes
npv	String	Yes
isGenerated	String	Yes
type	String	Yes
url	String	Yes
id	Int32	Yes
latest	String	Yes
dateTk	Int32	Yes
dataCenter	String	Yes
switchLevel	String	Yes

Navigation Properties (Joins)

Nav Property	Related Entity	Cardinality / Join
ports_fact	ports_fact	many