注文テーブル
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| order_id | varchar(64) | false | 注文ID（主キー） | |||
| product_id | varchar(64) | false | 商品ID | |||
| quantity | integer | false | 数量 | |||
| amount | numeric(19,2) | false | 金額 | |||
| status | varchar(20) | 'PENDING'::character varying | false | 注文ステータス（PENDING / COMPLETED / CANCELLED） | ||
| created_at | timestamp with time zone | now() | false | 作成日時 | ||
| updated_at | timestamp with time zone | now() | false | 更新日時 |
| Name | Type | Definition |
|---|---|---|
| orders_pkey | PRIMARY KEY | PRIMARY KEY (order_id) |
| Name | Definition |
|---|---|
| orders_pkey | CREATE UNIQUE INDEX orders_pkey ON public.orders USING btree (order_id) |
Generated by tbls