Restaurant | Subject area: DOCUMENT

Overview

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

• Entity: DOCUMENT_TYPE
• Entity: DOCUMENT

Entity: DOCUMENT_TYPE

List of document types.

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

Entity: DOCUMENT

This entity can record documents that are relevant for the restaurant business. Each 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
ID	PRIMARY KEY
Employee_ID	If the document is assigned to a Store Employee then Employee_ID is the lookup for that Store Employee. If the document is not assigned to a Store Employee then Employee_ID is NULL.
Menu_ID	If the document is assigned to a Menu then Menu_ID is the lookup for that Menu. If the document is not assigned to a Menu then Menu_ID is NULL.
Name	The name of the document. Cannot have two 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 document. NOT NULL
File_Source	The file source of the document. The file source is uploaded into the File_Source blob column. NOT NULL
Created_Time	Timestamp when the document record was created. NOT NULL
Created_Emp_Login_ID	Lookup for the login session of the Employee who created the document record. NOT NULL
Comments	Internal notes used for clarifications on record content. Can be seen and edited only by Store Employees