#protospace DB
about protospace:
You can post prototypes, like them, and comment on them.
##Table
users : user info
prototypes : prototype info
prototype_images : image info
likes : like towards prototype
commnents : comment on prototype
##Associations
User:
has_many :prototypes
has_many :comments
has_many :likes
Prototype:
belongs_to :user
has_many :prototype_images
has_many :likes
has_many :comments
Prototype_image:
belongs_to :prototype
Comment:
belongs_to :user
belongs_to :prototype
Like:
belongs_to :user
belongs_to :prototype
##Columns
###users
id | username | password | avatar | profile | member | works | |
---|---|---|---|---|---|---|---|
integer | string | string | string | string | text | string | text |
###prototypes
id | title | catch_copy | concept | user_id |
---|---|---|---|---|
integer | string | string | text | references |
###prototype_images
id | content | prototype_id |
---|---|---|
integer | string | references |
###likes
id | user_id | prototype_id |
---|---|---|
integer | references | references |
###comments
id | user_id | prototype_id | content |
---|---|---|---|
integer | references | references | text |