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