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.