search

masanaga225150 / furima-39448

0 stars 0 forks source link

readme

テーブル設計

users テーブル

Column Type Options
nickname string null: false
email string null: false, unique: true
encrypted_password string null: false
first_name string null: false
last_name string null: false
first_name_kana string null: false
last_name_kana string null: false
birthday date null: false

Association

items テーブル

Column Type Options
product_name string null: false
description text null: false
category_id integer null: false
condition_id integer null: false
shipping_fee_id integer null: false
delivery_prefecture_id integer null: false
shipping_duration_id integer null: false
price integer null: false
user references null: false, foreign_key: true

Association

items_orders テーブ ル

Column Type Options
delivery_zipcode string null: false
delivery_prefecture_id integer null: false
delivery_city string null: false
delivery_address string null: false
delivery_building string
delivery_phone string null: false
order references null: false, foreign_key: true

Association

orders テーブル

Column Type Options
user references null: false, foreign_key: true
item references null: false, foreign_key: true

Association