Technology operation component - pola modelowe

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