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