boxes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
box_id bpchar 6 √ to_char(nextval('box_id_seq'::regclass), '"BOX"-FM00'::text)
comic_box.box_id comic_box_box_id_fkey N
name varchar 16 null
type varchar 8 null
size varchar 5 null
color varchar 16 null
material varchar 16 null
manufacturer varchar 16 null

Indexes

Constraint Name Type Sort Column(s)
boxes_pkey Primary key Asc box_id

Check Constraints

Constraint Name Constraint
boxes_id_check ((box_id ~ '^BOX-\d{2}$'::text))
boxes_size_check (((size)::text = ANY ((ARRAY['SHORT'::character varying, 'LONG'::character varying])::text[])))
boxes_type_check (((type)::text = ANY ((ARRAY['PHYSICAL'::character varying, 'VIRTUAL'::character varying])::text[])))

Relationships

Close relationships within degrees of separation