The Database Structure

The database contains a large number of data tables, which are always accessed and manipulated through stored procedures. In the following pages, we’ll have a quick look at the way the CommunityStarterKit database is organized. InChapter 7, we’ll learn about the stored procedures used to manipulate module data.

The Tables

Remember that the name of the database can be specified when installing the Community Starter Kit. Here we’ll just assume that you used the default name, CommunityStarterKit.

The CommunityStarterKit database has quite a complicated structure, formed of more than 60 data tables (the names of which always start with Community), but its skeleton is composed of just three important tables: Community_Communities, Community_Sections, and Community_ContentPages. These tables have one-to-many relationships enforced with foreign keys as shown in the following figure:

Community_Communities contains information about each community in the CSK installation. Basically...