fullstack

Tables (17)

approval_action_log

  • approval_action_id — BIGINT
  • approval_id — BIGINT — NOT NULL
  • actor_id — BIGINT
  • action — VARCHAR(30) — NOT NULL
  • message — TEXT
  • created_at — TIMESTAMP — NOT NULL

approval_request

  • approval_id — BIGINT
  • expense_id — BIGINT — NOT NULL
  • requester_id — BIGINT
  • approver_id — BIGINT
  • request_type — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • requested_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

cart

  • cart_id — BIGINT
  • user_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

cart_item

  • cart_item_id — BIGINT
  • cart_id — BIGINT — NOT NULL
  • store_item_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

expense

  • expense_id — BIGINT
  • user_id — BIGINT
  • expense_date — DATE — NOT NULL
  • merchant_name — VARCHAR(150) — NOT NULL
  • amount — INT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • payment_method — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • request_note — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

receipt_ai_extraction

  • extraction_id — BIGINT
  • receipt_upload_id — BIGINT — NOT NULL
  • model_name — VARCHAR(50) — NOT NULL
  • extracted_json — JSON
  • extracted_date — DATE
  • extracted_amount — INT
  • extracted_merchant — VARCHAR(150)
  • extracted_category — VARCHAR(50)
  • confidence — DECIMAL(5,2)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

receipt_upload

  • receipt_upload_id — BIGINT
  • expense_id — BIGINT — NOT NULL
  • uploaded_by — BIGINT
  • file_url — VARCHAR(255) — NOT NULL
  • file_hash — VARCHAR(64) — NOT NULL
  • mime_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

receipt_verification

  • verification_id — BIGINT
  • expense_id — BIGINT — NOT NULL
  • verified_by — BIGINT
  • verified_merchant — VARCHAR(150)
  • verified_amount — INT
  • verified_category — VARCHAR(50)
  • reason — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

report_file

  • report_file_id — BIGINT
  • report_job_id — BIGINT — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(255) — NOT NULL
  • file_type — VARCHAR(20) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • checksum — VARCHAR(64) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

report_job

  • report_job_id — BIGINT
  • requested_by — BIGINT
  • scope_type — VARCHAR(30) — NOT NULL
  • scope_value — VARCHAR(100)
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • template — VARCHAR(50) — NOT NULL
  • report_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

rpa_review_result

  • rpa_review_id — BIGINT
  • approval_id — BIGINT — NOT NULL
  • decision_hint — VARCHAR(30) — NOT NULL
  • guide_message — VARCHAR(255)
  • evidence_json — JSON
  • created_at — TIMESTAMP — NOT NULL

rpa_rule_config

  • rpa_rule_id — BIGINT
  • updated_by — BIGINT
  • rule_key — VARCHAR(50) — NOT NULL
  • rule_value — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

store_item

  • store_item_id — BIGINT
  • created_by — BIGINT
  • item_name — VARCHAR(150) — NOT NULL
  • item_category — VARCHAR(50) — NOT NULL
  • item_price — INT — NOT NULL
  • item_image_url — VARCHAR(255)
  • stock_quantity — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

store_order

  • store_order_id — BIGINT
  • requester_id — BIGINT
  • total_amount — INT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • memo — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

store_order_item

  • store_order_item_id — BIGINT
  • store_order_id — BIGINT — NOT NULL
  • store_item_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • line_total — INT — NOT NULL

user_budget_monthly

  • budget_id — BIGINT
  • user_id — BIGINT
  • year_month — CHAR(7) — NOT NULL
  • monthly_limit — INT — NOT NULL
  • admin_note — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

users

  • user_id — BIGINT
  • employee_no — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • department_name — VARCHAR(100)
  • role — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP