Tables


SchemaSpy Analysis of employees

Generated on Sun Sep 30 23:51 GMT 2018

XML Representation
Insertion Order Deletion Order
TABLES 6
VIEWS 3
COLUMNS 32
Constraints 6
Anomalies 0
Routines 0

Database Properties

Database Type: MySQL - 5.7.23-0ubuntu0.18.04.1

Tables

Table / View Children Parents Columns Rows Type Comments
dept_manager 0 2 4 24 Table
dept_emp 0 2 4 323263 Table
employees 6 0 6 299290 Table
titles 0 1 4 442605 Table
salaries 0 1 4 2838426 Table
departments 3 0 2 9 Table
current_dept_emp 0 2 4 0 View
titlelist 0 0 1 0 View
dept_emp_latest_date 0 1 3 0 View