creators


Columns

Column Type Size Nulls Auto Default Children Parents Comments
creator_id bpchar 11 √ to_char(nextval('creator_id_seq'::regclass), '"CREATOR-"FM000'::text)
comic_creator.creator_id comic_creator_creator_id_fkey R
signatures.signature signatures_creator_id_fkey R
first_name varchar 16 null
middle_name varchar 16 √ null
last_name varchar 16 √ null

Indexes

Constraint Name Type Sort Column(s)
creators_pkey Primary key Asc creator_id
creators_first_middle_last_key Must be unique Asc/Asc/Asc first_name + middle_name + last_name

Check Constraints

Constraint Name Constraint
creators_creator_id_check ((creator_id ~ '^CREATOR-[0-9]{3}$'::text))

Relationships

Close relationships within degrees of separation