boards


Columns

Column Type Size Nulls Auto Default Children Parents Comments
board_id bpchar 8 √ to_char(nextval('board_id_seq'::regclass), '"BOARD"-FM00'::text)
comic_bag_board.board_id comic_bag_board_board_id_fkey R
manufacturer varchar 32 null
age varchar 16 null
thickness int4 10 null
dimensions varchar 16 null
acid bool 1 false

Indexes

Constraint Name Type Sort Column(s)
boards_pkey Primary key Asc board_id

Check Constraints

Constraint Name Constraint
boards_age_check (((age)::text = ANY ((ARRAY['CURRENT'::character varying, 'MODERN'::character varying, 'CURRENT/MODERN'::character varying, 'GOLDEN'::character varying, 'SILVER'::character varying, 'BRONZE'::character varying, 'PLATINUM'::character varying])::text[])))
boards_valid_id_check ((board_id ~ '^BOARD-\d{2}$'::text))
boards_thickness_check ((thickness > 0))
boards_dimensions_check (((dimensions)::text ~ '^((\d+) |(\d+\/\d+) |(\d+) (\d+\/\d+) )x( (\d+)| (\d+\/\d+)| (\d+) (\d+\/\d+))$'::text))

Relationships

Close relationships within degrees of separation