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
rank int4 10 1
fk_frame_type int4 10 √ null
vl_frame_type.id fkey_vl_frame_type R
fk_frame_fixing_type int4 10 √ null
vl_frame_fixing_type.id fkey_vl_frame_fixing_type R
double_sided bool 1 √ true
fk_status int4 10 √ null
vl_status.id fkey_vl_status R
fk_provider uuid 2147483647 √ null
vl_provider.id fkey_od_provider R
comment text 2147483647 √ null
picture text 2147483647 √ null
dimension_1 numeric 8,3 √ null
dimension_2 numeric 8,3 √ null
usr_frame_1 text 2147483647 √ null
usr_frame_2 text 2147483647 √ null
usr_frame_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
anchor "signalo_db"."anchor" 2147483647 'CENTER'::signalo_db.anchor

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