cj-back
Tables (3)
Accounts (account)
- Account id (account_id) — UUID — Primary key — NOT NULL
- User id (user_id) — UUID — Foreign key → User.User id — NOT NULL
- Account Number (account_number) — VARCHAR(20)
- Bank Code (bank_code) — VARCHAR(10)
- Account Type (account_type) — VARCHAR(30)
- Balance (balance) — DECIMAL(18,2)
- Create At (create_at) — DATETIME
- Update At (update_at) — DATETIME
Transaction History (transaction history)
- Transaction id (transaction_id) — UUID — Primary key — NOT NULL
- Account id (account_id) — UUID — Foreign key → Accounts.Account id — NOT NULL
- Transaction Amount (transactio_ amount) — DECIMAL(18,2)
- Post Transaction Amount (post_transaction_amount) — DECIMAL(18,2)
- Description (description) — VARCHAR(255)
- Transaction Details (transaction_details) — VARCHAR(255)
- Transaction Type (transaction_type) — VARCHAR(10)
- Transaction Method (transaction_method) — VARCHAR(20)
- Transaction Timestamp (transaction_timestamp) — TIMESTAMP
User (user)
- User id (user_id) — UUID — Primary key — NOT NULL
- Email (email) — VARCHAR(255)
- Passoword (password) — VARCHAR(255)
- Nickname (nickname) — VARCHAR(50)
- Name (name) — VARCHAR(50)
- Phone Number (phone_number) — VARCHAR(20)
- Last Login (last_login) — TIMESTAMP
- Is Staff (is_staff) — BOOLEAM
- Is Admin (is_admin) — BOOLEAN
- Is Active (is_active) — BOOLEAN
- Create At (craete_at) — DATETIME
- Update At (update_at) — DATETIME