guestbookresponse

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('guestbookresponse_id_seq'::regclass)
customquestionresponse.guestbookresponse_id fk_customquestionresponse_guestbookresponse_id R
filedownload.guestbookresponse_id fk_filedownload_guestbookresponse_id R
email varchar 255 √ null
institution varchar 255 √ null
name varchar 255 √ null
position varchar 255 √ null
responsetime timestamp 29,6 √ null
authenticateduser_id int8 19 √ null
authenticateduser.id fk_guestbookresponse_authenticateduser_id R
datafile_id int8 19 null
dvobject.id fk_guestbookresponse_datafile_id R
dataset_id int8 19 null
dvobject.id fk_guestbookresponse_dataset_id R
datasetversion_id int8 19 √ null
datasetversion.id fk_guestbookresponse_datasetversion_id R
guestbook_id int8 19 null
guestbook.id fk_guestbookresponse_guestbook_id R

Indexes

Constraint Name Type Sort Column(s)
guestbookresponse_pkey Primary key Asc id
index_guestbookresponse_datafile_id Performance Asc datafile_id
index_guestbookresponse_dataset_id Performance Asc dataset_id
index_guestbookresponse_guestbook_id Performance Asc guestbook_id

Relationships

Close relationships within degrees of separation