test
Tables (6)
branch_budgets
- branch_budget_id — BIGSERIAL — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → projects.project_id
- branch_id — VARCHAR(10) — Foreign key → branches.branch_id
- allocated_krw — NUMERIC(15,2) — NOT NULL
- snapshot_rate — NUMERIC(10,4) — NOT NULL
- baseline_local — NUMERIC(15,2) — NOT NULL
branches
- branch_id — VARCHAR(10) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- currency_code — VARCHAR(3) — NOT NULL
- timezone — VARCHAR(50) — NOT NULL
categories
- category_id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
expenses
- expense_id — BIGSERIAL — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → projects.project_id
- branch_id — VARCHAR(10) — Foreign key → branches.branch_id
- user_id — BIGINT — Foreign key → users.user_id
- category_id — BIGINT — Foreign key → categories.category_id
- local_amount — NUMERIC(15,2) — NOT NULL
- currency_code — VARCHAR(3) — NOT NULL
- tax_amount — NUMERIC(15,2)
- transaction_date — DATE — NOT NULL
- snapshot_rate — NUMERIC(10,4) — NOT NULL
- krw_amount — NUMERIC(15,2) — NOT NULL
- status — VARCHAR(20)
- receipt_file_path — VARCHAR(255)
projects
- project_id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- status — VARCHAR(20)
users
- user_id — BIGSERIAL — Primary key — NOT NULL
- branch_id — VARCHAR(10) — Foreign key → branches.branch_id
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — VARCHAR(20) — NOT NULL