{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":46,"n_cols":9,"rows_kept":46,"merged":[[0,0,1,9],[3,0,3,2],[3,6,3,8],[11,0,11,2],[16,6,16,8],[18,0,18,2],[26,0,26,2],[27,6,27,8],[39,6,39,8],[44,1,44,2]]}
["Banking App ER diagramm"]
[]
[]
["login_details",{"$nulls":5},"user_info"]
["id","int",{"$nulls":4},"id","int"]
["user_id","varchar(20)","Unique code given to the user",{"$nulls":3},"user_id","varchar(20)","Unique code given to the user"]
["personal_code","char(12)","Unique code given by the user",{"$nulls":3},"personal_code","char(12)","Unique code given by the user"]
["login_time","DATETIME","Used to know when User/Client loged into the system",{"$nulls":3},"name","varchar(50)","Clients/users name"]
[{"$nulls":6},"surname","varchar(50)","Clients/users username"]
[{"$nulls":6},"email","var(50)","Clients/users email"]
[{"$nulls":6},"created_at","DATETIME","When the account was created"]
["login_history",{"$nulls":5},"updated_at","DATETIME","When were the last changes made"]
["id","int",{"$nulls":4},"is_active","TINYINT/Boolean","Shows if account is still active. 1 is Yes / 0 is No"]
["user_id","varchar(20)","Unique code given to the user"]
["login_time","DATETIME","Keeps record of each time user has logged in"]
[]
[{"$nulls":6},"user_accounts"]
[{"$nulls":6},"id","int"]
["currencies_info",{"$nulls":5},"account_id","int","Who is linked to the account"]
["id","int",{"$nulls":4},"user_id","varchar(20)","Which account they're linked to"]
["code","char(3)","Short name for the currency",{"$nulls":3},"role","varchar(20)","Their importance over the account"]
["name","varchar(50)","Full Currency name",{"$nulls":3},"status","enum","Whether the link is still active"]
["symbol","char(3)","Symbol for the currency",{"$nulls":3},"created_at","DATETIME","When was the link started"]
[{"$nulls":6},"updated_at","DATETIME","When was last updated at"]
[]
[]
["transaction_details"]
["id","int",{"$nulls":4},"accounts"]
["user_id","varchar(20)","Identifies which user started the transaction",{"$nulls":3},"id","int"]
["sender_account_id","int","Shows from which account the funds were sent",{"$nulls":3},"account_number","char(10)","Unique code given to Clients/users account"]
["receiver_account_id","int","Shows to which account were sent to",{"$nulls":3},"account_type","enum","Whether the account is Main, savings or any other type of account"]
["amount","decimal(12,2)","Shows the transfered funds amount",{"$nulls":3},"balance","decimal(12,2)","Account current balance"]
["currency_id","int","The transfered fund currency",{"$nulls":3},"currency_id","int","Shows the account current currency"]
["exchange_rate_id","int","Show the exchange rate between sent funds",{"$nulls":3},"status","enum","Shows whether the account is still open or closed"]
["converted_amount","decimal(12,2)","Shows the amount sent after currency exchange",{"$nulls":3},"created_at","DATETIME","Time when the account was created at"]
["transaction_type","enum","Shows whether the funds were sent to another account or another user",{"$nulls":3},"closed_at","DATETIME","Shows when the account was closed"]
["status","enum","Shows the transaction current progress"]
["initiated_at","DATETIME","Shows when the transfer was started"]
["completed_at","DATETIME","Shows if the transfer was completed and when"]
["reference_code","varchar(20)","Unique code to easier identify transfer.",{"$nulls":3},"exchange_rates"]
["description","text","Users added text/message",{"$nulls":3},"id","int"]
[{"$nulls":6},"currency_from","char(3)","Which currency is changed"]
[{"$nulls":6},"currency_to","char(3)","To which currency is changed"]
[{"$nulls":6},"rate","decimal(10,6)","What is the rate between the currencies"]
[null,"Example to User_id",{"$nulls":4},"updated_at","DATETIME","When were the last changes made"]
[null,"LVU291529_2124 "," Latvia User + timestamp/random"]