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