Approval Worlflow System

Tables (4)

approval_assignments

  • id — BIGSERIAL — Primary key — NOT NULL
  • request_id — BIGINT — Foreign key → approval_requests.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • decided_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

approval_logs

  • id — BIGSERIAL — Primary key — NOT NULL
  • request_id — BIGINT — Foreign key → approval_requests.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

approval_requests

  • id — BIGSERIAL — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • version — INT — NOT NULL
  • parent_id — BIGINT — Foreign key → approval_requests.id
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL