Entity: DOCUMENT_TYPE

Top

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

Entity: DOCUMENT

Top

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