メルカリ クローン DB設計

usersテーブル

Column	Type	Options
nickname	string	null: false
family_name	string	null :false
family_name_kana	string	null :false
first_name	string	null :false
first_name_kana	string	null :false
email	string	null: false
password	string	null: false
birthday	date	null: false
phone_number	string	unique:true
profile	string

Association

• has_many :products
• has_many ::sns_credentials, :dependent => :destroy
• has_many :comments, :dependent => :destroy
• has_one :user_address
• has_one :card_info

user_addressesテーブル

Column	Type	Options
user_id	integer	null :false
postal_code	integer	null :false
prefectures	integer	null :false
city	string	null :false
address	string	null :false
building	string

Association

• belongs_to :user, optional: true

sns_credentials

Column	Type	Options
provider	string
uid	string
user_id	bigint

Association

• belongs_to :user

card_infosテーブル

Column	Type	Options
user_id	integer	null :false
card_number	bigint
security_code	integer
use_limit_month	integer
use_limit_year	integer
customer_id	string	null :false
card_id	string	null :false

Association

• belongs_to :user,optional: true

productsテーブル

Column	Type	Options
name	string	null: false
text	text	null: false
category_id	string	null: false, foreign_key: true
brand_id	integer	foreign_key: true
price	integer	null: false
product_size	string
condition	string	null :false
shipping_charge	string
shipping_method	string
delivery_area	string	null :false
user_id	integer	null: false, foreign_key: true
estimated_delivery	string
image	string
status	integer
buyer_id	integer

Association

• belongs_to :user
• belongs_to :category
• belongs_to :brand
• has_many :photos, :dependent => :destroy
• has_many :comments, :dependent => :destroy

photosテーブル

Column	Type	Options
product_id	bigint	null :false, foreign_key: true
image_url	string

Association

• belongs_to :product,optional: true, :dependent => :destroy

commentsテーブル(現在未実装)

Column	Type	Options
text	text	null: false
product_id	integer	null: false, foreign_key: true
user_id	integer	null: false, foreign_key: true

Association

• belongs_to :user
• belongs_to :product

categoriesテーブル

Column	Type	Options
name	string	null: false
size_id	reference	null :false, foreign_key: true

Association

has_many :blands has_many :products has_one :category_size

category_sizesテーブル

Column	Type	Options
size_id	integer	null: false
size	string

brandテーブル

Column	Type	Options
name	string

Association

• has_many :products

shipping_methodsテーブル

Column	Type	Options
shipping_method	string

shipping_chargesテーブル

Column	Type	Options
shipping_charge	string

delivery_areasテーブル

Column	Type	Options
delivery_method	string

conditionsテーブル

Column	Type	Options
condition	string