Database schema for the Media Manager Tool

WeAreAthlon / Silla.IO

PHP Application Development Framework.

https://silla.io

GNU General Public License v3.0

25 stars 3 forks source link

Closed pnikolov closed 8 years ago

pnikolov commented 9 years ago

Medium (table media), i18n - storage for all files
- Primary index id
- FK index cmsuser_id
- Unique index path, filename
MediumTag (_table medium_tags_) - storage for all tags. The tags will act like directories.
- Primary index id

Association: Media N:M MediumTags

Below is a graphical representation of the proposed schema.

screen shot 2015-02-03 at 3 21 00 pm

pnikolov commented 9 years ago

Updated version after the internal meeting:

screen shot 2015-02-09 at 11 48 32 am