Tables


SchemaSpy Analysis of signalo.signalo_db

Generated on Wed Apr 10 09:22 GMT 2024

‘signalo data model documentation (version 1.0.0)’

XML Representation
Insertion Order Deletion Order
TABLES 21
VIEWS 0
COLUMNS 246
Constraints 25
Anomalies 9
Routines 4

Database Properties

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

Tables

Table / View Children Parents Columns Rows Type Comments
dms_document 1 0 4 -1 Table
vl_frame_fixing_type 1 0 6 7 Table
vl_coating 1 0 6 7 Table
vl_user_sign 1 0 26 -1 Table
vl_sign_type 1 0 6 7 Table
vl_durability 1 0 6 6 Table
vl_provider 3 0 10 3 Table
frame 1 5 21 -1 Table
dms_rel_document 0 1 4 -1 Table
support 1 5 25 -1 Table
vl_marker_type 1 0 6 9 Table
vl_support_type 1 0 6 10 Table
vl_owner 2 0 10 4 Table
vl_lighting 1 0 6 7 Table
vl_frame_type 1 0 6 8 Table
vl_mirror_shape 1 0 6 3 Table
sign 1 14 39 -1 Table
vl_official_sign 2 0 26 341 Table
vl_status 3 0 6 6 Table
azimut 1 1 15 -1 Table
vl_support_base_type 1 0 6 25 Table