Please enable JavaScript.
Coggle requires JavaScript to display documents.
Joe's Chops (Billing(Entity) (PlanID, BillStreet, BillingID, BillState…
Joe's Chops
Billing(Entity)
PlanID
BillStreet
BillingID
BillState
BillZip
BillDescription
BillOverhead
BillTax
BillFinDate
BillPayMthd
BillPayDate
BillTotal
LbrID
Vehicle(Entity)
VIN
VMake
VModel
VYear
VEngine
VTrim
VInt
VExt
VBdyCondition
VFrmConditon
VEngCondition
VIntCondition
Customer(Entity)
CustomerID
CustEmail
CustPhone
CustLName
CustFName
CustStreet
CustCity
CustState
CustZip
Customization Plan(Entity)
PlanID
CustomerID
EmployeeID
VIN
PlanEstPrice
PlanDeposit
PlanStart
PlanEstDelivery
PlanEmployee (Labor Relationship)
PlanID
EmployeeID
LbrTask
LbrAmount
LbrCost
Moved {Stage (Might be its own entity)}
LbrTIme
LaborID
PlanItems(Relationship)
Plan ID
EmployeeID
PlanItemsID
PlnItmsPrtLbrCostEst
PlnItmsSpecializedItem
PlnItmItemDaysEst
PlnItmsItemsCostEst
PlnItmsItemDescription
Employee(Entity)
EmpoyeeID
EmpFName
EmpLName
EmpTitle
EmpPhone
EmpEmail
PlanParts(Relationship)
PlanPartsID
PlanID
PrtPrice
PrtQuantity
Stage
Item(Entity) (Unsure if needed)
PrtID
ItmPrice
ItmQuanitity
ItmName
ItemID
Stage(Entity)
StageType
PartID
LaborID
StgTime
StgCost
Part(Entity)
PartID
PrtName
ManufacturerID
PrtCost
Photos(Entity)
PhotoDate
PlanID
PhotoLink
PhotoID
Customized Site (E)
SiteID
PlanID
PhotoID
CriticalQuestionID
Critical Question(Entity)
CritQDate
CritQNum
CritQAnswer
CriticalQuestionID
PlanBill (Costs Relationship)
PlanID
BillingID
Vendor(Entity)
VendorID
VendName
Manufacturer(Entity)
ManufacturerID
ManuName
Produces (Relationship)
PartID
ManufacturerID
Sold by(Relationship)
PartID
VendorID