Table share_pass
Stores temporary passes for items shared via email

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 40
activated bool 1
creator varchar 255
email_address varchar 150
expiry timestamp 29,6  √  null
password varchar 30  √  null
privilege varchar 20
started timestamp 29,6  √  null
institution_id int8 19
institution.id fk956be071bc711081 R
item_id int8 19
item.id fk956be0716f7f1a9c R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc share_pass_pkey
institution_id Performance Asc sharepassinstitution
item_id Performance Asc sharepassitem

Close relationships  within of separation: