sisalto_rakenne_sisalto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sisalto_rakenne int8 19 null
sisalto_rakenne.id sisalto_rakenne_sisalto_sisalto_rakenne_fkey R
sisalto int8 19 null
rakenne_sisalto.id sisalto_rakenne_sisalto_sisalto_fkey R
rooli varchar 64 null
jarjestys int4 10 null

Indexes

Constraint Name Type Sort Column(s)
sisalto_rakenne_sisalto_pkey Primary key Asc/Asc sisalto_rakenne + sisalto
sisalto_rakenne_sisalto_sisalto_rakenne_jarjestys_key Must be unique Asc/Asc sisalto_rakenne + jarjestys

Check Constraints

Constraint Name Constraint
sisalto_rakenne_sisalto_rooli (((rooli)::text = ANY (ARRAY[('header'::character varying)::text, ('body'::character varying)::text, ('sms'::character varying)::text, ('attachment'::character varying)::text])))

Relationships

Close relationships within degrees of separation