Tables


SchemaSpy Analysis of paa_dev

Generated on Mon Nov 02 01:41 EET 2020

XML Representation
Insertion Order Deletion Order
TABLES 38
VIEWS 0
COLUMNS 387
Constraints 30
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 12.2

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
backup_role 0 1 7 4 Table
permission 1 0 7 32 Table
vis_vessel 0 0 9 5 Table
timestamp_state 3 1 8 268 Table
nomination_berth 0 2 8 9 Table
vessel 1 0 8 128 Table
vis_voyage_plan 0 1 15 14 Table
crud_log 0 0 7 559 Table
berth_reservation 0 3 10 5 Table
translation 0 0 9 423 Table
timestamp_definition 0 2 8 18 Table
role 2 0 7 6 Table
nomination 2 1 12 6 Table
api_key 1 1 9 13 Table
port_call 2 2 51 11 Table
vis_message 0 0 13 6 Table
role_permission 0 2 7 75 Table
timestamp 0 3 14 143 Table
slot_reservation 2 4 22 10 Table
registration_codes 1 0 9 5 Table
setting 0 0 7 10 Table
migration 0 0 3 104 Table
berth 3 0 8 3 Table
port 0 0 10 0 Table
berth_reservation_type 1 0 7 2 Table
inbound_vessel 0 0 10 0 Table
timestamp_time_type 3 0 6 5 Table
timestamp_state_type 1 0 6 3 Table
vis_rtz_state 1 0 6 6 Table
user 4 2 16 154 Table
logistics_timestamp 0 0 9 18 Table
push_notification_token 0 1 9 2 Table
pinned_vessel 0 1 7 14 Table
notification 0 0 8 63 Table
slot_reservation_status 1 0 7 9 Table
vis_notification 0 0 12 9 Table
timestamp_api_key_weight 0 3 9 4 Table
nomination_status 1 0 7 3 Table