comic_event


Columns

Column Type Size Nulls Auto Default Children Parents Comments
comic_id bpchar 4 null
comics.comic_id comic_event_comic_id_fkey C
rank int4 10 √ null
role varchar 2147483647 null
event_id bpchar 8 null
events.event_id comic_event_event_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
comic_event_pkey Primary key Asc/Asc comic_id + event_id

Check Constraints

Constraint Name Constraint
comic_event_null_rank_role_check ((((rank IS NULL) AND ((role)::text = 'COLLECTION'::text)) OR ((rank IS NOT NULL) AND ((role)::text <> 'COLLECTION'::text))))
comic_event_not_null_rank_role_check ((((rank = 0) AND ((role)::text = 'GUIDE'::text)) OR ((rank > 0) AND ((role)::text <> 'GUIDE'::text))))
comic_event_role_check (((role)::text = ANY ((ARRAY['COLLECTION'::character varying, 'CORE'::character varying, 'EPILOGUE'::character varying, 'GUIDE'::character varying, 'PROLOGUE'::character varying, 'TIE-IN'::character varying])::text[])))

Relationships

Close relationships within degrees of separation