가계부

테이블 (5)

Accounts (account)

  • Account id (account_id) — AUTO_INCREMENT — 기본 키 — NOT NULL
  • User ID (user_id) — AUTO_INCREMENT — 외래 키 → Users.User ID — NOT NULL
  • Account Number (account_number) — VARCHAR(20)
  • Bank Code (bank_code) — VARCHAR(10)
  • Account Type (account_type) — VARCHAR(20)
  • Balance (balance) — DECIMAL(18, 2)

Analysis (analysis)

  • Analysis id (analysis_id) — AUTO_INCREMENT — 기본 키 — NOT NULL
  • User ID (user_id) — AUTO_INCREMENT — 외래 키 → Users.User ID — NOT NULL
  • Analysis Target (analysis_target) — VARCHAR(10)
  • Analysis Period (analysis_period) — VARCHAR(20)
  • Start Date (start_date) — DATE
  • End Date (end_date) — DATE
  • Description (description) — TEXT
  • Created At (created_at) — TIMESTAMP
  • Updated At (updated_at) — TIMESTAMP
  • Image (image) — VARCHAR(255)

Notifications (notifications)

  • Notifications id (notifications_id) — AUTO_INCREMENT — 기본 키 — NOT NULL
  • User ID (user_id) — AUTO_INCREMENT — 외래 키 → Users.User ID — NOT NULL
  • Message (message) — TEXT
  • Is Read (is_read) — BOOLEAN
  • Created At (created_at) — TIMESTAMP

Transaction History (transaction_history)

  • Transaction id (transaction_id) — AUTO_INCREMENT — 기본 키
  • Account id (account_id) — AUTO_INCREMENT — 외래 키 → Accounts.Account id — NOT NULL
  • Transaction Amount (transaction_amount) — DECIMAL(18, 2) — NOT NULL
  • Post Transaction Balance (post_transaction_balance) — DECIMAL(18, 2)
  • Transaction Details (transaction_details) — VARCHAR(100)
  • Transaction Type (transaction_type) — VARCHAR(10)
  • Transaction Method (transaction_method) — VARCHAR(10)
  • Transaction Date (transaction_date) — TIMESTAMP

Users (users)

  • User ID (user_id) — AUTO_INCREMENT — 기본 키 — NOT NULL
  • Email (email) — VARCHAR(100)
  • Password (password) — VARCHAR(20)
  • Name (name) — VARCHAR(50)
  • Nickname (nickname) — VARCHAR(50)
  • Phone Number (phone_number) — VARCHAR(20)
  • Last Login (last_login) — TIMESTAMP
  • Is Staff (is_staff) — BOOLEAN
  • Is Admin (is_admin) — BOOLEAN
  • Is Active (is_active) — BOOLEAN