Wells Far-Go
Tables (10)
Account (accounts)
- Number (account_number) — string — Primary key — NOT NULL
- CustomerID (cid) — string — Foreign key → Customer.ID — NOT NULL
- Type (type) — tinyint
- Status (acccount_status) — tinyint
- Name (name) — string
- Balance (balance) — float
- Status (status) — tinyint
- OpenedAt (opened_at) — bigint
- DeletedAt (deleted_at) — bigint
AccountHolder (Untitled)
- AccountNumber (Field)
- BankNumber (Field2)
Address (addresses)
- ID (aid) — int — Primary key — NOT NULL
- Number (account_number) — string — Foreign key → Account.Number — NOT NULL
- CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
- Type (type) — tinyint
- State (state) — string
- City (city) — string
- Street (street) — string
- ZipCode (zip_code) — int
- Country (country) — string
Bank (banks)
- BankCode (bank_code) — string — Primary key — NOT NULL
- Name (bank_name) — string
- Address (bank_address) — string
Branch (branches)
- ID (bid) — int — Primary key — NOT NULL
- BankCode (bank_code) — string — Foreign key → Bank.BankCode — NOT NULL
- Name (name) — string
- Location (location) — string
Customer (customers)
- ID (cid) — string — Primary key — NOT NULL
- Password (password) — string
- Status (status) — tinyint
- FirstName (first_name) — string
- MiddleNanme (middle_name) — string
- LastName (last_name) — string
- Gender (gender) — tinyint
- Salary (salary) — float
- CountryCode (country_code) — int
- Phone (phone) — string
- Email (email) — string
- DOB (date_of_birth) — string
- RegisteredDate (registered_date) — bigint
- UpdatedAt (updated_at) — bigint
- DeletedAt (deleted_at) — bigint
Deposit (deposits)
- AccountNumber (account_number) — string — Foreign key → Account.Number — NOT NULL
- CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
- Date (date) — bigint
- Amount (amount) — float
Transaction (transactions)
- ID (tid) — uuid — Primary key — NOT NULL
- AccountNumber (account_number) — string — Foreign key → Account.Number — NOT NULL
- CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
- Type (type) — string
- Status (status) — string
- Amount (transfer_amount) — float
- TransferDate (transfer_date) — bigint
- From (from) — string
- To (to) — string
- Description (description) — string
Withdraw (withdraws)
- AccountNumber (account_number) — string — Foreign key → Account.Number — NOT NULL
- CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
- Date (date) — bigint
- Amount (amount) — float