SECTOR The table contains information about market sectors. Table Prefix: SC_ Column Name Data Type Constraints Relations Description CHAR(2) Not Null PK Sector identifier. Sector name. Examples: “Energy”, SC_NAME CHAR(30) Not Null Care, “Materials”, “Industrials”, “Health etc. SECURITY This table contains information about each security traded on any of the exchanges. Table Prefix: S_ Column Name Data Type Constraints Relations Description Security symbol used to identify the S_SYMB CHAR(15) Not Null PK security on "ticker". Security type. Example: S_ISSUE CHAR(6) Not Null "COMMON", "PERF_A", "PERF_B", etc. Security status type identifier. S_ST_ID CHAR(4) Not Null FK (ST_) Identifies if this security is active or not. S_NAME CHAR(70) Not Null Security name. Exchange identifier of the exchange S_EX_ID CHAR(6) Not Null FK (EX_) the security is traded on. Company identifier of the company S_CO_ID IDENT_T Not Null FK (CO_) this security is issued by. Number of shares outstanding for this S_NUM_OUT S_COUNT_T Not Null security. S_START_DATE DATE Not Null Date security first started trading. Date security first started trading on S_EXCH_DATE DATE Not Null this exchange. Current share price to earnings per S_PE VALUE_T Not Null share ratio. S_52WK_HIGH S_PRICE_T Not Null Security share price 52-week high. Date of security share price 52-week S_52WK_HIGH_DATE DATE Not Null high. S_52WK_LOW S_PRICE_T Not Null Security share price 52-week low. Date of security share price 52-week S_52WK_LOW_DATE DATE Not Null low. Annual Dividend per share amount. S_DIVIDEND VALUE_T Not Null May be zero, is not allowed to be negative.
SECTOR The table contains information about market sectors. Table Prefix: SC_ Column Name Data Type Constraints Relations Description CHAR(2) Not Null PK Sector identifier. SC_NAME CHAR(30) Not Null Sector name. Examples: “Energy”, “Materials”, “Industrials”, “Health Care, etc. SECURITY This table contains information about each security traded on any of the exchanges. Table Prefix: S_ Column Name Data Type Constraints Relations Description S_SYMB CHAR(15) Not Null PK Security symbol used to identify the security on "ticker". S_ISSUE CHAR(6) Not Null Security type. Example: "COMMON", "PERF_A", "PERF_B", etc. S_ST_ID CHAR(4) Not Null FK (ST_) Security status type identifier. Identifies if this security is active or not. S_NAME CHAR(70) Not Null Security name. S_EX_ID CHAR(6) Not Null FK (EX_) Exchange identifier of the exchange the security is traded on. S_CO_ID IDENT_T Not Null FK (CO_) Company identifier of the company this security is issued by. S_NUM_OUT S_COUNT_T Not Null Number of shares outstanding for this security. S_START_DATE DATE Not Null Date security first started trading. S_EXCH_DATE DATE Not Null Date security first started trading on this exchange. S_PE VALUE_T Not Null Current share price to earnings per share ratio. S_52WK_HIGH S_PRICE_T Not Null Security share price 52-week high. S_52WK_HIGH_DATE DATE Not Null Date of security share price 52-week high. S_52WK_LOW S_PRICE_T Not Null Security share price 52-week low. S_52WK_LOW_DATE DATE Not Null Date of security share price 52-week low. S_DIVIDEND VALUE_T Not Null Annual Dividend per share amount. May be zero, is not allowed to be negative.
tpcx-v_v2.1.0.docx