{
	"name": "auth/connection.json",
	"info": "see: table/db_connection_preference.json",
	"table_database": {
		"mms_manufactured_articles": "fastems",
		"mms_order_view": "fastems",
		"mms_storage_view": "fastems",
		"nomet_machine_data": "fastems",
		"nomet_machine_preferece": "fastems",
		"orders_from_pps": "fastems",
		"syntax_error_orders": "fastems",
		"jyu_ccc_keyword": "jyu_ccc",
		"jyu_ccc_media": "jyu_ccc",
		"bugzilla51": "bugzilla51"
	},
	"redirect": {
		"default": [
			{
				"table": "product_lot",
				"record_type": "",
				"organization_id": "demo-fi_demo2-0"
			},
			{
				"table": "person",
				"record_type": "user",
				"organization_id": "demo-fi_demo2-0"
			},
			{
				"table": "preference",
				"organization_id": "demo-fi_demo2-0"
			},
			{
				"table": "timecard",
				"organization_id": "demo-fi_demo2-0"
			},
			{
				"table": "sequence_number",
				"organization_id": "demo-fi_demo2-0"
			},
			{
				"table": "session",
				"organization_id": "demo-fi_demo2-0"
			},
			{
				"table": "task",
				"organization_id": "demo-fi_demo2-0"
			},
			{
				"table": "task_work",
				"organization_id": "demo-fi_demo2-0"
			}
		],
		"nova": [
			{
				"table": "company",
				"record_type": "customer",
				"organization_id": "demo-nova-0"
			}
		],
		"aj-mes": [
			{
				"table": "company",
				"record_type": "customer",
				"organization_id": "demo-aj-mes-0"
			}
		],
		"moloni": [
			{
				"table": "company",
				"record_type": "customer",
				"organization_id": "demo-moloni-0"
			},
			{
				"table": "product",
				"record_type": "product",
				"organization_id": "demo-moloni-0"
			},
			{
				"table": "order",
				"record_type": "sales",
				"organization_id": "demo-moloni-0"
			},
			{
				"table": "order_row",
				"record_type": "sales",
				"organization_id": "demo-moloni-0"
			}
		],
		"woocommerce": [
			{
				"table": "company",
				"record_type": "customer",
				"organization_id": "demo-woocommerce-0"
			},
			{
				"table": "product",
				"record_type": "product",
				"organization_id": "demo-woocommerce-0"
			},
			{
				"table": "order",
				"record_type": "sales",
				"organization_id": "demo-woocommerce-0"
			},
			{
				"table": "order_row",
				"record_type": "sales",
				"organization_id": "demo-woocommerce-0"
			}
		],
		"4d": [
			{
				"table": "stock_event",
				"record_type": "",
				"organization_id": "demo-fi_demo4d-0"
			},
			{
				"table": "travel_expense",
				"record_type": "",
				"organization_id": "demo-fi_demo4d-0"
			},
			{
				"table": "driving_log",
				"record_type": "",
				"organization_id": "demo-fi_demo4d-0"
			},
			{
				"table": "currency_rate",
				"record_type": "",
				"organization_id": "demo-fi_demo4d-0"
			},
			{
				"table": "capacity",
				"record_type": "capacity",
				"organization_id": "demo-fi_demo4d-0"
			},
			{
				"table": "capacity",
				"record_type": "capacity_row",
				"organization_id": "demo-fi_demo4d-0"
			},
			{
				"table": "capacity",
				"record_type": "resource",
				"organization_id": "demo-fi_demo4d-0"
			},
			{
				"table": "resource_effeciency",
				"record_type": "",
				"organization_id": "demo-fi_demo4d-0"
			},
			{
				"table": "timecard",
				"record_type": "",
				"organization_id": "demo-fi_demo2-0"
			}
		]
	},
	"database": {
		"plg4d": {
			"connection": "plg4d",
			"schema": "4d"
		},
		"4d": {
			"connection": "rest4d",
			"schema": "4d"
		},
		"4dX": {
			"connection": "postgre-demo4d",
			"schema": "4d",
			"database": "fi_demo4d"
		},
		"fi_demo4d": {
			"connection": "postgre-demo4d",
			"schema": "4d"
		},
		"fi_demo2": {
			"connection": "postgre-demo2",
			"schema": ""
		},
		"fi_manageapp": {
			"connection": "manageri.fi",
			"schema": ""
		},
		"fi_maping": {
			"connection": "manageri.fi",
			"schema": ""
		},
		"bugzilla51": {
			"connection": "manageri.fi",
			"schema": "bugzilla51"
		},
		"moloni": {
			"connection": "rest-moloni",
			"schema": "moloni"
		},
		"woocommerce": {
			"connection": "rest-woocommerce",
			"schema": "woocommerce"
		},
		"nova": {
			"connection": "odbc-nova",
			"schema": "nova"
		},
		"aj-mes": {
			"connection": "odbc-aj-mes",
			"schema": "aj-mes"
		},
		"fastems": {
			"connection": "odbc",
			"schema": "fastems"
		},
		"jyu_ccc": {
			"connection": "postgre-jyu",
			"schema": "jyu_ccc"
		}
	},
	"organization_id": [
		{
			"show": "plg4d",
			"name": "plg4d",
			"status": "active",
			"database": [
				{
					"show": " plugin 4d",
					"status": "inactive",
					"database": "plg4d",
					"organization_number": 0,
					"redirect": ["default"],
					"organization_text": "0"
				}
			]
		},
		{
			"show": "Demo",
			"name": "demo",
			"status": "active",
			"allowed_database": [
				{
					"fi_demo": true
				},
				{
					"fi_demo4d": true
				},
				{
					"fi_demo2": true
				},
				{
					"4d": true
				},
				{
					"bugzilla51": true
				},
				{
					"fastems": true
				},
				{
					"moloni": true
				},
				{
					"woocommerce": true
				},
				{
					"nova": true
				},
				{
					"aj-mes": true
				},
				{
					"jyu_ccc": true
				}
			],
			"database": [
				{
					"show": " 4D",
					"database": "4d",
					"status": "active",
					"organization_number": 0,
					"redirect": ["default", "4d"],
					"organization_text": "demo"
				},
				{
					"show": " Postgres 4D",
					"database": "fi_demo4d",
					"status": "active",
					"organization_number": 0,
					"redirect": ["default"],
					"organization_text": "demo"
				},
				{
					"show": " Postgres new",
					"database": "fi_demo2",
					"status": "active",
					"organization_number": 0,
					"redirect": [""],
					"organization_text": "demo"
				},
				{
					"show": " Nova",
					"status": "inactive",
					"database": "nova",
					"organization_number": 0,
					"redirect": ["nova", "default"],
					"organization_text": "nova"
				},
				{
					"show": " AJ-MES",
					"status": "inactive",
					"database": "aj-mes",
					"organization_number": 0,
					"redirect": ["aj-mes", "default"],
					"organization_text": "aj-mes"
				},
				{
					"show": " Moloni",
					"status": "inactive",
					"database": "moloni",
					"organization_number": 0,
					"redirect": ["moloni", "default"],
					"organization_text": "moloni"
				},
				{
					"show": " Woocommerce",
					"status": "inactive",
					"database": "woocommerce",
					"organization_number": 0,
					"redirect": ["woocommerce", "default"],
					"organization_text": "woocommerce"
				},
				{
					"show": " Fastems",
					"status": "inactive",
					"database": "fastems",
					"organization_number": 0,
					"redirect": ["fastems"],
					"organization_text": "demo"
				}
			]
		},
		{
			"show": "Internal test",
			"name": "manage",
			"status": "inactive",
			"allowed_database": [
				{
					"fi_manageapp": true
				},
				{
					"4d": true
				},
				{
					"bugzilla51": true
				}
			],
			"database": [
				{
					"show": ", Manage",
					"database": "fi_manageapp",
					"status": "active",
					"organization_number": 1,
					"redirect": [""],
					"organization_text": "manage"
				},
				{
					"show": ", Manage 4D",
					"database": "4d",
					"status": "active",
					"organization_number": 1,
					"redirect": ["default"],
					"organization_text": "manage"
				},
				{
					"show": ", a - 2",
					"database": "fi_manageapp",
					"status": "inactive",
					"organization_number": 2,
					"redirect": [""],
					"organization_text": "arto"
				},
				{
					"show": ", pasi - 3",
					"database": "fi_manageapp",
					"status": "active",
					"organization_number": 3,
					"redirect": [""],
					"organization_text": "pasi"
				},
				{
					"show": ", bet - 4",
					"database": "fi_manageapp",
					"status": "inactive",
					"organization_number": 4,
					"redirect": [""],
					"organization_text": "bet"
				},
				{
					"show": ", Manage 0",
					"database": "fi_manageapp",
					"status": "active",
					"organization_number": 0,
					"redirect": [""],
					"organization_text": "manage"
				}
			]
		},
		{
			"show": "Maping",
			"name": "maping",
			"status": "inactive",
			"allowed_database": [
				{
					"fi_maping": true
				}
			],
			"database": [
				{
					"show": "",
					"database": "fi_maping",
					"status": "active",
					"organization_number": 0,
					"redirect": [""],
					"organization_text": "maping"
				}
			]
		}
	],
	"not_in_use": [
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 14,
			"organization_text": "biopankki",
			"show": "Biopankki (14)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 6,
			"organization_text": "fall",
			"show": "Farmakologia, lääkekehitys ja lääkehoito (6)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 16,
			"organization_text": "fff",
			"show": "Funktionaalisten elintarvikkeiden kehittämiskeskus (16)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 7,
			"organization_text": "fyso",
			"show": "Fysiologia (7)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 20,
			"organization_text": "hammas",
			"show": "Hammaslääketieteen laitos (20)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 11,
			"organization_text": "laskut",
			"show": "Hankintapalvelut (11)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 19,
			"organization_text": "hoito",
			"show": "Hoitotieteen laitos (19)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 18,
			"organization_text": "kliininen",
			"show": "Kliininen laitos (18)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 17,
			"organization_text": "kek",
			"show": "Koe-eläinkeskus (17)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 4,
			"organization_text": "lbkg",
			"show": "Lääketieteellinen biokemia ja genetiikka (4)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 2,
			"organization_text": "lmim",
			"show": "Lääketieteellinen mikrobiologia ja immunologia (2)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 9,
			"organization_text": "laak_tdk",
			"show": "Lääketieteellinen tiedekunta (9)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 12,
			"organization_text": "medicity",
			"show": "MediCity (12)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 8,
			"organization_text": "pato_oikl",
			"show": "Patologia ja Oikeuslääketiede (8)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 5,
			"organization_text": "anat",
			"show": "Solubiologia ja anatomia (5)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 13,
			"organization_text": "sydan",
			"show": "Sydäntutkimuskeskus (13)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 10,
			"organization_text": "talous",
			"show": "Talouspalvelut (10)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 3,
			"organization_text": "thl",
			"show": "Terveyden Ja Hyvinvoinnin Laitos (3)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 15,
			"organization_text": "cyri",
			"show": "Turun lapsi- ja nuorisotutkimuskeskus CYRI (15)"
		},
		{
			"database": "fi_univ_turku",
			"status": "inactive",
			"organization_number": 1,
			"organization_text": "virus",
			"show": "Virusoppi (1)"
		},
		{
			"database": "fi_nomet",
			"status": "inactive",
			"organization_number": 0,
			"organization_text": "nomet",
			"show": "Internal test n"
		},
		{
			"database": "fi_sop_metal",
			"status": "inactive",
			"organization_number": 0,
			"organization_text": "sop_metal",
			"show": "Internal test s"
		},
		{
			"database": "fi_va_varuste",
			"status": "inactive",
			"organization_number": 0,
			"organization_text": "va_varuste",
			"show": "Internal test v"
		},
		{
			"database": "fi_ferrum_steel",
			"status": "inactive",
			"organization_number": 1,
			"organization_text": "ferrum_steel",
			"show": "Internal test f"
		},
		{
			"database": "fi_ferrum_steel",
			"status": "inactive",
			"organization_number": 0,
			"organization_text": "ferrum",
			"show": "Internal test f-0"
		}
	]
}
