ERD

Tables (10)

Accounts

  • account_id — SERIAL
  • user_id — INT — NOT NULL
  • bank_name — VARCHAR(100) — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • balance — DECIMAL(15,2)
  • created_at — TIMESTAMP

Budgets

  • budget_id — SERIAL
  • user_id — INT — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • amount_limit — DECIMAL(15,2) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • created_at — TIMESTAMP

Community_Posts

  • post_id — SERIAL
  • user_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • post_type — VARCHAR(50)
  • price — DECIMAL(15,2)
  • deadline — DATE
  • created_at — TIMESTAMP

Fixed_Expenses

  • expense_id — SERIAL
  • user_id — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • frequency — VARCHAR(50)
  • next_due_date — DATE
  • created_at — TIMESTAMP

GroupBuy_Participants

  • participant_id — SERIAL
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • quantity — INT
  • status — VARCHAR(50)
  • created_at — TIMESTAMP

Incomes

  • income_id — SERIAL
  • user_id — INT — NOT NULL
  • source — VARCHAR(100) — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • received_date — DATE — NOT NULL
  • related_work_id — INT
  • created_at — TIMESTAMP

Messages

  • message_id — SERIAL
  • post_id — INT — NOT NULL
  • sender_id — INT — NOT NULL
  • receiver_id — INT — NOT NULL
  • message_text — TEXT — NOT NULL
  • sent_at — TIMESTAMP

Transactions

  • transaction_id — SERIAL
  • account_id — INT — NOT NULL
  • transaction_date — TIMESTAMP — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • transaction_type — VARCHAR(50)
  • merchant_name — VARCHAR(255)
  • memo — VARCHAR(255)
  • category — VARCHAR(100)
  • created_at — TIMESTAMP

Users

  • user_id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20)
  • university — VARCHAR(100)
  • created_at — TIMESTAMP

Work_Records

  • work_id — SERIAL
  • user_id — INT — NOT NULL
  • job_name — VARCHAR(100) — NOT NULL
  • hourly_wage — DECIMAL(10,2) — NOT NULL
  • work_date — DATE — NOT NULL
  • work_hours — DECIMAL(5,2) — NOT NULL
  • expected_payment_date — DATE
  • created_at — TIMESTAMP