| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| allele_id |
serial |
10 |
|
√ |
nextval('allele_allele_id_seq'::regclass) |
|
|
| locus_id |
int4 |
10 |
√ |
|
null |
|
| locus.locus_id
|
allele_locus_id_fkey |
|
| allele_symbol |
varchar |
32 |
√ |
|
null |
|
|
| allele_name |
varchar |
255 |
√ |
|
null |
|
|
| mode_of_inheritance |
varchar |
18 |
√ |
|
null |
|
|
| allele_synonym |
_varchar |
2147483647 |
√ |
|
null |
|
|
| allele_phenotype |
text |
2147483647 |
√ |
|
null |
|
|
| allele_notes |
text |
2147483647 |
√ |
|
null |
|
|
| obsolete |
bool |
1 |
√ |
|
false |
|
|
| sp_person_id |
int4 |
10 |
√ |
|
null |
|
|
| create_date |
timestamptz |
35,6 |
√ |
|
now() |
|
|
| modified_date |
timestamptz |
35,6 |
√ |
|
null |
|
|
| updated_by |
int4 |
10 |
√ |
|
null |
|
|
| is_default |
bool |
1 |
√ |
|
true |
|
|
| sequence |
text |
2147483647 |
√ |
|
null |
|
|
Table contained 7,052 rows at Wed May 20 01:35 EDT 2009
|
