order_item

-1 rows


Description

注文商品

Columns

Column Type Size Nulls Auto Default Children Parents Comments
order_item_id int8 19 √ null

注文商品ID
order_id int8 19 null
order.order_id order_id_fk R
order_2024_06.order_id order_item_order_id_order_date_fkey5 R
order_2024_04.order_id order_item_order_id_order_date_fkey3 R
order_2024_03.order_id order_item_order_id_order_date_fkey2 R
order_2024_07.order_id order_item_order_id_order_date_fkey6 R
order_2024_08.order_id order_item_order_id_order_date_fkey7 R
order_2024_09.order_id order_item_order_id_order_date_fkey8 R
order_2024_11.order_id order_item_order_id_order_date_fkey10 R
order_2024_05.order_id order_item_order_id_order_date_fkey4 R
order_2024_12.order_id order_item_order_id_order_date_fkey11 R
order_2024_01.order_id order_item_order_id_order_date_fkey R
order_2024_10.order_id order_item_order_id_order_date_fkey9 R
order_2024_02.order_id order_item_order_id_order_date_fkey1 R

注文ID
product_id int8 19 null
product.product_id product_id_fk R

商品ID
order_date timestamp 29,6 CURRENT_TIMESTAMP
order_2024_01.order_date order_item_order_id_order_date_fkey R
order_2024_10.order_date order_item_order_id_order_date_fkey9 R
order_2024_07.order_date order_item_order_id_order_date_fkey6 R
order_2024_03.order_date order_item_order_id_order_date_fkey2 R
order_2024_08.order_date order_item_order_id_order_date_fkey7 R
order_2024_11.order_date order_item_order_id_order_date_fkey10 R
order_2024_02.order_date order_item_order_id_order_date_fkey1 R
order_2024_06.order_date order_item_order_id_order_date_fkey5 R
order_2024_12.order_date order_item_order_id_order_date_fkey11 R
order.order_date order_id_fk R
order_2024_09.order_date order_item_order_id_order_date_fkey8 R
order_2024_04.order_date order_item_order_id_order_date_fkey3 R
order_2024_05.order_date order_item_order_id_order_date_fkey4 R

注文日時
quantity int4 10 null

注文数
price numeric 10,2 null

注文時の商品の単価
created_at timestamp 29,6 CURRENT_TIMESTAMP

作成日時
updated_at timestamp 29,6 CURRENT_TIMESTAMP

更新日時

Indexes

Constraint Name Type Sort Column(s)
order_item_pk Primary key Asc/Asc order_item_id + order_date

Relationships

Close relationships within degrees of separation