Subject area: MEDIA
Overview
The Logical Data Model of the MEDIA Subject Area includes the following entities:
Entity: DOCUMENT_TYPE
List of media document types.
| Attributes | Description |
|---|---|
ID |
PRIMARY KEY |
Name |
Document Type name. Cannot have two media document types with the same name. NOT NULL UNIQUE. |
Description |
Document Type description |
Example
Document_TYPE
| Name | Description |
|---|---|
| Image | JPG, JPEG, PNG, BMP etc |
| Document | DOC, PDF, TXT, HTML etc |
| Video | MP4, AVI, MOV etc |
Entity: DOCUMENT
This entity can record media documents that are relevant for the restaurant business. Each media document can be assigned to:
a Store Employee (for example a copy of the employment contract)
a Menu (for example photos of menu Items)
other topics that are relevant for the restaurant business.
| Attributes | Description |
|---|---|
ID |
PRIMARY KEY |
Employee_ID |
If the media document is assigned to a Store Employee then Employee_ID is the lookup for that Store Employee. If the media document is not assigned to a Store Employee then Employee_ID is NULL. |
Menu_ID |
If the media document is assigned to a Menu then Menu_ID is the lookup for that Menu. If the media document is not assigned to a Menu then Menu_ID is NULL. |
Name |
The name of the media document. Cannot have two media documents with the same name. NOT NULL UNIQUE |
Document_Type_ID |
Lookup for the Document Type. NOT NULL |
File_Name |
The name of the file uploaded for media document. NOT NULL |
File_Source |
The file source of the media document. The file source is uploaded into the File_Source blob column. NOT NULL |
Created_Time |
Timestamp when the media document record was created. NOT NULL |
Created_Emp_Login_ID |
Lookup for the login session of the Employee who created the media document record. NOT NULL |
Comments |
Internal notes used for clarifications on record content. Can be seen and edited only by Store Employees |