SchemaSpy Analysis of cxgn.sgn_people |
Generated by SchemaSpy |
Generated by SchemaSpy on Wed May 20 02:02 EDT 2009 | |
Database Type: PostgreSQL - 8.1.11 |
Please support this project |
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
25 Tables:
Total rows: 11,088
Table | Children | Parents | Rows | Comments |
---|---|---|---|---|
bac_status | 1 | 1,448 | ||
bac_status_log | 1 | 3,918 | ||
clone_il_mapping_bin_log | 1 | 364 | linking table showing which phenome.genotype_region a given clone has been mapped to. also provides a modification history with its is_current and created columns | |
clone_validation_log | 1 | 0 | table showing which clones have been validated by a variety of methods. columns may be added to this without warning. details about each validation experiment should be written into the comment field on the detail page for the clone | |
clone_verification_log | 1 | 379 | table showing which clones have been validated by a variety of methods. columns may be added to this without warning. details about each validation experiment should be written into the comment field on the detail page for the clone | |
forum_post | 2 | 155 | ||
forum_topic | 1 | 1 | 113 | |
list | 1 | 1 | 0 | |
list_item | 1 | 0 | ||
sp_clone_il_mapping_segment_log | 1 | 8 | linking table showing which phenome.individual IL line a given clone has been mapped to. also provides a modification history with is_current and created columns | |
sp_group | 1 | 4 | ||
sp_group_member | 2 | 483 | ||
sp_login_old | 393 | |||
sp_organisms | 63 | |||
sp_organization | 29 | |||
sp_organization_person | 1 | 0 | ||
sp_papers | 1 | 0 | ||
sp_person | 17 | 1,027 | ||
sp_person_organisms | 1 | 434 | ||
sp_project | 2 | 13 | ||
sp_project_il_mapping_clone_log | 2 | 2,199 | linking table showing which sp_project is currently assigned to map a given clone to the zamir IL lines. also provides a modification history with is_current and created columns | |
sp_project_organization | 0 | |||
sp_project_person | 2 | 40 | ||
user_map | 1 | 1 | 2 | |
user_map_data | 2 | 16 |