決済テーブル
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| payment_id | varchar(64) | false | 決済ID（主キー） | |||
| order_id | varchar(64) | false | 注文ID | |||
| amount | numeric(19,2) | false | 金額 | |||
| status | varchar(20) | 'AUTHORIZED'::character varying | false | 決済ステータス（AUTHORIZED / CAPTURED / REFUNDED） | ||
| created_at | timestamp with time zone | now() | false | 作成日時 | ||
| updated_at | timestamp with time zone | now() | false | 更新日時 |
| Name | Type | Definition |
|---|---|---|
| payments_pkey | PRIMARY KEY | PRIMARY KEY (payment_id) |
| Name | Definition |
|---|---|
| payments_pkey | CREATE UNIQUE INDEX payments_pkey ON public.payments USING btree (payment_id) |
| idx_payments_order_id | CREATE INDEX idx_payments_order_id ON public.payments USING btree (order_id) |
Generated by tbls