プログラミングスクールTECH::EXPERTの課題で作成したアプリです。 5人チームのアジャイル開発を行いました。
データベース設計 各テーブル詳細
Column | Type | Options |
---|---|---|
nick_name | string | null: false |
first_name | string | null: false |
last_name | string | null: false |
first_name_kana | string | null: false |
last_name_kana | string | null: false |
birthday | date | null: false |
password | string | null: false |
mail_address | string | null: false |
phone_number | integer | null: false |
- has_many :cashflows,dependent: :destroy
- has_many :addresses,dependent: :destroy
- has_many :credit_card_infos,dependent: :destroy
- has_many :messages,dependent: :destroy
- has_many :items,dependent: :destroy
- has_many :likes,dependent: :destroy
Column | Type | Options |
---|---|---|
amount | integer | null: false |
point | integer | null: false |
type | string | null: false |
date | date | null: false |
user_id | integer | null: false, foreign_key: true |
- belongs_to :user
Column | Type | Options |
---|---|---|
post_number | integer | null: false |
prefecture | string | null: false |
municipality | string | null: false |
block | string | null: false |
building | string | |
phone_number | integer | |
user_id | integer | null: false, foreign_key: true |
- belongs_to :user
Column | Type | Options |
---|---|---|
card_number | integer | null: false |
pin_number | integer | null: false |
expiration_date | date | null: false |
user_id | integer | null: false, foreign_key: true |
- belongs_to :user
Column | Type | Options |
---|---|---|
message | text | null: false |
user_id | integer | null: false, foreign_key: true |
item_id | integer | null: false, foreign_key: true |
- belongs_to :user
- belongs_to :item
Column | Type | Options |
---|---|---|
url | string | null: false |
item_id | integer | null: false, foreign_key: true |
- belongs_to :item
Column | Type | Options |
---|---|---|
name | string | null: false |
item_id | integer | null: false, foreign_key: true |
- has_many :items
Column | Type | Options |
---|---|---|
user_id | integer | null: false, foreign_key: true |
item_id | integer | null: false, foreign_key: true |
- belongs_to :item
- belongs_to :user
Column | Type | Options |
---|---|---|
status | string | null: false |
name | string | null: false |
from_delivery_area | string | null: false |
to_delivery_area | string | null: false |
price | integer | null: false |
delivery_date | date | null: false |
size | string | null: false |
grade | string | null: false |
transfer_fee | string | null: false |
delivery_type | string | null: false |
describe | string | null: false |
buyer_id | integer | null: false |
user_id | integer | null: false, foreign_key: true |
brand_id | integer | null: false, foreign_key: true |
- has_many :images,dependent: :destroy
- has_many :messages,dependent: :destroy
- has_many :likes,dependent: :destroy
- belongs_to :user
- belongs_to :brand
- belongs_to :category
Column | Type | Options |
---|---|---|
name | string | null: false |
ancestry | string | null: false |
- has_many :items
- has_ancestry