Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
           
PoleTypPluginTOCTIOC

Model

SIMPLETechnologiatechnology   

id

  qualitycontrolrequired boolean,

bigint NOT NULLTAKTAK technologyOperationComponent
technology_idbigint TAKTAK technologyOperationComponent
operation_idbigintTAKTAK technologyOperationComponent
parent_idbigintTAKTAK technologyOperationComponent
entitytypecharacter varying(255)TAKTAK technologyOperationComponent
priorityinteger TAKTAK technologyOperationComponent
nodenumbercharacter varying(255)TAKTAK technologyOperationComponent
commentcharacter varying(2048)TAKTAK technologyOperationComponent
attachmentcharacter varying(255)TAKTAK technologyOperationComponent
referencetechnology_idbigintTAKNIE technologyOperationComponent
areproductquantitiesdivisibleboolean DEFAULT falseTAKTAK technologyOperationComponent
istjdivisibleboolean DEFAULT false TAKTAK technologyOperationComponent
operationProductInComponentsHM TAKNIE technologyOperationComponent
operationProductOutComponentsHM TAKNIE technologyOperationComponent
Normy kosztowecostNormsForOperations   
pieceworkcostnumeric(12,5) DEFAULT 0::numericTAKTAK technologyOperationComponent
laborhourlycostnumeric(12,5) DEFAULT 0::numericTAKTAK technologyOperationComponent
machinehourlycostnumeric(12,5) DEFAULT 0::numeric TAKTAK technologyOperationComponent
numberofoperationsinteger DEFAULT 1TAKTAK technologyOperationComponent 
Zaawansowana genealogiaGenealogiaadvancedGenealogyForOrderAdvGenForOrder   
genealogyProductInComponentsHMNIE TAK technologyOperationComponent
Zadania operacyjneoperationalTasks   
operationalTasksHM NIETAK techOperCompOperationalTasks
Zleceniaorders   
order_idbigintNIE TAK technologyOperationComponent
Linia produkcyjnaproductionLines   
quantityOfWorkstationTypesinteger  NIETAKtechOperCompWorkstation (question)
Przydział do zmianproductionPerShiftsproductionPerShift   
progressForDaysHM NIETAK techOperCompProgressPerShift
hasCorrectionsbooleanNIE TAK techOperCompProgressPerShift
Kontrola jakościqualityControls   
qualityControlsHM NIETAK techOperCompQualityControls
PodwykonawstwotechSubcontracting   
isSubcontractingbooleanTAK TAK technologyOperationComponent
Normy czasowetimeNormsForOperations   
tpzinteger DEFAULT 0 TAKTAK technologyOperationComponent
tjinteger DEFAULT 0 TAKTAK technologyOperationComponent
productioninonecyclenumeric(12,5) DEFAULT 1::numericTAK TAK technologyOperationComponent
nextoperationafterproducedtypecharacter varying(255) DEFAULT '01all'::character varyingTAK TAK technologyOperationComponent
nextoperationafterproducedquantitynumeric(12,5) DEFAULT 0::numericTAK TAK technologyOperationComponent
timenextoperationinteger DEFAULT 0 TAKTAK technologyOperationComponent
machineutilizationnumeric(8,5) DEFAULT 1.0TAK TAK technologyOperationComponent
laborutilizationnumeric(8,5) DEFAULT 1.0TAK TAK technologyOperationComponent
effectivedatetotimestamp without time zoneNIE TAK techOperCompTimeCalculations
effectivedatefromtimestamp without time zone, NIETAK techOperCompTimeCalculations
effectiveoperationrealizationtimeintegerNIE TAK techOperCompTimeCalculations
operationoffsetintegerNIE TAK techOperCompTimeCalculations
productioninonecycleunitcharacter varying(255) NIETAK techOperCompTimeCalculations
nextoperationafterproducedquantityunitcharacter varying(255)NIE TAK techOperCompTimeCalculations
durationinteger DEFAULT 0TAK TAK techOperCompTimeCalculations
machineworktimeinteger DEFAULT 0 TAKTAK techOperCompTimeCalculations
laborworktimeinteger DEFAULT 0, TAKTAK techOperCompTimeCalculations
Karty pracyworkPlansworkplans   
hidedescriptioninworkplansbooleanTAK TAK technologyOperationComponent
hidedetailsinworkplansboolean TAKTAK technologyOperationComponent
hidetechnologyandorderinworkplansboolean TAKTAK technologyOperationComponent
imageurlinworkplancharacter varying(255) TAKTAK technologyOperationComponent
dontprintinputproductsinworkplansbooleanTAK TAK technologyOperationComponent
dontprintoutputproductsinworkplansboolean TAKTAK technologyOperationComponent
orderOperationInputColumnsHM NIETAK technologyOperationComponent
orderOperationOutputColumnsHM    NIETAKtechnologyOperationComponent
technologyOperationInputColumnsHMTAKNIE  
technologyOperationOutputColumns HM TAK NIE