Tables


SchemaSpy Analysis of signalo.signalo_db

Generated on Fri Jan 09 08:38 UTC 2026

‘signalo data model documentation (version dev)’

XML Representation
Insertion Order Deletion Order
TABLES 25
VIEWS 0
COLUMNS 295
Constraints 28
Anomalies 9
Routines 4

Database Properties

Database Type: PostgreSQL - 16.9 (Debian 16.9-1.pgdg110+1)

Tables

Table / View Children Parents Columns Rows Type Comments
vl_frame_fixing_type 1 0 6 7 Table
vl_user_sign 1 0 26 -1 Table
vl_durability 1 0 6 6 Table
vl_provider 3 0 10 3 Table
pum_migrations 0 0 8 -1 Table

version: 1 – schema_migration table version

frame 1 6 22 -1 Table
dms_rel_document 0 1 4 -1 Table
support 1 6 27 -1 Table
vl_marker_type 1 0 26 9 Table
vl_mounting_point 1 0 6 -1 Table
vl_owner 2 0 10 4 Table
sign 1 14 40 -1 Table
vl_official_sign 1 0 26 313 Table
dms_document 1 0 4 -1 Table
vl_coating 1 0 6 7 Table
vl_sign_type 1 0 6 7 Table
vl_hanging_mode 1 0 6 -1 Table
vl_support_tube_type 1 0 4 -1 Table
vl_support_type 1 0 6 10 Table
vl_lighting 1 0 6 7 Table
vl_frame_type 1 0 6 8 Table
vl_mirror_shape 1 0 6 3 Table
vl_status 3 0 6 6 Table
azimut 1 1 16 -1 Table
vl_support_base_type 1 0 6 25 Table