Schema diagram: 34 tables, 59 relationships
Relationships
59
otp_codes.user_id
·
on delete: cascade
social_accounts.user_id
·
on delete: cascade
vehicles.user_id
·
on delete: cascade
vehicle_models.vehicle_make_id
·
on delete: cascade
vehicles.vehicle_make_id
·
on delete: restrict
vehicles.vehicle_model_id
·
on delete: restrict
recent_places.user_id
·
on delete: cascade
recent_places.place_id
·
on delete: cascade
saved_places.user_id
·
on delete: cascade
saved_places.place_id
·
on delete: set null
spots.garage_id
·
on delete: restrict
garage_photos.garage_id
·
on delete: cascade
pivot: amenity_garage
·
on delete: cascade
gate_scans.garage_id
·
on delete: restrict
bookings.user_id
·
on delete: restrict
bookings.spot_id
·
on delete: restrict
bookings.vehicle_id
·
on delete: restrict
parking_sessions.booking_id
·
on delete: restrict
parking_sessions.user_id
·
on delete: restrict
parking_sessions.spot_id
·
on delete: restrict
parking_sessions.vehicle_id
·
on delete: restrict
session_extensions.parking_session_id
·
on delete: restrict
monthly_applications.user_id
·
on delete: restrict
monthly_applications.spot_id
·
on delete: restrict
monthly_applications.vehicle_id
·
on delete: restrict
subscriptions.user_id
·
on delete: restrict
subscriptions.spot_id
·
on delete: restrict
subscriptions.vehicle_id
·
on delete: restrict
subscriptions.monthly_application_id
·
on delete: restrict
subscriptions.payment_card_id
·
on delete: set null
invoices.subscription_id
·
on delete: restrict
wallets.user_id
·
on delete: restrict
wallet_transactions.wallet_id
·
on delete: restrict
wallet_transactions.reference_{type,id}
·
on delete: cascade
wallet_transactions.reference_{type,id}
·
on delete: cascade
wallet_transactions.reference_{type,id}
·
on delete: cascade
wallet_transactions.reference_{type,id}
·
on delete: cascade
payment_cards.user_id
·
on delete: cascade
payments.user_id
·
on delete: restrict
payments.payment_card_id
·
on delete: set null
invoices.payment_id
·
on delete: set null
payments.payable_{type,id}
·
on delete: cascade
payments.payable_{type,id}
·
on delete: cascade
payments.payable_{type,id}
·
on delete: cascade
payments.payable_{type,id}
·
on delete: cascade
payments.payable_{type,id}
·
on delete: cascade
user_vouchers.voucher_id
·
on delete: restrict
user_vouchers.user_id
·
on delete: cascade
user_vouchers.booking_id
·
on delete: set null
user_notifications.user_id
·
on delete: cascade
devices.user_id
·
on delete: cascade
gate_scans.passable_{type,id}
·
on delete: cascade
gate_scans.passable_{type,id}
·
on delete: cascade
support_articles.support_topic_id
·
on delete: cascade
support_tickets.user_id
·
on delete: cascade
support_tickets.support_topic_id
·
on delete: restrict
support_tickets.booking_id
·
on delete: set null
support_tickets.subscription_id
·
on delete: set null
assistant_messages.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
- Show or hide the minimap
- M
- 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.