DBD and DB-Schema Changes

Database tables and fields are defined in .dbd and .db-schema file. For example, MmsData.dbd.

Changes in .dbd and .db-schema files included in this document begin with TP4 v19.0.1.0 and TP6 v19.0.2.0.

Run DBEdit to update your database with the latest changes.

Version Type Description ID
TP4 19.0.1.0

TP6 19.0.2.0

ENH Changes have been made to MmsData.dbd.

Changes will allow a transport unit purchase to have a transaction status.

The following field is removed from the PassCardTransDetail table:
Field Name
TransactionStatus
Data Type
UTinyInt
Description
Hard coded flag to identify the state of the transaction (0 = Pending, 1 = Active, 2 = Cancelled, 3 = Cannot Process).
Allow Nulls?
N/A

The following field is added to the PassFinancialTransaction table:

Field Name
TransactionStatus
Data Type
UTinyInt
Description
Hard coded flag to identify the state of the transaction (0 = Pending, 1 = Active, 2 = Cancelled, 3 = Cannot Process)
Allow Nulls?
Yes
PASS-15281