bank.db•57.3 kB
SQLite format 3 @ � q � .�
� p
=
� � s � 1
Z d�,� �!
W7�Aindexix_derivativetransaction_customer_oidderivativetransactionCREATE INDEX ix_derivativetransaction_customer_oid ON derivativetransaction (customer_oid)�: 77�tablederivativetransactionderivativetransaction
CREATE TABLE derivativetransaction (
id INTEGER NOT NULL,
customer_oid VARCHAR NOT NULL,
type VARCHAR NOT NULL,
side VARCHAR NOT NULL,
asset VARCHAR NOT NULL,
strike_price FLOAT NOT NULL,
premium FLOAT NOT NULL,
expiration_date VARCHAR NOT NULL,
execution_date VARCHAR NOT NULL,
strategy VARCHAR,
status VARCHAR NOT NULL,
counterparty VARCHAR,
PRIMARY KEY (id)
)y C#�indexix_bankaccount_customer_oidbankaccount CREATE INDEX ix_bankaccount_customer_oid ON bankaccount (customer_oid)�s
##�-tablebankaccountbankaccount CREATE TABLE bankaccount (
id INTEGER NOT NULL,
customer_oid VARCHAR NOT NULL,
institution_id INTEGER NOT NULL,
balance FLOAT NOT NULL,
currency VARCHAR NOT NULL,
iban VARCHAR,
PRIMARY KEY (id)
)�T ##�otableinstitutioninstitution
CREATE TABLE institution (
id INTEGER NOT NULL,
name VARCHAR NOT NULL,
type VARCHAR NOT NULL,
contact_info VARCHAR,
internal_code VARCHAR NOT NULL,
PRIMARY KEY (id)
)m= �
indexix_spending_customer_oidspending CREATE INDEX ix_spending_customer_oid ON spending (customer_oid)�P �stablespendingspendingCREATE TABLE spending (
id INTEGER NOT NULL,
customer_oid VARCHAR NOT NULL,
category VARCHAR NOT NULL,
amount FLOAT NOT NULL,
month VARCHAR NOT NULL,
PRIMARY KEY (id)
){C#� indexix_transaction_customer_oidtransactionCREATE INDEX ix_transaction_customer_oid ON "transaction" (customer_oid)�g##�tabletransactiontransactionCREATE TABLE "transaction" (
id INTEGER NOT NULL,
customer_oid VARCHAR NOT NULL,
date VARCHAR NOT NULL,
type VARCHAR NOT NULL,
asset VARCHAR,
amount FLOAT NOT NULL,
PRIMARY KEY (id)
)a7�indexix_asset_customer_oidassetCREATE INDEX ix_asset_customer_oid ON asset (customer_oid)�J�stableassetassetCREATE TABLE asset (
id INTEGER NOT NULL,
customer_oid VARCHAR NOT NULL,
asset_type VARCHAR NOT NULL,
symbol VARCHAR NOT NULL,
amount FLOAT NOT NULL,
PRIMARY KEY (id)
)d5� indexix_user_customer_oiduserCREATE UNIQUE INDEX ix_user_customer_oid ON user (customer_oid)�
�}tableuseruserCREATE TABLE user (
id INTEGER NOT NULL,
customer_oid VARCHAR NOT NULL,
name VARCHAR NOT NULL,
PRIMARY KEY (id)
)
� ��b)��� 2 U!eefd2cb8-e4c0-4177-9650-113c66af0b1aJane Smith0 U 63c98b6c-b81f-4a5a-9c83-db5710f87295John Doe4 U%550e8400-e29b-41d4-a716-446655440005Michael Chen7 U+550e8400-e29b-41d4-a716-446655440004ABC Corporation6 U)550e8400-e29b-41d4-a716-446655440003Robert Johnson2 U!550e8400-e29b-41d4-a716-446655440002Jane Smith0 U 550e8400-e29b-41d4-a716-446655440001John Doe
� ���]4 � (Ueefd2cb8-e4c0-4177-9650-113c66af0b1a(U63c98b6c-b81f-4a5a-9c83-db5710f87295(U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440002'U 550e8400-e29b-41d4-a716-446655440001
� ��\ ��~H
�
�
i
6
� � V " � � � 2 U550e8400-e29b-41d4-a716-446655440005etfVTI,4 U550e8400-e29b-41d4-a716-446655440005cryptoETH
4 U550e8400-e29b-41d4-a716-446655440005stockAMZN2 U550e8400-e29b-41d4-a716-446655440004etfQQQ�; U!550e8400-e29b-41d4-a716-446655440004bondCORP_BONDS��5 U550e8400-e29b-41d4-a716-446655440004stockMSFT 5 U550e8400-e29b-41d4-a716-446655440004stockAAPL�3 U550e8400-e29b-41d4-a716-446655440003stockJNJ<1
U550e8400-e29b-41d4-a716-446655440003etfSPYd: U!550e8400-e29b-41d4-a716-446655440003bondCORP_BONDS:�5 U550e8400-e29b-41d4-a716-446655440003bondUS10YN 4
U550e8400-e29b-41d4-a716-446655440002stockMSFTP4 U550e8400-e29b-41d4-a716-446655440002cryptoETH4 U550e8400-e29b-41d4-a716-446655440002cryptoBTC4 U550e8400-e29b-41d4-a716-446655440002stockNVDAK5 U550e8400-e29b-41d4-a716-446655440002stockTSLA �2 U550e8400-e29b-41d4-a716-446655440001etfSPY �; U550e8400-e29b-41d4-a716-446655440001cryptoBTC@ 5 U550e8400-e29b-41d4-a716-446655440001bondUS10Y'5 U550e8400-e29b-41d4-a716-446655440001stockGOOGL24 U550e8400-e29b-41d4-a716-446655440001stockAAPLd
� ���]4 ���g>
�
�
�
q
H
� � � (U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440003
(U550e8400-e29b-41d4-a716-446655440003 (U550e8400-e29b-41d4-a716-446655440003 (U550e8400-e29b-41d4-a716-446655440002
(U550e8400-e29b-41d4-a716-446655440002 (U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001'U 550e8400-e29b-41d4-a716-446655440001
e �<��x8
�
�
z
9 � � s / � � i $
�
�
e = U!550e8400-e29b-41d4-a716-4466554400052025-05-10buyVTI�h= U!550e8400-e29b-41d4-a716-4466554400052025-03-20buyETH�X? U!550e8400-e29b-41d4-a716-4466554400052025-01-25buyAMZN�wHC U! 550e8400-e29b-41d4-a716-4466554400042025-04-15dividendAAPL �B U!550e8400-e29b-41d4-a716-4466554400042025-03-01depositUSD
@? U!550e8400-e29b-41d4-a716-4466554400042025-02-10buyMSFT�+@? U!550e8400-e29b-41d4-a716-4466554400042025-01-05buyAAPL��B U! 550e8400-e29b-41d4-a716-4466554400032025-04-20dividendJNJ �= U!550e8400-e29b-41d4-a716-4466554400032025-03-15buySPY�xD
U!!550e8400-e29b-41d4-a716-4466554400032025-02-25buyCORP_BONDS�h? U!550e8400-e29b-41d4-a716-4466554400032025-01-10buyUS10Y��? U!550e8400-e29b-41d4-a716-4466554400022025-05-20sellTSLA @=
U!550e8400-e29b-41d4-a716-4466554400022025-04-10buyETH�h= U!550e8400-e29b-41d4-a716-4466554400022025-03-05buyBTC��> U!550e8400-e29b-41d4-a716-4466554400022025-02-15buyNVDA��> U!550e8400-e29b-41d4-a716-4466554400022025-01-20buyTSLA�XB U! 550e8400-e29b-41d4-a716-4466554400012025-06-01dividendSPY �? U!550e8400-e29b-41d4-a716-4466554400012025-05-15sellAAPL �= U!550e8400-e29b-41d4-a716-4466554400012025-04-05buyBTC� A U!550e8400-e29b-41d4-a716-4466554400012025-03-10depositUSDa�? U!550e8400-e29b-41d4-a716-4466554400012025-02-20buyGOOGL��> U!550e8400-e29b-41d4-a716-4466554400012025-01-15buyAAPL�h
{ ���]4 ���g>
�
�
�
q
H
� � � { (U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440003
(U550e8400-e29b-41d4-a716-446655440003 (U550e8400-e29b-41d4-a716-446655440002 (U550e8400-e29b-41d4-a716-446655440002
(U550e8400-e29b-41d4-a716-446655440002 (U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001'U 550e8400-e29b-41d4-a716-446655440001
( ��B��I
�
�
S
� � \ � � ]
�
�
_
! � � f ( < U 550e8400-e29b-41d4-a716-446655440005utilities^2025-02< U 550e8400-e29b-41d4-a716-446655440005groceriesR2025-029 U550e8400-e29b-41d4-a716-446655440005travel�2025-01@ U'550e8400-e29b-41d4-a716-446655440005entertainmentX2025-01< U 550e8400-e29b-41d4-a716-446655440005groceries�2025-01< U 550e8400-e29b-41d4-a716-446655440004utilities L2025-02B U+550e8400-e29b-41d4-a716-446655440004office_supplies�2025-02< U 550e8400-e29b-41d4-a716-446655440004marketing:�2025-01< U 550e8400-e29b-41d4-a716-446655440004utilities @2025-01B U+550e8400-e29b-41d4-a716-446655440004office_supplies�2025-01< U 550e8400-e29b-41d4-a716-446655440003utilities �2025-02< U 550e8400-e29b-41d4-a716-446655440003groceriesD2025-02= U!550e8400-e29b-41d4-a716-446655440003healthcare,2025-01< U 550e8400-e29b-41d4-a716-446655440003utilities �2025-01< U 550e8400-e29b-41d4-a716-446655440003groceriesX2025-01<
U 550e8400-e29b-41d4-a716-446655440002utilities�2025-02; U 550e8400-e29b-41d4-a716-446655440002shopping�2025-02@ U'550e8400-e29b-41d4-a716-446655440002entertainment�2025-019
U550e8400-e29b-41d4-a716-446655440002travel �2025-019 U550e8400-e29b-41d4-a716-446655440002dining 2025-01< U 550e8400-e29b-41d4-a716-446655440002groceries�2025-01= U!550e8400-e29b-41d4-a716-446655440001healthcare �2025-02< U 550e8400-e29b-41d4-a716-446655440001utilities2025-02< U 550e8400-e29b-41d4-a716-446655440001groceries�2025-02< U 550e8400-e29b-41d4-a716-446655440001transport�2025-01@ U'550e8400-e29b-41d4-a716-446655440001entertainment�2025-01< U 550e8400-e29b-41d4-a716-446655440001utilities,2025-01< U 550e8400-e29b-41d4-a716-446655440001groceries 2025-01
� ���]4 ���g>
�
�
�
q
H
� � � { R ) � � � (U550e8400-e29b-41d4-a716-446655440005 (U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440002
(U550e8400-e29b-41d4-a716-446655440002 (U550e8400-e29b-41d4-a716-446655440002 (U550e8400-e29b-41d4-a716-446655440002
(U550e8400-e29b-41d4-a716-446655440002 (U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001(U550e8400-e29b-41d4-a716-446655440001'U 550e8400-e29b-41d4-a716-446655440001
a ��a 3 + /Crypto Exchangeexchangehelp@cryptoex.comCE0016 +9Investment Corpbrokersupport@investcorp.comIC0010 #9Global Bankbankcontact@globalbank.comGB001
�w2��b D U1550e8400-e29b-41d4-a716-446655440005LUSDUS6789012345678901D U1550e8400-e29b-41d4-a716-446655440004� USDUS5678901234567890B U 1550e8400-e29b-41d4-a716-446655440003u0USDUS4567890123456789D U1550e8400-e29b-41d4-a716-446655440002��USDUS3456789012345678C U 1550e8400-e29b-41d4-a716-446655440002$�USDUS2345678901234567B U 1550e8400-e29b-41d4-a716-446655440001a�EURDE9876543210987654C U 1550e8400-e29b-41d4-a716-446655440001 �PUSDUS1234567890123456
� ���]4 � (U550e8400-e29b-41d4-a716-446655440005(U550e8400-e29b-41d4-a716-446655440004(U550e8400-e29b-41d4-a716-446655440003(U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440001'U 550e8400-e29b-41d4-a716-446655440001
L �"�L g
U!! 550e8400-e29b-41d4-a716-446655440002futurebuyGOLD4�2025-10-152025-04-15hedgeopenEXCHANGEk
U!! 550e8400-e29b-41d4-a716-446655440002optionbuyTSLA ��2025-11-152025-05-15long_callopenEXCHANGEp
U!!-550e8400-e29b-41d4-a716-446655440001optionsellSPY�,2025-09-152025-06-15cash_secured_putopenBROKERj
U!!%550e8400-e29b-41d4-a716-446655440001optionbuyAAPL ��2025-12-152025-07-15covered_callopenBANK
] ���]
(U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440002(U550e8400-e29b-41d4-a716-446655440001'U 550e8400-e29b-41d4-a716-446655440001