README

db設計

usersテーブル

Column	Type	Options
nickname	string	null: false, unique: true
email	string	null: false,unique: true
encrypted_password	string	null: false
user_image	string
profile	text
family_name	string	null: false
first_name	string	null: false
family_name_kana	string	null: false
first_name_kana	string	null: false
birth_day	date	null: false

Association

• has_many :products dependent: :destroy
• has_one :delivery_destination dependent: :destroy
• has_one :credit_card dependent: :destroy

delivery_destinationsテーブル

Column	Type	Options
user_id	integer	null: false, foreign_key: true
family_name	string	null: false
first_name	string	null: false
family_name_kana	string	null: false
first_name_kane	string	null: false
post_code	integer	null: false,length: { is: 7 }
prefecture	string	null: false
city	string	null: false
address	string	null: false
building_name	string
phone_number	integer	null: false

Association

• belongs_to :user

credit_cardsテーブル

Column	Type	Options
user_id	integer	null:false, foreign_key: true
custemer_id	string	null:false
card_id	integer	null:false

Association

• belongs_to :user

productsテーブル

Column	Type	Options
name	string	null: false
price	string	null: false
description	string	null: false
condition	integer	null: false
size	string	null: false
shipping_cost	integer	null: false
shipping_days	integer	null: false
prefecture_id	integer	null: false
trading_status	boolean	null: false
category_id	integer	null: false, foreign_key: true
user_id	integer	null: false, foreign_key: true

Association

• belongs_to :user
• has_many :product_imgs
• belongs_to :category
• has_many :brands

product_imgsテーブル

Column	Type	Options
image	string	null: false
product_id	integer	null: false, foreign_key: true

Association

• belongs_to :product

categorysテーブル

Column	Type	Options
name	string	null: false
ansestory	string

Association

• has_many :products

brandsテーブル

Column	Type	Options
name	string	null: false
brandid	integer	null: false, foreign_key: true

Association

• belongs_to :product