CASE Studio 2 - HTML Report

Contract Equipment (Contract Equipment)

General info

Relationship type	informative	Cardinality	1:N
Parent table	CONTRACT
Child table	CUST_EQUIPMENT

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
Contract_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Contract Notes (Contract Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	CONTRACT
Child table	CONTRACT_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Contract_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Contract Tax (Contract Tax)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	CONTRACT
Child table	CONTRACT_TAX

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Contract_No	Contract_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Cust Equip Notes (Cust Equip Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	CUST_EQUIPMENT
Child table	CUST_EQUIPMENT_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Customer	???
Address_ID	???
Model_ID	???
Serial_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Cust Equip tax (Cust Equip tax)

General info

Relationship type	informative	Cardinality	1:N
Parent table	CUST_EQUIPMENT
Child table	CONTRACT_TAX

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Customer	???
Address_ID	???
Model_ID	???
Serial_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Equipment Meters (Equipment Meters)

General info

Relationship type	informative	Cardinality	1:N
Parent table	CUST_EQUIPMENT
Child table	CUST_EQUIPMENT_METERS

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Customer	???
Address_ID	???
Model_ID	???
Serial_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History Contract Equipment (History Contract Equipment)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_CONTRACT
Child table	HISTORY_CUST_EQUIPMENT

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Contract_No	Contract_No
Contract_Seq_No	Contract_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History Contract Notes (History Contract Notes)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_CONTRACT
Child table	HISTORY_CONTRACT_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Contract_No	Contract_No
Contract_Seq_No	Contract_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History Contract Tax (History Contract Tax)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_CONTRACT
Child table	HISTORY_CONTRACT_TAX

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Contract_No	Contract_No
Contract_Seq_No	Contract_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History Cust Eqip Tax (History Cust Eqip Tax)

General info

Relationship type	informative	Cardinality	1:N
Parent table	HISTORY_CUST_EQUIPMENT
Child table	HISTORY_CONTRACT_TAX

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Customer	???
Contract_No	???
Contract_Seq_No	???
Address_ID	???
Model_ID	???
Serial_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History WO Labor Notes (History WO Labor Notes)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_WO_LABOR
Child table	HISTORY_WO_LABOR_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Work_Order_Seq_No	Work_Order_Seq_No
Task_Seq_No	Task_Seq_No
Lbr_Seq_No	Lbr_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History WO Parts Grid (History WO Parts Grid)

General info

Relationship type	informative	Cardinality	1:N
Parent table	HISTORY_WO_PARTS_GRID_CELL
Child table	HISTORY_WO_PARTS

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???
Work_Order_Seq_No	???
Task_Seq_No	???
Pts_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History WO Parts Serials (History WO Parts Serials)

General info

Relationship type	informative	Cardinality	1:N
Parent table	HISTORY_WO_PARTS
Child table	HISTORY_WO_PARTS_SERIALS

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???
Work_Order_Seq_No	???
Task_Seq_No	???
Pts_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History WO Task Addl Chg (History WO Task Addl Chg)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_WO_TASK
Child table	HISTORY_WO_ADDL_CHG

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Work_Order_Seq_No	Work_Order_Seq_No
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History WO Task Labor (History WO Task Labor)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_WO_TASK
Child table	HISTORY_WO_LABOR

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Work_Order_Seq_No	Work_Order_Seq_No
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History WO Task Notes (History WO Task Notes)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_WO_TASK
Child table	HISTORY_WO_TASK_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Work_Order_Seq_No	Work_Order_Seq_No
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History WO Task Parts (History WO Task Parts)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_WO_TASK
Child table	HISTORY_WO_PARTS

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Work_Order_Seq_No	Work_Order_Seq_No
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

History Work Order Task (History Work Order Task)

General info

Relationship type	informative	Cardinality	1:N
Parent table	HISTORY_WORK_ORDER
Child table	HISTORY_WO_TASK

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???
Work_Order_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Model Notes (Model Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	EQP_MODEL
Child table	SETUP_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
Model_ID	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

PJ Labor Notes (PJ Labor Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	PREDEF_JOB_LABOR
Child table	PREDEF_JOB_LABOR_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Job_ID	???
Task_Seq_No	???
Lbr_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

PJ Task Addl Chg (PJ Task Addl Chg)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	PREDEF_JOB_TASK
Child table	PREDEF_JOB_ADDL_CHG

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Job_ID	Job_ID
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

PJ Task Labor (PJ Task Labor)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	PREDEF_JOB_TASK
Child table	PREDEF_JOB_LABOR

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Job_ID	Job_ID
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

PJ Task Notes (PJ Task Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	PREDEF_JOB_TASK
Child table	PREDEF_JOB_TASK_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Job_ID	???
Task_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

PJ Task Parts (PJ Task Parts)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	PREDEF_JOB_TASK
Child table	PREDEF_JOB_PARTS

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Job_ID	Job_ID
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Predef Job Notes (Predef Job Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	PREDEF_JOB
Child table	PREDEF_JOB_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Job_ID	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Predef Job Task (Predef Job Task)

General info

Relationship type	informative	Cardinality	1:N
Parent table	PREDEF_JOB
Child table	PREDEF_JOB_TASK

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Job_ID	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Svc Address Notes (Svc Address Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	SVC_ADDRESS
Child table	SVC_ADDRESS_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Customer	???
Address_ID	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

Tech notes (Tech notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	SVC_TECH
Child table	SETUP_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
Tech_ID	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO History Notes (WO History Notes)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_WORK_ORDER
Child table	HISTORY_WO_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Work_Order_Seq_No	Work_Order_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO History Payment (WO History Payment)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_WORK_ORDER
Child table	HISTORY_WO_PMNT

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Work_Order_Seq_No	Work_Order_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO History Tax (WO History Tax)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	HISTORY_WORK_ORDER
Child table	HISTORY_WO_TAX

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Work_Order_Seq_No	Work_Order_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO Parts Grid (WO Parts Grid)

General info

Relationship type	informative	Cardinality	1:N
Parent table	WO_PARTS
Child table	WO_PARTS_GRID_CELL

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???
Task_Seq_No	???
Pts_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO Parts Serials (WO Parts Serials)

General info

Relationship type	informative	Cardinality	1:N
Parent table	WO_PARTS
Child table	WO_PARTS_SERIALS

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???
Task_Seq_No	???
Pts_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO Task Addl Chg (WO Task Addl Chg)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	WO_TASK
Child table	WO_ADDL_CHG

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO Task Labor (WO Task Labor)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	WO_TASK
Child table	WO_LABOR

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO Task Notes (WO Task Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	WO_TASK
Child table	WO_TASK_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???
Task_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO Task Parts (WO Task Parts)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	WO_TASK
Child table	WO_PARTS

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No
Task_Seq_No	Task_Seq_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO Tax (WO Tax)

General info

Relationship type	identifying	Cardinality	1:N
Parent table	WORK_ORDER
Child table	WO_TAX

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	Work_Order_No

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO_LABOR_NOTES_FK (WO Labor Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	WO_LABOR
Child table	WO_LABOR_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???
Task_Seq_No	???
Lbr_Seq_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO_NOTES_FK (WO Notes)

General info

Relationship type	informative	Cardinality	1:N
Parent table	WORK_ORDER
Child table	WO_NOTES

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO_PMNT_FK (WO Payment)

General info

Relationship type	informative	Cardinality	1:N
Parent table	WORK_ORDER
Child table	WO_PMNT

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No

WO_TASK_FK (WO Task)

General info

Relationship type	informative	Cardinality	1:N
Parent table	WORK_ORDER
Child table	WO_TASK

Referential integrity

	Insert	Update	Delete
Parent	----	CASCADE	CASCADE
Child	NONE	NONE	----

Keys

Parent key	Child key
Work_Order_No	???

User-defined variables

Name	Value
Not for replication	No
Disabled foreign key constraint	No