Technology operation component - pola modelowe

Pole	Typ	Model
SIMPLE	technology
id	bigint NOT NULL	technologyOperationComponent
technology_id	bigint	technologyOperationComponent
operation_id	bigint	technologyOperationComponent
parent_id	bigint	technologyOperationComponent
entitytype	character varying(255)	technologyOperationComponent
priority	integer	technologyOperationComponent
nodenumber	character varying(255)	technologyOperationComponent
comment	character varying(2048)	technologyOperationComponent
attachment	character varying(255)	technologyOperationComponent
referencetechnology_id	bigint	technologyOperationComponent
areproductquantitiesdivisible	boolean DEFAULT false	technologyOperationComponent
istjdivisible	boolean DEFAULT false	technologyOperationComponent
operationProductInComponents	HM	technologyOperationComponent
operationProductOutComponents	HM	technologyOperationComponent
Normy kosztowe	costNormsForOperations
pieceworkcost	numeric(12,5) DEFAULT 0::numeric	technologyOperationComponent
laborhourlycost	numeric(12,5) DEFAULT 0::numeric	technologyOperationComponent
machinehourlycost	numeric(12,5) DEFAULT 0::numeric	technologyOperationComponent
numberofoperations	integer DEFAULT 1	technologyOperationComponent
Genealogia	AdvGenForOrder
genealogyProductInComponents	HM	technologyOperationComponent
Zadania operacyjne
operationalTasks	HM	technologyOperationComponent
Zlecenia	orders
order_id	bigint	technologyOperationComponent
Linia produkcyjna	productionLines
quantityOfWorkstationTypes	integer	technologyOperationComponent
Przydział do zmian	productionPerShifts
progressForDays	HM	technologyOperationComponent
hasCorrections	boolean	technologyOperationComponent
Kontrola jakości	qualityControls
qualityControls	HM	technologyOperationComponent
Podwykonawstwo	techSubcontracting
isSubcontracting	boolean	technologyOperationComponent
Normy czasowe	timeNormsForOperations
tpz	integer DEFAULT 0	technologyOperationComponent
tj	integer DEFAULT 0	technologyOperationComponent
productioninonecycle	numeric(12,5) DEFAULT 1::numeric	technologyOperationComponent
nextoperationafterproducedtype	character varying(255) DEFAULT '01all'::character varying	technologyOperationComponent
nextoperationafterproducedquantity	numeric(12,5) DEFAULT 0::numeric	technologyOperationComponent
timenextoperation	integer DEFAULT 0	technologyOperationComponent
machineutilization	numeric(8,5) DEFAULT 1.0	technologyOperationComponent
laborutilization	numeric(8,5) DEFAULT 1.0	technologyOperationComponent
effectivedateto	timestamp without time zone	techOperCompTimeCalculations
effectivedatefrom	timestamp without time zone,	techOperCompTimeCalculations
effectiveoperationrealizationtime	integer	techOperCompTimeCalculations
operationoffset	integer	techOperCompTimeCalculations
productioninonecycleunit	character varying(255)	techOperCompTimeCalculations
nextoperationafterproducedquantityunit	character varying(255)	techOperCompTimeCalculations
duration	integer DEFAULT 0	techOperCompTimeCalculations
machineworktime	integer DEFAULT 0	techOperCompTimeCalculations
laborworktime	integer DEFAULT 0,	techOperCompTimeCalculations
Karty pracy	workplans
hidedescriptioninworkplans	boolean	technologyOperationComponent
hidedetailsinworkplans	boolean	technologyOperationComponent
hidetechnologyandorderinworkplans	boolean	technologyOperationComponent
imageurlinworkplan	character varying(255)	technologyOperationComponent
dontprintinputproductsinworkplans	boolean	technologyOperationComponent
dontprintoutputproductsinworkplans	boolean	technologyOperationComponent
orderOperationInputColumns	HM	technologyOperationComponent
orderOperationOutputColumns	HM	technologyOperationComponent