pirikara/freemarket_sample_64b

README

This README would normally document whatever steps are necessary to get the application up and running.

Things you may want to cover:

• Ruby version

• System dependencies

• Configuration

• Database creation

• Database initialization

• How to run the test suite

• Services (job queues, cache servers, search engines, etc.)

• Deployment instructions

usersテーブル

Column	Type	Options
nickname	string	null: false
email	string	null: false
password	string	null: false
last_name	string	null: false
first_name	string	null: false
last_name_kana	string	null: false
first_name_kana	string	null: false
phone_number	string	null: false, unique: true
birthyear_id	reference	null: false, foreign_key: true
birthmonth_id	reference	null: false, foreign_key: true
birthday	integer	null: false
icon	text	null: false
header_image	text	null: false
introduce	text

Association

has_many :items has_many :comments has_many :messages has_many :dns_credentials, dependent: :destroy has_many :buyed_items, forign_key: ”buyer_id”, class_name: ‘Item’ has_many :selling_items, -> { where(“buyer_id is NULL") }, foreign_key: “seller_id", class_name: “Item” has_many :sold_items, -> { where(“buyer_id is not NULL") }, foreign_key: “seller_id", class_name: “Item” belongs_to_active_hash :birthyear belongs_to_active_hash :birthmonth has_one :user_address

user_addressテーブル

Column	Type	Options
user	reference	null: false, foreign_key: true
postcode	string	null: false
prefecture_id	reference	null: false, foreign_key: true
city	string	null: false
address	string	null: false
building_name	string
address_phone_number	string

Association

belongs_to :user belongs_to_active_hash :prefecture

sns_credentialsテーブル

Column	Type	Options
uid	string
provider	string
user	reference	foreign_key: true

Association

belongs_to :user, optional: true

items

Column	Type	Options
seller	reference	null: false, foreign_key: true
buyer	reference	null: false, foreign_key: true
name	string	null: false, add_index: true
description	string	null: false
category	reference	null: false, foreign_key: true
size	reference	null: false, foreign_key: true
brand	reference	null: false, foreign_key: true
condition	reference	null: false, foreign_key: true
prefecture	reference	null: false, foreign_key: true
sendingmethod	reference	null: false, foreign_key: true
postageburden	reference	null: false, foreign_key: true
shippingday	reference	null: false, foreign_key: true
price	integer	null: false
profit	integer	null: false

Association

has_many :images, dependent: :destroy accepts_nested_attributes_for :images, allow_destroy: true has_many :comments has_many :messages belongs_to :buyer, class_name: 'User', optional: true belongs_to :seller, class_name: 'User' belongs_to :category belongs_to :size belongs_to :brand belongs_to_active_hash :prefecture belongs_to_active_hash :condition belongs_to_active_hash :sendingmethod belongs_to_active_hash :postageburden belongs_to_active_hash :shippingday

categoriesテーブル

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

Association

has_many: items has_many: brands, through: :category_brands has_many: category_brands has_ancestry

brandsテーブル

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

Association

has_many :items has_many :categories, through: :category_brands has_many :category_brands

category_brandsテーブル

Column	Type	Options
category_id	reference	null: false, foreign_key: true
brand_id	reference	null: false, foreign_key: true

Association

belongs_to :category belongs_to :brand

imagesテーブル

Column	Type	Options
item_id	integer	null: false, foreign_key: true
image_url	text	null: false

### Association belongs_to :item, optional: true

commentsテーブル

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

Association

belongs_to :user belongs_to :item

messagesテーブル

Column	Type	Options
content	string	null: false
item_id	reference	null: false, foreign_key: true
user_id	reference	null: false, foreign_key: true

Association

belongs_to :user belongs_to :item