Schema diagram: 15 tables, 17 relationships
Relationships
17
contract_occupants.contract_id
·
on delete: cascade
contract_occupants.tenant_id
·
on delete: cascade
assets.room_id
·
on delete: cascade
meter_readings.room_id
·
on delete: cascade
fee_rates.fee_type_id
·
on delete: cascade
locations.user_id
·
on delete: cascade
rooms.location_id
·
on delete: cascade
invoice_items.invoice_id
·
on delete: cascade
contracts.room_id
·
on delete: restrict
contracts.tenant_id
·
on delete: restrict
invoices.contract_id
·
on delete: restrict
payments.invoice_id
·
on delete: restrict
invoice_items.meter_reading_id
·
on delete: set null
invoice_items.fee_rate_id
·
on delete: set null
electricity_rates.location_id
·
on delete: cascade
water_rates.location_id
·
on delete: cascade
fee_rates.location_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.