GeneX Development Supported By
|
GeneX-2.0 DB: Sample Table
|
GeneX-2.0 DB: Sample Table
|
| Table Type | Inherits | Comment |
| DATA | Identifiable | The Sample table gives detailed information concerning the derivation of the DNA used to hybridize with an instance of an Array. |
| Column Information |
| Column Name | Full Name | Data Type | Not NULL | Comment |
| abrc_acc_num | ABRC Accession Number | char128 | false | |
| age | Age | int | false | |
| age_units | Age Units | char128 | false | controlled vocab |
| atcc_cell_type | ATCC Cell Type | char128 | false | controlled vocab |
| cell_line | Cell Line | char128 | false | |
| common_acc_num | Common Accession Number | char128 | false | |
| cultivar_name | Cultivar Name | char128 | false | |
| dev_stage_name | Development Stage Name | char128 | false | controlled vocab |
| dev_stage_time | Development Stage Time | datetime | false | |
| dev_stage_units | Development Stage Units | char128 | false | controlled vocab |
| genetic_status | Genetic Status | char128 | false | controlled vocab |
| genetic_status_comment | Genetic Status Comment | text | false | |
| genotype | Genotype | char128 | false | |
| growth_cond | Growth Condition | text | false | |
| nottingham_acc_num | Nottingham Accession Number | char128 | false | |
| organ_type | Organ Type | char128 | false | controlled vocab |
| organism_intactness | Organism Intactness | char128 | false | controlled vocab |
| pathology_descr | Pathology Description | text | false | |
| phenotype_name | Phenotype Name | char128 | false | |
| primary_cell_type | Primary Cell Type | char128 | false | controlled vocab |
| provider_con_fk | Data Provider | int | true | the supplier of the sample |
| seed_supplier_cat_num | Seed Supplier Catalog Number | char128 | false | |
| sex_mating_type | Sex/Mating Type | char128 | false | controlled vocab |
| smp_pk | Accession Number | serial | false | |
| spc_fk | Species | int | true | the species from which the sample was derived |
| strain | Strain | char128 | false | |
| tissue_type | Tissue Type | char128 | false | controlled vocab |
| variety | Variety | char128 | false | |
| Primary Key Information |
| Column Name |
| smp_pk |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| provider_con_fk | Contact | con_pk | MANY_TO_ONE |
| spc_fk | Species | spc_pk | MANY_TO_ONE |
| Unique Column Information |
| Column Names |
| provider_con_fk name |
| Index Information |
| Name | Column Name |
| provider_con_fk | sample_provider_con_fk |
| spc_fk | sample_spc_fk |
|