The content Data Table
This model was developed to make building custom content driven websites as easy as possible. This was accomplished by creating one master content table that is capable of serving any form of data.
The core goal here was to let the database handle data and not worry about any of the application logic. The high level models then extend the superclass Content which manages the database (in)directly. Content handles the basic logic of managing content_types and what not.
The Table
| Field | Data Type | Notes |
| content_type | varchar | this field is used by the system to differentiate the different content types |
| format | varchar | this is an optional field that can be used for things like downloads, etc |
| reference | text | you can use this for what ever you like in your modules |
| related_content | text | the system uses this to relate content items |
| tags | text | optional, search tags |
| parent_id | int | used for core relations (sitemap) |
| title | varchar | the title is the unique identifier for the content item. it could be thought of as a filename. |
| show_on_menu | int | boolean |
| label | varchar | the menu label. this will override the page title as its menu label. |
| position | int | the relative position of the item in relation to its siblings |
| headline | text | this will override the page title as the headline |
| intro | text | optional content |
| content | text | main content |
| additional_content | text | what ever you want to use it for |
| template_path | varchar | sets the template for this page and any of its children that do not have a template specifically set |
| layout_path | varchar | same as above. layouts are like subtemplates. |
| publish_level | int | used when you want to restrict permissions to a page |
| publish_date | int |
(all date/times are timestamps) optional, date to publish the item |
| archive_date | int | optional, date to unpublish item |
| author_id | int | system saves this |
| create_date | int | system saves this |
| editor_id | int | system saves this |
| edit_date | int | system saves this |
| properties | text | I will link to another page to go into detail on these |
| hits | int | system saves this |
| filepath | varchar | used for a thumbnail image or what ever else |
