sign

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 uuid_generate_v1()
sign.fk_parent fkey_od_sign N
fk_frame uuid 2147483647 null
frame.id fkey_od_frame R
rank int4 10 1
complex bool 1 false
fk_sign_type int4 10 null
vl_sign_type.id fkey_vl_sign_type R
fk_official_sign text 2147483647 √ null
vl_official_sign.id fkey_vl_official_sign R
fk_marker_type text 2147483647 √ null
vl_marker_type.id fkey_vl_marker_type R
fk_mirror_shape int4 10 √ null
vl_mirror_shape.id fkey_vl_mirror_shape R
fk_parent uuid 2147483647 √ null
sign.id fkey_od_sign N
fk_owner uuid 2147483647 √ null
vl_owner.id fkey_od_owner R
fk_provider uuid 2147483647 √ null
vl_provider.id fkey_od_provider R
fk_durability int4 10 √ null
vl_durability.id fkey_vl_durability R
fk_status int4 10 √ null
vl_status.id fkey_vl_status R
installation_date date 13 √ null
manufacturing_date date 13 √ null
case_id text 2147483647 √ null
case_decision text 2147483647 √ null
inscription_1 text 2147483647 √ null
inscription_2 text 2147483647 √ null
inscription_3 text 2147483647 √ null
fk_coating int4 10 √ null
vl_coating.id fkey_vl_coating R
fk_lighting int4 10 √ null
vl_lighting.id fkey_vl_lighting R
comment text 2147483647 √ null
picture text 2147483647 √ null
mirror_protruding bool 1 √ false
mirror_red_frame bool 1 √ false
dimension_1 numeric 8,3 √ null
dimension_2 numeric 8,3 √ null
usr_sign_1 text 2147483647 √ null
usr_sign_2 text 2147483647 √ null
usr_sign_3 text 2147483647 √ null
_inserted_date timestamp 29,6 √ now()
_inserted_user text 2147483647 √ null
_last_modified_date timestamp 29,6 √ now()
_last_modified_user text 2147483647 √ null
_edited bool 1 √ false
fk_user_sign uuid 2147483647 √ null
vl_user_sign.id fkey_vl_user_sign R
natural_direction_or_left bool 1 true
hanging_mode "signalo_db"."sign_hanging" 2147483647 'RECTO'::signalo_db.sign_hanging

Indexes

Constraint Name Type Sort Column(s)
sign_pkey Primary key Asc id
sign_fk_frame_idx Performance Asc fk_frame
sign_fk_frame_rank_verso_key Must be unique Asc/Asc/Asc fk_frame + rank + hanging_mode

Relationships

Close relationships within degrees of separation