Scribd
Upload
12 views1 page

Work Order Management Overview

The document outlines a database schema for managing work tasks, work orders, customers, and related entities. It includes details such as work task attributes, status, employee and customer information, and billing details. The schema emphasizes relationships between different entities, including foreign keys and primary keys for data integrity.

Uploaded by

Corazon Cordova Gunay
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views1 page

Work Order Management Overview

The document outlines a database schema for managing work tasks, work orders, customers, and related entities. It includes details such as work task attributes, status, employee and customer information, and billing details. The schema emphasizes relationships between different entities, including foreign keys and primary keys for data integrity.

Uploaded by

Corazon Cordova Gunay
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

WorkTaskDetails

WorkTaskList
PK,FK workOrderNo char(5)
PK workTask varchar (100)
Have PK,FK workTask varchar(100)
squareFeet int
actualHours int
estimatedHours int
FK status varchar(50)
dateStarted date
dateCompleted date
Status
Have
PK workTask varchar (100)

Have

WorkOrder

PK workOrderNo char(5)
FK manager char(4)
FK customer char(4)
FK workLocation varchar(255)
dateIssued date
dateRequired date
U

U
d

Address Persons

address varchar(150) personName varchar (100)


U

street varchar(150)
city varchar(50)

U
state varchar(150)
d
zipcode varchar(15)
U

Employee Customer
O
employee_ID char(4) customerNo char(4)

CustomerBilling WorkLocation

billingName varchar (100) locationName varchar (100)

Notes
Have PK,FK locationName varchar(100)

PK,FK employee_ID char(4) Have

note varchar(255)
dateIssued date
details varchar(255)
toDo varchar(150)
dateScheduled date

Billed at

You might also like