Skip to content

Latest commit

 

History

History
175 lines (140 loc) · 3.78 KB

README.md

File metadata and controls

175 lines (140 loc) · 3.78 KB
Raw

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

  • ...

commentsテーブル

Column Type Options
contents text
user references null: false, foreign_key: true
product references null: false, foreign_key: true

Association

  • belongs_to :user
  • belongs_to :product

likesテーブル

Column Type Options
user references null: false, foreign_key: true
product references null: false, foreign_key: true

Association

  • belongs_to :user
  • belongs_to :product

usersテーブル

Column Type Options
nickname string
first_name string
last_name string
kana_first_name string
kana_last_name string
birth_date data
email string null: false, unique: true
password string null: false
password_confirmation string null: false
uid string
provider string

Association

  • has_many :comments
  • has_many :likes ,dependent: :destory
  • has_one :address,dependent: :destory
  • has_one :payment, dependent: :destory
  • has_one :sale,dependent: :destory
  • has_one :point, dependent: :destory
  • has_many :products, dependent: :destory

addressesテーブル

Column Type Options
postcode integer null: false
prefecture_code integer null: false
city string null: false
street string null: false
building string
phone integer
user references null: false, foreign_key: true

Association

  • belongs_to :user, dependent: :destroy

paymentsテーブル

Column Type Options
customer_id integer
card_id integer
user references null: false, foreign_key: true

Association

  • belongs_to :user, dependent: :destroy

salesテーブル

Column Type Options default
total_sales integer 0
user references null: false, foreign_key: true

Association

  • belongs_to :user

pointsテーブル

Column Type Options default
earn_points integer 0
used_points integer 0
user references null: false, foreign_key: true

Association

  • belongs_to :user

productsテーブル

Column Type Options Default
name string null: false
description text null: false
price integer null: false
condition string null: false
status integer null: false selling
payment_method_of_delivery_fee integer null: false
origin_of_delivery integer null: false
estimated_date_of_delivery integer null: false
size string
brand references foreign_key: true
category references null: false, foreign_key: true
user_id references null: false, add_foreign_key :true
buyer_id integer

Association

  • has_many :comments
  • has_many :likes
  • belongs_to :user
  • has_many :images,dependent: :destory
  • belongs_to :brand
  • belongs_to :category

imagesテーブル

Column Type Options
image text
product references null: false, foreign_key: true

Association

  • belongs_to :product

brandsテーブル

Column Type Options
name string null: false

Association

  • has_many :products

categoriesテーブル

Column Type Options
name string null: false
ancestry string add_index

Association

  • has_many :products
  • has_ancestry

tradesテーブル

Column Type Options
user references null:false,foreign_keys:true
product references null:false,foreign_keys:true
date_of_confirmation date null:true

Association

  • belongs_to :product
  • belongs_to :user