SchemaSpy Analysis of cxgn.metadata - Columns |
Generated by SchemaSpy |
| Generated by SchemaSpy on Fri Oct 10 01:30 EDT 2008 |
| ||||||
cxgn.metadata contains 17 columns:
| Column | Table | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| attribution_id | attribution | bigserial | 19 | √ | nextval('attribution_attribution_id_seq'::regclass) |
|
|||||
| attribution_id | attribution_to | int8 | 19 | √ | null |
|
|||||
| attribution_id | comments | int8 | 19 | √ | null | ||||||
| attribution_to_id | attribution_to | bigserial | 19 | √ | nextval('attribution_to_attribution_to_id_seq'::regclass) | ||||||
| comment_id | comments | bigserial | 19 | √ | nextval('comments_comment_id_seq'::regclass) | ||||||
| comment_text | comments | varchar | 255 | √ | null | ||||||
| database_name | attribution | varchar | 255 | √ | null | ||||||
| organization_id | attribution_to | int8 | 19 | √ | null | ||||||
| person_id | attribution_to | int8 | 19 | √ | null | ||||||
| primary_key_column_name | attribution | varchar | 255 | √ | null | ||||||
| project_id | attribution_to | int8 | 19 | √ | null | ||||||
| role_description | roles | varchar | 255 | √ | null | ||||||
| role_id | attribution_to | int8 | 19 | √ | null |
|
|||||
| role_id | roles | bigserial | 19 | √ | nextval('roles_role_id_seq'::regclass) |
|
|||||
| role_name | roles | varchar | 255 | √ | null | ||||||
| row_id | attribution | int8 | 19 | √ | null | ||||||
| table_name | attribution | varchar | 255 | √ | null |