Transactional Outbox パターン用のイベントテーブル
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | nextval('outbox_events_id_seq'::regclass) | false | イベントID（自動採番） | ||
| order_id | varchar(64) | false | 注文ID | |||
| event_type | varchar(50) | false | イベント種別 | |||
| payload | text | false | イベントペイロード（JSON） | |||
| published | boolean | false | false | 発行済みフラグ | ||
| created_at | timestamp with time zone | now() | false | 作成日時 | ||
| published_at | timestamp with time zone | true | 発行日時 |
| Name | Type | Definition |
|---|---|---|
| outbox_events_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| Name | Definition |
|---|---|
| outbox_events_pkey | CREATE UNIQUE INDEX outbox_events_pkey ON public.outbox_events USING btree (id) |
| idx_outbox_events_unpublished | CREATE INDEX idx_outbox_events_unpublished ON public.outbox_events USING btree (published, created_at) WHERE (published = false) |
Generated by tbls