ownloads Documentation Centre!Database Structure for jD4
Introduction
This article has details of the jD 4 database structure. It has side-by-side lists of the Tables.
The jD database has 7 tables: Categories, Files, User Groups, Templates, Ratings, licenses and logs.
See also the article Database Structure Extra (opens in a new window/tab) which also includes the Type, NULL and Default fields.
The Files table actualy has the Downloads information, it does not have the downloadable file. The Templates table has the various Layouts.
Databases - Page 1
Page 1 below has the Ratings, licenses and logs tables in the far right column to conserve 'screen space'.
Link to page 1 as a pdf
jDownloadsV4-database-page1.pdf (opens in a new window/tab)
Databases - Page 2
This page has the next sections of the Files and User Groups tables and is followed by a link to download a pdf version.
Link to page 2 as a pdf
jDownloadsV4-database-page2.pdf (opens in a new window/tab)
Databases - Page 3
This is the final section of the Filestable and the next section of the User Groups table. It is followed by a link to download a pdf version of Page 3.
Link to page 3 as a pdf
jDownloadsV4-database-page3.pdf (opens in a new window/tab)
Databases - Page 4
This page has the final section of the User Groups table. It is followed by a link to download a pdf version.
Link to page 4 as a pdf
jDownloadsV4-database-page4.pdf (opens in a new window/tab)