folio_pattern

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
booking.folio_pattern_id fk_booking_folpat_id R
channel.folpat_id fk_channel_folpat_id N
folio.folio_pattern_id fk_folio_folio_pattern_id N
folio_pattern_seq.pattern_id folio_pattern_seq_pattern_id_fk C
registration.folio_pattern_id fk_registration_folpat_id R
name citext 2147483647 √ null
split_room_charge bool 1 √ false
enabled bool 1 √ true

Indexes

Constraint Name Type Sort Column(s)
folio_pattern_pkey Primary key Asc id
folio_pattern_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation