Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 5. Website
- 5.1 Database models
- default: incrementing id + timestamps
- Hosts table:
- host name - unique
- host website - unique
- email address - unique, same domain as website
- about text - (bbcode?)
- founded in
- featured
- user_id
- verified
- featured package_id
- monthly bid
- featured expiration date
- url to logo
- Reviews table:
- user_id (determines if featured or not)
- comment (plain) - optional
- support rating
- features rating
- price rating
- performance rating
- amount thumbs up
- amount thumbs down
- Locations, Features, Panel, Games:
- name
- description
- 5.2 Pivot tables
- host-review
- host-feature
- host-game + price
- host-location
- host-panel
- user-review
- host-user
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement