tera24d / furima-32113

0 stars 0 forks source link

readme

テーブル設計

users テーブル

Column	Type	Options
email	string	null: false
encrypted_password	string	null: false
nickname	string	unique: true
last_name	string	null: false
first_name	string	null: false
last_name_kana	string	null: false
first_name_kana	string	null: false
birth_date	date	null: false

Association

has_many :items
has_many :orders

items テーブル

Column	Type	Options
name	string	null: false
info	text	null: false
price	integer	null: false
user	references	foreign_key: true
purchaser	references	foreign_key: true
category_id	integer	null: false
sales-status_id	integer	null: false
prefecture_id	integer	null: false
shipping-fee-status_id	integer	null: false
scheduled-delivery_id	integer	null: false

Association

belongs_to :user
has_one :purchase

orders テーブル

Column	Type	Options
item	references	foreign_key: true
user	references	foreign_key: true

Association

belongs_to :user
belongs_to :item
has_one :address

addresses テーブル

Column	Type	Options
postal-code	string	null: false
prefecture_id	integer	null: false
city	string	null: false
addresses	string	null: false
building	string
phone-number	string	null: false
order	references	foreign_key: true

Association

belongs_to :order