/*
Table: stockpurchases

Columns:
    card_no int
    stockPurchase dbms currency
    tdate datetime
    trans_num varchar
    dept int

Depends on:
    dlog (table)

Use:
This table equity related transaction info.
This table should be updated in conjunction with
any day-end polling system to copy appropriate
rows from dtransactions to stockpurchases
*/