Versions Compared

Key

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

Model

SIMPLETechnologiatechnology   

id

bigint NOT NULLTAKTAKtechnologyOperationComponent
technology_idbigintTAKTAKtechnologyOperationComponent
operation_idbigintTAKTAKtechnologyOperationComponent
parent_idbigintTAKTAKtechnologyOperationComponent
entitytypecharacter varying(255)TAKTAKtechnologyOperationComponent
priorityintegerTAKTAKtechnologyOperationComponent
nodenumbercharacter varying(255)TAKTAKtechnologyOperationComponent
commentcharacter varying(2048)TAKTAKtechnologyOperationComponent
attachmentcharacter varying(255)TAKTAKtechnologyOperationComponent
referencetechnology_idbigintTAKNIEtechnologyOperationComponent
areproductquantitiesdivisibleboolean DEFAULT falseTAKTAKtechnologyOperationComponent
istjdivisibleboolean DEFAULT falseTAKTAKtechnologyOperationComponent
operationProductInComponentsHMTAKNIEtechnologyOperationComponent
operationProductOutComponentsHMTAKNIEtechnologyOperationComponent
Normy kosztowecostNormsForOperations   
pieceworkcostnumeric(12,5) DEFAULT 0::numericTAKTAKtechnologyOperationComponent
laborhourlycostnumeric(12,5) DEFAULT 0::numericTAKTAKtechnologyOperationComponent
machinehourlycostnumeric(12,5) DEFAULT 0::numericTAKTAKtechnologyOperationComponent
numberofoperationsinteger DEFAULT 1TAKTAKtechnologyOperationComponent
GenealogiaZaawansowana genealogiaAdvGenForOrderadvancedGenealogyForOrder   
genealogyProductInComponentsHMNIETAKtechnologyOperationComponent
Zadania operacyjne operationalTasks   
operationalTasksHMNIETAKtechOperCompOperationalTasks
Zleceniaorders   
order_idbigintNIETAKtechnologyOperationComponent
Linia produkcyjnaproductionLines   
quantityOfWorkstationTypesintegerNIETAKtechOperCompWorkstation (question)
Przydział do zmianproductionPerShiftsproductionPerShift   
progressForDaysHMNIETAKtechOperCompProgressPerShift
hasCorrectionsbooleanNIETAKtechOperCompProgressPerShift
Kontrola jakościqualityControls   
qualityControlsHMNIETAKtechOperCompQualityControls
PodwykonawstwotechSubcontracting   
isSubcontractingbooleanTAKTAKtechnologyOperationComponent
Normy czasowetimeNormsForOperations   
tpzinteger DEFAULT 0TAKTAKtechnologyOperationComponent
tjinteger DEFAULT 0TAKTAKtechnologyOperationComponent
productioninonecyclenumeric(12,5) DEFAULT 1::numericTAKTAKtechnologyOperationComponent
nextoperationafterproducedtypecharacter varying(255) DEFAULT '01all'::character varyingTAKTAKtechnologyOperationComponent
nextoperationafterproducedquantitynumeric(12,5) DEFAULT 0::numericTAKTAKtechnologyOperationComponent
timenextoperationinteger DEFAULT 0TAKTAKtechnologyOperationComponent
machineutilizationnumeric(8,5) DEFAULT 1.0TAKTAKtechnologyOperationComponent
laborutilizationnumeric(8,5) DEFAULT 1.0TAKTAKtechnologyOperationComponent
effectivedatetotimestamp without time zoneNIETAKtechOperCompTimeCalculations
effectivedatefromtimestamp without time zone,NIETAKtechOperCompTimeCalculations
effectiveoperationrealizationtimeintegerNIETAKtechOperCompTimeCalculations
operationoffsetintegerNIETAKtechOperCompTimeCalculations
productioninonecycleunitcharacter varying(255)NIETAKtechOperCompTimeCalculations
nextoperationafterproducedquantityunitcharacter varying(255)NIETAKtechOperCompTimeCalculations
durationinteger DEFAULT 0TAKTAKtechOperCompTimeCalculations
machineworktimeinteger DEFAULT 0TAKTAKtechOperCompTimeCalculations
laborworktimeinteger DEFAULT 0,TAKTAKtechOperCompTimeCalculations
Karty pracyworkplansworkPlans   
hidedescriptioninworkplansbooleanTAKTAKtechnologyOperationComponent
hidedetailsinworkplansbooleanTAKTAKtechnologyOperationComponent
hidetechnologyandorderinworkplansbooleanTAKTAKtechnologyOperationComponent
imageurlinworkplancharacter varying(255)TAKTAKtechnologyOperationComponent
dontprintinputproductsinworkplansbooleanTAKTAKtechnologyOperationComponent
dontprintoutputproductsinworkplansbooleanTAKTAKtechnologyOperationComponent
orderOperationInputColumnsHMNIETAKtechnologyOperationComponent
orderOperationOutputColumnsHMNIETAKtechnologyOperationComponent
technologyOperationInputColumnsHMTAKNIE 
technologyOperationOutputColumnsHMTAKNIE