miniproject
Tables (5)
Analysis (Untitled5)
- User id (user_id) — UUID — Foreign key → USER.User id — NOT NULL
- Target Type (target_type) — VARCHAR(20)
- Period Type (period_type) — VARCHAR(20)
- Description (description) — VARCHAR(255)
- Result Image (result_image) — VARCHAR(255)
- Start Date (start_date) — DATE
- End Date (end_date) — DATE
- Created At (created_at) — DATETIME
- Updated At (updated_at) — DATETIME
BANK_ACCOUNT (Untitled2)
- Account id (account_id) — UUID — Primary key — NOT NULL
- User id (user_id) — UUID — Foreign key → USER.User id — NOT NULL
- Bank name (bank_name) — VARCHAR(50)
- Bank Code (bank_code) — VARCHAR(20)
- Balance (balance) — DECIMAL
NOTIFICAION (Untitled3)
- User id (user_id) — UUID — Foreign key → USER.User id — NOT NULL
- Notification Type (notification_type) — VARCHAR(10)
- Message (message) — VARCHAR(255)
- is Read (is_read) — BOOLEAN
- Created_at (created_at) — DATETIME
TRANSACTION (Untitled4)
- Transaction id (transaction_id) — UUID — Primary key — NOT NULL
- Account id (account_id2) — UUID — Foreign key → BANK_ACCOUNT.Account id — NOT NULL
- User id (user_id) — UUID — Foreign key → BANK_ACCOUNT.User id — NOT NULL
- Amount (amount) — DECIMAL
- Transaction Type (transaction_type) — VARCHAR(10)
- Transaction Date (transaction_date) — DATETIME
USER (Untitled)
- User id (user_id) — UUID — Primary key — NOT NULL
- Email (email) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- Nick Name (nick_name) — VARCHAR(50)
- Phone (phone) — VARCHAR(20)
- is Staff (is_staff) — BOOLEAN
- is Admin (is_admin) — BOOLEAN
- is Active (is_active) — BOOLEAN