Schema diagram: 18 tables, 19 relationships
Relationships
19
role_permissions.role_id
·
on delete: cascade
role_permissions.permission_id
·
on delete: cascade
property_user_roles.user_id
·
on delete: cascade
property_user_roles.role_id
·
on delete: cascade
cities.district_id
·
on delete: cascade
property_user_roles.property_id
·
on delete: cascade
properties.property_type_id
·
on delete: cascade
guests.user_id
·
on delete: cascade
employees.user_id
·
on delete: cascade
guests.country_id
·
on delete: cascade
guests.currency_id
·
on delete: set null
properties.subscription_plan_id
·
on delete: restrict
properties.city_id
·
on delete: restrict
properties.user_id
·
on delete: cascade
rooms.property_id
·
on delete: cascade
rooms.room_type_id
·
on delete: restrict
room_types.property_id
·
on delete: no action
units.property_id
·
on delete: cascade
rooms.unit_id
·
on delete: set null
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.