For managing folder and its related permission functionalities, let us assume that the following entities are involved:
The following diagram represents the entity relationship model for the folder entities through UML.
The following sections describe the low level details of these entities – e.g. the set of attributes, the code table associations, and the primary and foreign key details.
The entity Folder represents a standard folder object. The table below lists the various attributes that make up the Folder object. Note that the attributes type and statusCode have code table relationships to FolderType and RecordStatus respectively.
Column Name |
Primary Key Column |
Foreign Key Details |
Code Table Association |
---|---|---|---|
folderID |
Y |
||
name |
|||
description |
|||
type |
FolderType |
||
statusCode |
RecordStatus |
The entity FolderPermission represents a permission object that can be assigned to a folder. For simplicity, other than the primary key attribute, this entity has only one attribute, name, which stores the name of the permission. Also note that this attribute has a soft relationship with the code table FolderPermissionName.
Column Name |
Primary Key Column |
Foreign Key Details |
Code Table Association |
---|---|---|---|
folderPermissionID |
Y |
||
name |
FolderPermissionName |
Since it is possible for a folder to have multiple permissions associated with it, the association between a folder and its permissions are captured in this entity.
Column Name |
Primary Key Column |
Foreign Key Details |
Code Table Association |
---|---|---|---|
folderPermissionLinkID |
Y |
||
folderID |
Folder.folderID |
||
folderPermissionID |
FolderPermission. folderPermissionID |