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