View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
1971 | RackTables | default | public | 2020-04-29 10:55 | 2020-05-04 13:48 |
Reporter | venkatra0 | Assigned To | |||
Priority | urgent | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Summary | 1971: ER Model of Racktable Database | ||||
Description | Hi 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. | ||||
Tags | No tags attached. | ||||
Can someone please help me on this. | |
Hi Team, Can i have this data, need submit some report based on the custom query. Appreciate the support. |
|
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. |
|
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 |