GAGYEOL
Tables (6)
evidences
- evidence_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id
- evidence_name — VARCHAR(255)
- evidence_file — VARCHAR(512)
- extracted_text — TEXT
- created_at — TIMESTAMP
expense_reports
- expense_report_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id
- form_id — BIGINT — Foreign key → forms.form_id
- policy_id — BIGINT — Foreign key → policies.policy_id
- title — VARCHAR(255) — NOT NULL
- purpose — TEXT
- amount — DECIMAL(15, 2)
- proposal_date — DATE
- status — VARCHAR(50)
- created_at — TIMESTAMP
forms
- form_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id
- form_name — VARCHAR(255) — NOT NULL
- form_file — VARCHAR(512)
- content — TEXT
- created_at — TIMESTAMP
policies
- policy_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id
- policy_name — VARCHAR(255) — NOT NULL
- policy_file — VARCHAR(512)
- rule_content — TEXT
- created_at — TIMESTAMP
results
- result_id — BIGINT
- expense_report_id — BIGINT — Foreign key → expense_reports.expense_report_id
- evidence_id — BIGINT — Foreign key → evidences.evidence_id
- result_name — VARCHAR(255)
- result_content — TEXT
- result_file — VARCHAR(512)
- approved — BOOLEAN
- created_at — TIMESTAMP
users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(50)
- department — VARCHAR(100)
- created_at — TIMESTAMP