View Issue Details

IDProjectCategoryView StatusLast Update
1971RackTablesdefaultpublic2020-05-04 13:48
Reportervenkatra0 Assigned To 
PriorityurgentSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Summary1971: ER Model of Racktable Database
DescriptionHi Team,
With the existing entries in DB, want to query some specific data by querying directly from DB, Can someone share the ER model to understand how the tables were designed.

Also appreciate if you can share the DB query to get the report of objects for a specified location with the rack, row and location details.

Thanks in advance.
TagsNo tags attached.

Activities

venkatra0

venkatra0

2020-04-30 18:21

reporter   ~0004059

Can someone please help me on this.
venkatra0

venkatra0

2020-05-04 13:06

reporter   ~0004065

Hi Team,
Can i have this data, need submit some report based on the custom query. Appreciate the support.
infrastation

infrastation

2020-05-04 13:41

administrator   ~0004067

SQL dump: https://code.racktables.org/racktables/blob/HEAD:/tests/data/0.21.4.sql
table relations diagram (not 100% complete): https://code.racktables.org/racktables-contribs/blob/HEAD:/figures/RackTables-Schema.png

The database usually takes some time to learn.

Issue History

Date Modified Username Field Change
2020-04-29 10:55 venkatra0 New Issue
2020-04-30 18:21 venkatra0 Note Added: 0004059
2020-05-04 13:06 venkatra0 Note Added: 0004065
2020-05-04 13:41 infrastation Note Added: 0004067
2020-05-04 13:48 infrastation Status new => closed
2020-05-04 13:48 infrastation Resolution open => fixed