Online Food Ordering Data Model | Subject area: MEDIA

Overview

The Logical Data Model of the MEDIA Subject Area includes the following entities:

• Entity: DOCUMENT_TYPE
• Entity: DOCUMENT

Entity: DOCUMENT_TYPE

List of media document types.

Attributes
ID	PRIMARY KEY
Name	Document Type name. Cannot have two media document types with the same name. NOT NULL UNIQUE.
Description	Document Type description

Entity: DOCUMENT

This entity can record media documents that are relevant for the Online Food Ordering 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 Online Food Ordering business.

Attributes
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