Inspection

Database Diagram for Food Establishment Inspection Data

Employee Employee.employee_id Employee.first_name Employee.last_name Employee.address Employee.city Employee.state Employee.zip Employee.phone Employee.title Employee.salary Employee.supervisor Establishment Establishment.license_no Establishment.dba_name Establishment.aka_name Establishment.facility_type Establishment.risk_level Establishment.address Establishment.city Establishment.state Establishment.zip Establishment.latitude Establishment.longitude Establishment.location Establishment.ward Inspection_point Inspection_point.point_id Inspection_point.description Inspection_point.category Inspection_point.code Inspection_point.fine Inspection_point.point_level Inspection Inspection.inspection_id Inspection.inspection_date Inspection.inspection_type Inspection.results Inspection.employee_id Inspection.license_no Inspection.followup_to Employee JOIN Supervisor ON Employee.supervisor = Supervisor.employee_id Inspection JOIN Establishment ON Inspection.license_no = Establishment.license_no Inspection JOIN Employee ON Inspection.employee_id = Employee.employee_id Violation JOIN Inspection ON Violation.inspection_id = Inspection.inspection_id Violation JOIN Inspection_point ON Violation.point_id = Inspection_point.point_id Inspection JOIN Prior_Inspection ON Inspection.followup_to = Prior_Inspection.inspection_id