sisalto_rakenne


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('kirjeet.sisalto_rakenne_id_seq'::regclass)
sisalto_rakenne_sisalto.sisalto_rakenne sisalto_rakenne_sisalto_sisalto_rakenne_fkey R
rakenne int8 19 null
rakenne.id sisalto_rakenne_rakenne_fkey R
tyyppi varchar 127 null
tyyli int8 19 √ null
tyyli.id sisalto_rakenne_tyyli_fkey R
aikaleima timestamp 29,6 now()

Indexes

Constraint Name Type Sort Column(s)
sisalto_rakenne_pkey Primary key Asc id
sisalto_rakenne_rakenne_tyyppi_key Must be unique Asc/Asc rakenne + tyyppi

Check Constraints

Constraint Name Constraint
sisalto_rakenne_tyyppi (((tyyppi)::text = ANY (ARRAY[('email'::character varying)::text, ('letter'::character varying)::text, ('asiointitili'::character varying)::text, ('accessibleHtml'::character varying)::text])))

Relationships

Close relationships within degrees of separation