README

usersテーブル

Column	Type	Options
nickname	string	null: false
email	string	null: false, unique: true
password	string	null: false

Association

• has_many :items, dependent: :destroy
• has_one :creditcard, dependent: :destroy
• has_one :user_address, dependent: :destroy
• has_one :profile, dependent: :destroy

user_addressテーブル

Column	Type	Options
familyname	string	null: false
firstname	string	null: false
familyname_kana	string	null: false
firstname_kana	string	null: false
postalcode	integer	null: false
prefecture_id(active_hash)	string	null: false
city	string	null: false
address	integer	null: false
buildingname	string
phone	string
user_id	references	null: false, foreign_key: true

Association

• belongs_to :user

creditcardsテーブル

Column	Type	Options
customer_id	string	null: false
card_id	string	null: false
user_id	references	null: false, foreign_key: true

Association

• belongs_to :user

profilesテーブル

Column	Type	Options
familyname	string	null: false
firstname	string	null: false
familyname_kana	string	null: false
firstname_kana	string	null: false
year_of_birth	integer	null: false
month_of_birth	integer	null: false
date_of_birth	integer	null: false
introduction	text
icon	string
user_id	references	null: false, foreign_key: true

Association

• belongs_to :user

productsテーブル

Column	Type	Options
name	string	null: false, add_index: true
description	text	null: false
price	integer	null: false
user_id	references	null: false, foreign_key: true
category_id	integer	null: false, foreign_key: true
prefecture_id(active_hash)	integer	null: false, foreign_key: true
size_id(active_hash)	integer	foreign_key: true
brand_id(active_hash)	integer	foreign_key: true
condition_id(active_hash)	integer	null: false, foreign_key: true
shipping_charge_id(active_hash)	integer	null: false, foreign_key: true
days_until_shipping_id(active_hash)	integer	null: false, foreign_key: true
status(enum)	integer	null: false
buyer_id	integer

Association

• belongs_to :user
• belongs_to :brand
• belongs_to :category
• belongs_to_active_hash :prefecture
• belongs_to_active_hash :size
• belongs_to_active_hash :condition
• belongs_to_active_hash :shipping_charge
• belongs_to_active_hash :days_until_shipping
• has_many :images, dependent: :destroy

imagesテーブル

Column	Type	Options
image	string	null: false
item_id	references	null: false, foreign_key: true

Association

• belongs_to :item

categoriesテーブル

Column	Type	Options
name	string	null: false, add_index: true
ancestry	string	null: false

Association

• has_many :items

brandsテーブル

Column	Type	Options
name	string	null: false, add_index: true

Association

• has_many :items