Schema diagram: 7 tables, 6 relationships
Relationships
6
users.region_id
·
on delete: cascade
alerts.disaster_type_id
·
on delete: cascade
alerts.region_id
·
on delete: cascade
user_alert.user_id
·
on delete: cascade
user_alert.alert_id
·
on delete: cascade
reports.user_id
·
on delete: cascade
Keyboard shortcuts
Press ? any time to reopen this.
Canvas
- Fit the whole schema on screen
- F
- Zoom in and out
- + / −
- Reset zoom and position
- 0
- Find a table by name
- / or T
- Show or hide the side panel
- B
- Undo the last layout or group change
- Ctrl/⌘ Z
- Cancel the current mode or close a panel
- Esc
With a table focused (press Tab to reach one)
- Move to the next table
- Tab
- Open it in the table editor
- Enter
- Move it around the canvas
- ↑ ↓ ← →
- Move it one pixel at a time
- Shift + arrows
- Collapse or expand it
- C
- Add a column to it
- N
- Delete it (with a confirmation)
- Delete
Delete ?
and any relationships touching it go too. You can undo this straight afterwards.