cxgn_breedbase.sgn

TABLES 33

COLUMNS 221

Constraints 46

Anomalies 7

Routines 0

Database Properties

Database Type: PostgreSQL - 11.22 (Debian 11.22-0+deb10u2)

Tables

All Tables Views Comments

Search:

Table / View	Children	Parents	Columns	Rows	Type	Comments
bac_status	0	1	6	0	Table
bac_status_log	0	1	6	0	Table
clone_il_mapping_bin_log	0	3	8	0	Table	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	0	2	7	0	Table	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	0	2	7	0	Table	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	0	2	7	0	Table
forum_topic	1	1	9	0	Table
list	3	2	10	36	Table
list_dbxref	0	2	4	0	Table
list_item	0	1	3	1480	Table
listprop	0	2	5	0	Table
sp_clone_il_mapping_segment_log	0	3	6	0	Table	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_dataset	0	1	7	0	Table
sp_group	1	0	3	0	Table
sp_group_member	0	2	3	0	Table
sp_login_old	0	0	8	0	Table
sp_order	1	2	7	0	Table
sp_orderprop	0	2	5	0	Table
sp_organisms	1	0	2	0	Table
sp_organization	1	0	13	0	Table
sp_organization_person	0	1	3	0	Table
sp_papers	0	1	8	0	Table
sp_person	111	0	30	164	Table
sp_person_organisms	0	2	3	0	Table
sp_person_roles	0	2	3	234	Table
sp_project	3	0	3	0	Table
sp_project_il_mapping_clone_log	0	3	6	0	Table	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	0	3	0	Table
sp_project_person	0	2	4	0	Table
sp_roles	1	0	2	7	Table
sp_token	0	1	5	138	Table
user_map	1	3	13	0	Table
user_map_data	0	3	12	0	Table

Showing 1 to 33 of 33 entries