| Column Name |
SQL Data Type |
Explanation |
| ID |
BIGINT |
Correlates to an order ID. |
| TYPE |
CHAR(1) |
Indicates whether the item is a purchase (P) or a sale (S). |
| ACCOUNT_ID |
BIGINT |
Account number for trade. |
| TICKER |
CHAR(6) |
Ticker symbol of stock. |
| QTY |
INT |
Amount bought or sold. |
| PRICE |
MONEY |
Price of stock at time of trade. |
Table 1
Schemas Give Both Platforms a Meeting Place.
This example of a schema for a shared .NET-J2EE database uses a table simulating incoming orders for a stock-trading scenario. The database defines one table, ORDERTBL, with its schema properties shown here.
|