Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each content section |
|
| Name | nvarchar | 500 | √ | null |
|
|
Section name - Descriptive name of the content section |
|
| Type | nvarchar | 40 | √ | null |
|
|
Section type - Type or category of the section (e.g., ‘Report’, ‘Form’, ‘Dashboard’) |
|
| SourceName | nvarchar | 500 | √ | null |
|
|
Source name - Name of the data source or content source for this section |
|
| SourceID | int | 4 | √ | null |
|
|
Source identifier - Numeric identifier for the data source |
|
| ViewType | nvarchar | 40 | √ | null |
|
|
View type - Type of view or display format for the section |
|
| Options | nvarchar | 1073741823 | √ | null |
|
|
Section options - Configuration options and settings for the section in JSON or XML format |
|
| ReportID | int | 4 | √ | null |
|
|
Report reference - Links to Reports table if this section is part of a report |
|
| DraftID | nvarchar | 500 | √ | null |
|
|
Draft identifier - Identifier for draft versions of the section |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the section was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the section |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when the section was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the section |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the section was soft-deleted |
|
| Order | int | 4 | √ | null |
|
|
Display order - Numeric order for displaying sections within their container |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Sections | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
