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