Light

jevargasv / freemarket_sample_68k Goto Github PK

View Code? Open in Web Editor NEW

This project forked from shin-tech25/freemarket_sample_68k

0.0 1.0 0.0 1.91 MB

freemarket sample application 68k

Ruby 32.85% JavaScript 12.95% CSS 27.27% HTML 26.94%

freemarket_sample_68k's Introduction

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
...

freemarket_sample_68k DB設計

usersテーブル

Column	Type	Options
nickname	string	null: false
email	string	null: false, unique: true
password	string	null: false
family_name	string	null: false
last_name	string	null: false
j_family_name	string	null: false
j_last_name	string	null: false
b_year	integer	null: false
b_month	integer	null: false
b_date	integer	null: false
user_image	string

Association

has_many :items
has_many :credits
has_many :purchases
has_many :comments
has_many :favorites
has_one :residence

itemsテーブル

Column	Type	Options
name	string	null: false
price	integer	null: false
content	text	null: false
brand	string
condition	string	null: false
shipping	string	null: false
shipping_area	string	null: false
days_to_ship	string	null: false
shipping_method	string	null: false
status	integer	null: false
user_id	references	null: false, foreign_key: true
category_id_1	references	null: false, foreign_key: true
category_id_2	references	null: false, foreign_key: true
category_id_3	references	null: false, foreign_key: true
size_id	references

Association

has_many :item_images
has_many :comments
has_many :favorites
belongs_to :user
belongs_to :category
has_one :purchase

categoriesテーブル

Column	Type	Options
name	string	null: false
ancestry	string	null: false

Association

has_many :items
has_ancestry

item_imagesテーブル

Column	Type	Options
image	string	null: false
item_id	references	null: false, foreign_key: true

Association

belongs_to :item

purchasesテーブル

Column	Type	Options
user_id	references	null: false, foreign_key: true
item_id	references	null: false, foreign_key: true
postcode	string	null: false
prefecture	string	null: false
city	string	null: false
block	string	null: false
building	string
phone_number	string

Association

belongs_to :user
belongs_to :item

residencesテーブル

Column	Type	Options
family_name	string	null: false
last_name	string	null: false
j_family_name	string	null: false
j_last_name	string	null: false
postcode	string	null: false
prefecture	string	null: false
city	string	null: false
block	string	null: false
building	string
phone_number	string
user_id	references	null: false, foreign_key: true

Association

belongs_to :user

commentsテーブル

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

Association

belongs_to :user
belongs_to :item

favoritesテーブル

Column	Type	Options
user_id	references	null: false, foreign_key: true
item_id	references	null: false, foreign_key: true

Association

belongs_to :user
belongs_to :item

cardsテーブル

Column	Type	Options
user_id	integer	null: false
customer_id	string	null: false
card_id	string	null: false

Association

belongs_to :user

freemarket_sample_68k's People

Contributors

Watchers

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.