frame

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 uuid_generate_v1()
sign.fk_frame fkey_od_frame R
fk_azimut uuid 2147483647 null
azimut.id fkey_od_azimut R

Foreign key of associated azimut
rank int4 10 1

Ranking (automatically filled in in QGIS) depending on the order of frames for each azimut
fk_frame_type int4 10 √ null
vl_frame_type.id fkey_vl_frame_type R

Foreign key for frame type value list
fk_frame_fixing_type int4 10 √ null
vl_frame_fixing_type.id fkey_vl_frame_fixing_type R

Foreign key for frame fixing type value list
double_sided bool 1 √ true

Set true if double sided (default). This has no influence on the symbology of the map
fk_status int4 10 √ null
vl_status.id fkey_vl_status R

Foreign key of status value list
fk_provider uuid 2147483647 √ null
vl_provider.id fkey_od_provider R

Foreign key of provider value list
comment text 2147483647 √ null
picture text 2147483647 √ null
dimension_1 numeric 8,3 √ null

If frame is rectangular, height/width; if frame is circular, radius; if frame is elliptic, major/minor radius
dimension_2 numeric 8,3 √ null

If frame is rectangular, height/width; if frame is circular, not needed; if frame is elliptic, major/minor radius
usr_frame_1 text 2147483647 √ null
usr_frame_2 text 2147483647 √ null
usr_frame_3 text 2147483647 √ null
_creation_date timestamp 29,6 √ now()
_creation_user text 2147483647 √ null
_last_modification_date timestamp 29,6 √ now()
_last_modification_user text 2147483647 √ null
fk_mounting_point text 2147483647 'center'::text
vl_mounting_point.id frame_fk_mounting_point_key R

Anchor point of frame (left, right, center). Default is center. This value influences the visual representation on the map and is used in support.group_by_mounting_point condition
needs_validation bool 1 false
_last_modification_platform text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
frame_pkey Primary key Asc id
frame_fk_azimut_idx Performance Asc fk_azimut
frame_fk_azimut_rank_key Must be unique Asc/Asc fk_azimut + rank

Relationships

Close relationships within degrees of separation