Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| SYMBOL | Char | 7 | | yes
|
| | yes
| |
| CO_NAME | Char | 20 | | yes
|
| |
| |
| EXCHANGE | Char | 8 | | yes
|
| |
| |
| CUR_PRICE | Float | 8 | | yes
|
| |
| |
| YRL_HIGH | Float | 8 | | yes
|
| |
| |
| YRL_LOW | Float | 8 | | yes
|
| |
| |
| P_E_RATIO | Float | 8 | | yes
|
| |
| |
| BETA | Float | 8 | | yes
|
| |
| |
| PROJ_GRTH | Float | 8 | | yes
|
| |
| |
| INDUSTRY | Int | 4 | | yes
|
| |
| |
| PRICE_CHG | Int | 4 | | yes
|
| |
| |
| SAFETY | Int | 4 | | yes
|
| |
| |
| RATING | Char | 4 | | yes
|
| |
| |
| RANK | Float | 8 | | yes
|
| |
| |
| OUTLOOK | Int | 4 | | yes
|
| |
| |
| RCMNDATION | Char | 5 | | yes
|
| |
| |
| RISK | Char | 4 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| GROWTHASC | index on master | PROJ_GRTH |
|
| SYMBOL | unique index on master | SYMBOL |
|
| GROWTHDESC | index on master | PROJ_GRTH |
|
Dependency graph
Sample rows
| SYMBOL | CO_NAME | EXCHANGE | CUR_PRICE | YRL_HIGH | YRL_LOW | P_E_RATIO | BETA | PROJ_GRTH | INDUSTRY | PRICE_CHG | SAFETY | RATING | RANK | OUTLOOK | RCMNDATION | RISK |
|---|
| SMC
| STAR MOTOR CORP
| NYSE
| 59.625
| 63.5
| 35.625
| 9.4
| 1.25
| -16
| 3710
| 39
| 3
| B
| 2
| 2
| BUY
| MED
|
| TC
| THORTON CORP
| NYSE
| 27.5
| 28
| 15.75
| 9.2
| 0.95
| 0
| 3720
| 18
| 3
| B
| 1
| 3
| BUY
| MED
|
| HS
| HOPE SYSTEMS
| NONE
| 29
| 37
| 16.25
| 22.3
| 1.6
| 3
| 3579
| 11
| 3
| A
| 3
| 2
| HOLD
| MED
|
| DHE
| DHE INT'L
| NYSE
| 8.625
| 9.375
| 5.25
| 13.3
| 1.3
| 4
| 3720
| 32
| 4
| B
| 3
| 2
| SELL
| HIGH
|
| HGJ
| HGJ CORPORATION
| NYSE
| 42.5
| 43
| 24.375
| 11.8
| 0.8
| 6
| 3720
| 5
| 3
| B
| 3
| 2
| SELL
| MED
|
| PIN
| PHONE INC
| NYSE
| 56.625
| 69.125
| 50.75
| 16
| 0.9
| 6
| 4810
| -4
| 2
| A
| 3
| 3
| SELL
| LOW
|
| TSM
| TUMI SYSTEMS
| NONE
| 55.625
| 61.375
| 20.625
| 30.7
| 1.4
| 8
| 3579
| 43
| 3
| B
| 1
| 3
| HOLD
| MED
|
| DS
| DYNAMIC SYSTEMS
| NONE
| 68.25
| 70.75
| 38.5
| 30.3
| 1.7
| 10
| 3573
| 27
| 3
| A
| 2
| 1
| SELL
| MED
|
| EC
| ENTERPRISE COMPUTER
| NYSE
| 81.125
| 82.5
| 41.75
| 14.7
| 1.45
| 11
| 3573
| 67
| 3
| A
| 2
| 1
| SELL
| MED
|
| NTEL
| NEW TEL
| NYSE
| 56.125
| 59.25
| 43.5
| 20
| 0.9
| 11
| 4810
| 14
| 1
| A
| 0
| 2
| SELL
| LOW
|
Code
CREATE TABLE [master]
(
[SYMBOL] CHAR (7) CODE PAGE 1252,
[CO_NAME] CHAR (20) CODE PAGE 1252,
[EXCHANGE] CHAR (8) CODE PAGE 1252,
[CUR_PRICE] FLOAT,
[YRL_HIGH] FLOAT,
[YRL_LOW] FLOAT,
[P_E_RATIO] FLOAT,
[BETA] FLOAT,
[PROJ_GRTH] FLOAT,
[INDUSTRY] INT,
[PRICE_CHG] INT,
[SAFETY] INT,
[RATING] CHAR (4) CODE PAGE 1252,
[RANK] FLOAT,
[OUTLOOK] INT,
[RCMNDATION] CHAR (5) CODE PAGE 1252,
[RISK] CHAR (4) CODE PAGE 1252,
CONSTRAINT [SYMBOL] UNIQUE ([SYMBOL])
);
CREATE INDEX [GROWTHASC] ON [master] ([PROJ_GRTH]);
CREATE INDEX [GROWTHDESC] ON [master] ([PROJ_GRTH]);