fleamarket DB設計

usersテーブル

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

Association

• has_one :profile
• has_many :addresses
• has_many :creditcards
• has_many :products

profilesテーブル

Column	Type	Options
user_id	references	foreign_key: true
family_name	string	null: false
family_name_kana	string	null: false
first_name	string	null: false
first_name_kana	string	null: false
birthday	integer	null: false
birthmonth	integer	null: false
birthyear	integer	null: false

Association

• belongs_to :user

creditcardsテーブル

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

Association

• belongs_to :user

productsテーブル

Column	Type	Options
title	string	null: false
text	text	null: false
seller_id	references	foreign_key: true
buyer_id	references	foreign_key: true
category_id	references	foreign_key: true
size_id	references	foreign_key: true
brand_id	references	foreign_key: true
condition	string	null: false
shipping_charge	integer	null: false
prefecture_id	integer	null: false
deliver_leadtime	integer	null: false
price	integer	null: false

Association

• belongs_to :user
• belongs_to_active_hash :prefecture
• belongs_to :category
• belongs_to :size
• belongs_to :brand
• has_many :product_images

addressesテーブル

Column	Type	Options
user_id	references	foreign_key: true
post_family_name	string	null: false
post_family_name_kana	string	null: false
post_personal_name	string	null: false
post_personal_name_kana	string	null: false
postal_code	integer	null: false
prefecture_id	integer	null: false
city	string	null: false
address	string	null: false
building	string
phone_number	string

Association

• belongs_to :user
• belongs_to_active_hash :prefecture

categoriesテーブル

Column	Type	Options
name	string	null: false
ancestry	string

Association

• has_many :products
• has_ancestry

sizesテーブル

Column	Type	Options
name	string	null: false

Association

• has_many :products

brandsテーブル

Column	Type	Options
name	string	null: false

Association

• has_many :products

product_imagesテーブル

Column	Type	Options
image	string	null: false
product_id	references	foreign_key: true

Association

• belongs_to :product