
-- companies --
01 - **Cyberdyne Systems** – Das Unternehmen aus *Terminator*, das die künstliche Intelligenz Skynet entwickelt.
01 - **Cyberdyne Systems** – Sunnyvale, California.

02 - **LexCorp** – Das Unternehmen von Lex Luthor aus der *Superman*-Reihe.
02 - **LexCorp** – Metropolis (fictional city), specifically New Troy.

03 - **Omni Consumer Products (OCP)** – Die Megafirma aus *RoboCop*, die an kybernetischen Polizeieinheiten arbeitet.
03 - **Omni Consumer Products (OCP)** – Detroit, Michigan.

04 - **Weyland-Yutani Corporation** – Die skrupellose Firma aus der *Alien*-Reihe, die gefährliche außerirdische Wesen für Profit nutzen will.
04 - **Weyland-Yutani Corporation** – London, Tokyo, San Francisco, Sea of Tranquillity (Moon), and Thedus.

05 - **Lunar Industries** – Die Firma aus *Moon*, die Helium-3 auf dem Mond abbaut.
05 - 6. **Lunar Industries** – Warrendale, Pennsylvania.

99 - **Stark Industries** – Die Firma aus den *Iron Man*- und *Avengers*-Filmen, die fortschrittliche Technologie und Waffen produziert.
99 - **Stark Industries** – Los Angeles, California.

-- partners --
000 **Magneto** (*X-Men: The Animated Series*) – The powerful mutant with a complex ideology.
100 **The Joker** (*Batman: The Animated Series*) – Gotham’s chaotic clown prince of crime.
200 **Dr. Robotnik (Eggman)** (*Sonic the Hedgehog*) – The genius scientist with a passion for robotic domination.
300 **Bill Cipher** (*Gravity Falls*) – A chaotic dream demon with reality-warping powers.
400 **Lex Luther** (*Superman*) 
--

Custom data Database for training 
#1 - niota_ferengi

Metadata Database for training 
#1 - niota_meta_ed01 / _ed02 / _ed03 / _ed04 / _ed05

Tables for working hours	
Nr.	Catalog ID    	physical name															
==============================================================================================================			
#1  90010			partner 			- Partners 					- LookUp Table/Config data 
#2  90020 			product				- Products					- LookUp Table/Config data
#3  90030			project 			- Projects					- LookUp Table/Config data
#5  90040			project_role		- Project Role				- Relationship Table
#2  90050			project_type		- Project Types				- LookUp Table/Config data
#5  90060 			work 				- Working Hours				- Transaction data			
#7  90070			work_history		- Working Hours History		- Transaction data / History


LookUp  		on Object		Instance		LookUp columns						
=========================================================================
PROJECTTYPE		project_type	LOOKUP			PRJTID, PRJTYPE_NAME				
PARTNER			partner 		LOOKUP			PTNRID, NAME						
PRODUKT 		product			LOOKUP			PRDID, PRD_NAME		
PROJECT			project			LOOKUP			PRJID, PRJ_NAME						


use LookUp 				LookUp				allow null
============================================================
project.PRJTID			PROJECTTYPE				X
project_role.PRJID		PROJECT
work.PRJID				PROJECT
work.PTNRID				PARTNER


special columns

table  		columns			
============================================================
project		WORKID			auto increment
project		INSERTTS		default - not edittable
project		MODIFYTS		default - not edittable
project		LOCKED			default - editable in niota


special tables/views
============================================================
work_history				display only in niota

