Conditions:
WHEN tdn_trans_cancel_id IS 0
THEN tdn_signature IS OWNED BY tdn_cert

GET BALANCE FOR certificate:
BALANCE IS SUM (tdn_dollar_value) WHERE tdn_cert IS certificate

WHEN tdn_trans_cancel_id = 0 tdn_status MUST BE 1
WHEN tdn_trans_cancel_id NOT 0 tdn_status MUST BE 2

TDN Ownership Transfer
WHEN ONLY ONE RECORD HAS tdn_trans_cancel_id EQUALS n AND tdn_cert IS X
AND ONLY ONE RECORD HAS tdn_trans_create_id EQUALS n AND tdn_cert IS Y AND tdn_value IS $v
X TRANSFERED $v TO Y

Next

Prev