order

-1 rows


Description

注文

Columns

Column Type Size Nulls Auto Default Children Parents Comments
order_id int8 19 √ null
order_item.order_id order_id_fk R
order_item_2024_01.order_id order_id_fk R
order_item_2024_02.order_id order_id_fk R
order_item_2024_03.order_id order_id_fk R
order_item_2024_04.order_id order_id_fk R
order_item_2024_05.order_id order_id_fk R
order_item_2024_06.order_id order_id_fk R
order_item_2024_07.order_id order_id_fk R
order_item_2024_08.order_id order_id_fk R
order_item_2024_09.order_id order_id_fk R
order_item_2024_10.order_id order_id_fk R
order_item_2024_11.order_id order_id_fk R
order_item_2024_12.order_id order_id_fk R

注文ID
user_id int8 19 null
user.user_id user_id_fk R

ユーザーID
total_price numeric 10,2 null

合計金額
status varchar 20 null

ステータス
order_date timestamp 29,6 CURRENT_TIMESTAMP
order_item.order_date order_id_fk R
order_item_2024_01.order_date order_id_fk R
order_item_2024_02.order_date order_id_fk R
order_item_2024_03.order_date order_id_fk R
order_item_2024_04.order_date order_id_fk R
order_item_2024_05.order_date order_id_fk R
order_item_2024_06.order_date order_id_fk R
order_item_2024_07.order_date order_id_fk R
order_item_2024_08.order_date order_id_fk R
order_item_2024_09.order_date order_id_fk R
order_item_2024_10.order_date order_id_fk R
order_item_2024_11.order_date order_id_fk R
order_item_2024_12.order_date order_id_fk R

注文日時
shipping_prefecture varchar 5 null

配送先都道府県
shipping_city varchar 50 null

配送先市区町村
shipping_street_address varchar 255 null

配送先番地
shipping_building_name varchar 255 √ null

配送先建物名
payment_method varchar 20 null

支払いステータス
payment_status varchar 20 null

支払いステータス
payment_date timestamp 29,6 √ null

支払い日時
created_at timestamp 29,6 CURRENT_TIMESTAMP

作成日時
updated_at timestamp 29,6 CURRENT_TIMESTAMP

更新日時

Indexes

Constraint Name Type Sort Column(s)
order_pk Primary key Asc/Asc order_id + order_date

Relationships

Close relationships within degrees of separation