補償処理テーブル
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| comp_id | bigint | nextval('compensations_comp_id_seq'::regclass) | false | public.outbox_tasks | 補償ID（自動採番） | |
| order_id | varchar(64) | false | 注文ID | |||
| compensation_type | varchar(30) | false | 補償種別（CANCEL_ORDER / REFUND_PAYMENT） | |||
| status | varchar(20) | 'PENDING'::character varying | false | 補償ステータス（PENDING / COMPLETED / FAILED） | ||
| error_message | text | true | エラーメッセージ | |||
| created_at | timestamp with time zone | now() | false | 作成日時 | ||
| completed_at | timestamp with time zone | true | 完了日時 |
| Name | Type | Definition |
|---|---|---|
| compensations_pkey | PRIMARY KEY | PRIMARY KEY (comp_id) |
| Name | Definition |
|---|---|
| compensations_pkey | CREATE UNIQUE INDEX compensations_pkey ON public.compensations USING btree (comp_id) |
| idx_compensations_order_id | CREATE INDEX idx_compensations_order_id ON public.compensations USING btree (order_id) |
Generated by tbls