folio_pattern_details

206 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pattern_id int4 10 null
folio_pattern_seq.pattern_id fk_folio_pattern_details_folio_pattern_seq C
folio_seq int2 5 null
folio_pattern_seq.folio_seq fk_folio_pattern_details_folio_pattern_seq C
dept_id int4 10 null
department.id fk_folio_pattern_details_dept_id C

Indexes

Constraint Name Type Sort Column(s)
folio_pattern_details_pk Primary key Asc/Asc/Asc pattern_id + folio_seq + dept_id
folio_pattern_details_pattern_id_idx Performance Asc/Asc pattern_id + folio_seq

Relationships

Close relationships within degrees of separation