Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
symbol | text | 2147483647 | null |
|
|
|||||||||||||||
name | text | 2147483647 | null |
|
|
|||||||||||||||
description | text | 2147483647 | null |
|
|
|||||||||||||||
_text | 2147483647 | √ | null |
|
|
|||||||||||||||
similar_tickers | _text | 2147483647 | √ | null |
|
|
||||||||||||||
industry | text | 2147483647 | √ | null |
|
|
||||||||||||||
sector | text | 2147483647 | √ | null |
|
|
||||||||||||||
exchange | text | 2147483647 | √ | null |
|
|
||||||||||||||
short_ratio | float8 | 17,17 | √ | null |
|
|
||||||||||||||
create_tstamp | timestamp | 29,6 | √ | CURRENT_TIMESTAMP |
|
|
||||||||||||||
modify_tstamp | timestamp | 29,6 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
ticker_data_pkey | Primary key | Asc | symbol |
ticker_data_industry_idx | Performance | Asc | industry |
ticker_data_sector_idx | Performance | Asc | sector |
ticker_data_similar_tickers_idx | Performance | Asc | similar_tickers |
ticker_data_tags_idx | Performance | Asc | tags |