Creating a database table with keys
As DNN is a database driven Content management system (CMS), it is likely your module will include one or more database Tables. A database table is used to hold information for your module. Similar to a spreadsheet, a table consists of columns called
Fields and rows called
Records. As we are creating a module called Employee, the fields in our table will hold employee information such as first and last name. Each record in the table will hold one employee.
One of the things that makes a database table more powerful than a simple spreadsheet is its ability to automatically validate the information in the records. For example, it is important that each employee record in the table has a unique value that identifies ...