Table test_seqware_meta_db.public.registration
Authenticate users of this metadb

Generated by
SchemaSpy
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
registration_id serial 10  √  nextval('registration_registration_id_seq'::regclass)
experiment.owner_id experiment__owner_fk R
file.owner_id fk_file_owner_id R
invoice.owner_id invoice_owner_id_fk R
ius.owner_id fk_ius_owner_id R
lane.owner_id lane_owner_id_fkey R
processing.owner_id fk_processing_owner_id R
sample.owner_id sample__owner_fk R
sequencer_run.owner_id sequencer_run_owner_id_fkey R
share_experiment.registration_id fk_share_experiment_registration_id R
share_file.registration_id fk_share_file_registration_id R
share_lane.registration_id fk_share_lane_registration_id R
share_processing.registration_id fk_share_processing_registration_id R
share_sample.registration_id fk_share_sample_registration_id R
share_study.registration_id fk_share_study_registration_id R
share_workflow_run.registration_id fk_share_workflow_run_registration_id R
study.owner_id study_owner_id_fkey R
workflow.owner_id fk_workflow_registration_id R
workflow_run.owner_id fk_workflow_run_registration_id R
email text 2147483647
password text 2147483647  √  null
password_hint text 2147483647  √  null
first_name text 2147483647
last_name text 2147483647
institution text 2147483647  √  null
invitation_code text 2147483647  √  null
lims_admin bool 1 false
create_tstmp timestamp 29,6
last_update_tstmp timestamp 29,6
developer_ml bool 1 false
user_ml bool 1 false
payee bool 1 false

Table contained 82 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
registration_id Primary key Asc registration_pkey
email Performance Asc email_registration
email Must be unique Asc registration_email_key

Close relationships  within of separation: