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