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 |