3YZW / furima-35009

0 stars 0 forks source link

readme

README

テーブル設計

users テーブル

Column	Type	Options
email	string	null: false, unique: true
encrypted_password	string	null: false
nickname	string	null: false
lastname	string	null: false
firstname	string	null: false
lastkana	string	null: false
firstkana	string	null: false
birthday	date	null: false

Association

has_many :items
has_many :comments
has_many :orders

items テーブル

Column	Type	Options
user	references	null: false, foreign_key: true
title	string	null: false
description	text	null: false
category_id	integer	null: false
status_id	integer	null: false
shipping_id	integer	null: false
area_id	integer	null: false
day_id	integer	null: false
price	integer	null: false

Association

belongs_to :user
has_many :comments
has_one :order

orders テーブル

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

Association

belongs_to :user
belongs_to :item
has_one :destination

destinations テーブル

Column	Type	Options
order	references	null: false, foreign_key: true
zipcode	string	null: false
area_id	integer	null: false
city	string	null: false
address	string	null: false
building	string
phone	string	null: false

Association

belongs_to :order

comments テーブル

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

Association

belongs_to :user
belongs_to :item