representatives

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
representative_id bigserial 19 nextval('representatives_representative_id_seq'::regclass)
submission_id int8 19 null
submissions.submission_id representatives_submission_idC
role varchar 40 null
representative_id_type varchar 255 null
representative_id_value varchar 255 null
name varchar 255 null
phone varchar 255 null
email varchar 255 null
url varchar 2047 null
is_supplier int2 5 '1'::smallint

Indexes

Constraint Name Type Sort Column(s)
representatives_pkey Primary key Asc representative_id
format_representatives_pkey Performance Asc/Asc representative_id + submission_id
representatives_submission_id Performance Asc submission_id

Relationships