View Issue Details

IDProjectCategoryView StatusLast Update
1971RackTablesdefaultpublic2020-05-04 13:48
Reportervenkatra0 Assigned To 
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.




2020-04-30 18:21

reporter   ~0004059

Can someone please help me on this.


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.


2020-05-04 13:41

administrator   ~0004067

SQL dump:
table relations diagram (not 100% complete):

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