GoBank
Tables (6)
Account (accounts)
- Number (account_number) — string — Primary key — NOT NULL
- CustomerID (cid) — string — Foreign key → Customer.Key — NOT NULL
- Type (type) — tinyint
- Status (account_status) — tinyint
- Name (name) — string
- Balance (balance) — float
- OpenedAt (opened_at) — bigint
- DeletedAt (deleted_at) — bigint
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
- ZipCodez (zip_code) — int
- Country (country) — string
Customer (customers)
- Key (cid) — string — Primary key — NOT NULL
- Password (pasword) — string
- Status (status) — tinyint
- FirstName (first_name) — string
- MiddleName (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 (deletedAt) — bigint
Deposit (deposits)
- Number (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
- Number (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)
- Number (account_number) — string — Foreign key → Account.Number — NOT NULL
- CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
- Date (date) — bigint
- Amount (amount) — float