The Logical Data Model of the DOCUMENT Subject Area includes the following entities:
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 |
Example
Document_TYPE
Name | Description |
---|---|
Image | JPG, JPEG, PNG, BMP etc |
Document | DOC, PDF, TXT, HTML etc |
Video | MP4, AVI, MOV etc |
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 |