tables.md

1. Computer firm

1.1 Product

maker	model	type
B	1121	PC
A	1232	PC
A	1233	PC
E	1260	PC
A	1276	Printer
D	1288	Printer
A	1298	Laptop
C	1321	Laptop
A	1401	Printer
A	1408	Printer
D	1433	Printer
E	1434	Printer
B	1750	Laptop
A	1752	Laptop
E	2112	PC
E	2113	PC

1.2 PC

code	model	speed	ram	hd	cd	price
1	1232	500	64	5.0	12x	600.0000
2	1121	750	128	14.0	40x	850.0000
3	1233	500	64	5.0	12x	600.0000
4	1121	600	128	14.0	40x	850.0000
5	1121	600	128	8.0	40x	850.0000
6	1233	750	128	20.0	50x	950.0000
7	1232	500	32	10.0	12x	400.0000
8	1232	450	64	8.0	24x	350.0000
9	1232	450	32	10.0	24x	350.0000
10	1260	500	32	10.0	12x	350.0000
11	1233	900	128	40.0	40x	980.0000
12	1233	800	128	20.0	50x	970.0000

1.3 Laptop

code	model	speed	ram	hd	price	screen
1	1298	350	32	4.0	700.0000	11
2	1321	500	64	8.0	970.0000	12
3	1750	750	128	12.0	1200.0000	14
4	1298	600	64	10.0	1050.0000	15
5	1752	750	128	10.0	1150.0000	14
6	1298	450	64	10.0	950.0000	12

1.4 Printer

code	model	color	type	price
6	1288	n	Laser	400.0000
5	1408	n	Matrix	270.0000
4	1401	n	Matrix	150.0000
3	1434	y	Jet	290.0000
2	1433	y	Jet	270.0000
1	1276	n	Laser	400.0000

2. Recycling firm

2.1 Income

code	point	date	inc
1	1	2001-03-22 00:00:00.000	15000.0000
2	1	2001-03-23 00:00:00.000	15000.0000
3	1	2001-03-24 00:00:00.000	3600.0000
4	2	2001-03-22 00:00:00.000	10000.0000
5	2	2001-03-24 00:00:00.000	1500.0000
6	1	2001-04-13 00:00:00.000	5000.0000
7	1	2001-05-11 00:00:00.000	4500.0000
8	1	2001-03-22 00:00:00.000	15000.0000
9	2	2001-03-24 00:00:00.000	1500.0000
10	1	2001-04-13 00:00:00.000	5000.0000
11	1	2001-03-24 00:00:00.000	3400.0000
12	3	2001-09-13 00:00:00.000	1350.0000
13	3	2001-09-13 00:00:00.000	1750.0000

2.2 Income_o

point	date	inc
1	2001-03-22 00:00:00.000	15000.0000
1	2001-03-23 00:00:00.000	15000.0000
1	2001-03-24 00:00:00.000	3400.0000
1	2001-04-13 00:00:00.000	5000.0000
1	2001-05-11 00:00:00.000	4500.0000
2	2001-03-22 00:00:00.000	10000.0000
2	2001-03-24 00:00:00.000	1500.0000
3	2001-09-13 00:00:00.000	11500.0000
3	2001-10-02 00:00:00.000	18000.0000

2.3 Outcome

code	point	date	out
1	1	2001-03-14 00:00:00.000	15348.0000
2	1	2001-03-24 00:00:00.000	3663.0000
3	1	2001-03-26 00:00:00.000	1221.0000
4	1	2001-03-28 00:00:00.000	2075.0000
5	1	2001-03-29 00:00:00.000	2004.0000
6	1	2001-04-11 00:00:00.000	3195.0400
7	1	2001-04-13 00:00:00.000	4490.0000
8	1	2001-04-27 00:00:00.000	3110.0000
9	1	2001-05-11 00:00:00.000	2530.0000
10	2	2001-03-22 00:00:00.000	1440.0000
11	2	2001-03-29 00:00:00.000	7848.0000
12	2	2001-04-02 00:00:00.000	2040.0000
13	1	2001-03-24 00:00:00.000	3500.0000
14	2	2001-03-22 00:00:00.000	1440.0000
15	1	2001-03-29 00:00:00.000	2006.0000
16	3	2001-09-13 00:00:00.000	1200.0000
17	3	2001-09-13 00:00:00.000	1500.0000
18	3	2001-09-14 00:00:00.000	1150.0000

2.4 Outcome_o

point	date	out
1	2001-03-14 00:00:00.000	15348.0000
1	2001-03-24 00:00:00.000	3663.0000
1	2001-03-26 00:00:00.000	1221.0000
1	2001-03-28 00:00:00.000	2075.0000
1	2001-03-29 00:00:00.000	2004.0000
1	2001-04-11 00:00:00.000	3195.0400
1	2001-04-13 00:00:00.000	4490.0000
1	2001-04-27 00:00:00.000	3110.0000
1	2001-05-11 00:00:00.000	2530.0000
2	2001-03-22 00:00:00.000	1440.0000
2	2001-03-29 00:00:00.000	7848.0000
2	2001-04-02 00:00:00.000	2040.0000
3	2001-09-13 00:00:00.000	1500.0000
3	2001-09-14 00:00:00.000	2300.0000
3	2002-09-16 00:00:00.000	2150.0000

3. Ships

3.1 Classes

class	type	country	numGuns	bore	displacement
Bismarck	bb	Germany	8	15.0	42000
Iowa	bb	USA	9	16.0	46000
Kongo	bc	Japan	8	14.0	32000
North Carolina	bb	USA	12	16.0	37000
Renown	bc	Gt.Britain	6	15.0	32000
Revenge	bb	Gt.Britain	8	15.0	29000
Tennessee	bb	USA	12	14.0	32000
Yamato	bb	Japan	9	18.0	65000

3.2 Ships

name	class	launched
California	Tennessee	1921
Haruna	Kongo	1916
Hiei	Kongo	1914
Iowa	Iowa	1943
Kirishima	Kongo	1915
Kongo	Kongo	1913
Missouri	Iowa	1944
Musashi	Yamato	1942
New Jersey	Iowa	1943
North Carolina	North Carolina	1941
Ramillies	Revenge	1917
Renown	Renown	1916
Repulse	Renown	1916
Resolution	Renown	1916
Revenge	Revenge	1916
Royal Oak	Revenge	1916
Royal Sovereign	Revenge	1916
South Dakota	North Carolina	1941
Tennessee	Tennessee	1920
Washington	North Carolina	1941
Wisconsin	Iowa	1944
Yamato	Yamato	1941

3.3 Outcomes

ship	battle	result
Bismarck	North Atlantic	sunk
California	Guadalcanal	damaged
CAlifornia	Surigao Strait	ok
Duke of York	North Cape	ok
Fuso	Surigao Strait	sunk
Hood	North Atlantic	sunk
King George V	North Atlantic	ok
Kirishima	Guadalcanal	sunk
Prince of Wales	North Atlantic	damaged
Rodney	North Atlantic	OK
Schamhorst	North Cape	sunk
South Dakota	Guadalcanal	damaged
Tennessee	Surigao Strait	ok
Washington	Guadalcanal	ok
West Virginia	Surigao Strait	ok
Yamashiro	Surigao Strait	sunk

3.4 Battles

name	date
#Cuba62a	1962-10-20 00:00:00.000
#Cuba62b	1962-10-25 00:00:00.000
Guadalcanal	1942-11-15 00:00:00.000
North Atlantic	1941-05-25 00:00:00.000
North Cape	1943-12-26 00:00:00.000
Surigao Strait	1944-10-25 00:00:00.000

4. Airport

4.1 Company

ID_comp	name
1	Don_avia
2	Aeroflot
3	Dale_avia
4	air_France
5	British_AW

4.2 Trip

trip_no	ID_comp	plane	town_from	town_to	time_out	time_in
1100	4	Boeing	Rostov	Paris	1900-01-01 14:30:00.000	1900-01-01 17:50:00.000
1101	4	Boeing	Paris	Rostov	1900-01-01 08:12:00.000	1900-01-01 11:45:00.000
1123	3	TU-154	Rostov	Vladivostok	1900-01-01 16:20:00.000	1900-01-01 03:40:00.000
1124	3	TU-154	Vladivostok	Rostov	1900-01-01 09:00:00.000	1900-01-01 19:50:00.000
1145	2	IL-86	Moscow	Rostov	1900-01-01 09:35:00.000	1900-01-01 11:23:00.000
1146	2	IL-86	Rostov	Moscow	1900-01-01 17:55:00.000	1900-01-01 20:01:00.000
1181	1	TU-134	Rostov	Moscow	1900-01-01 06:12:00.000	1900-01-01 08:01:00.000
1182	1	TU-134	Moscow	Rostov	1900-01-01 12:35:00.000	1900-01-01 14:30:00.000
1187	1	TU-134	Rostov	Moscow	1900-01-01 15:42:00.000	1900-01-01 17:39:00.000
1188	1	TU-134	Moscow	Rostov	1900-01-01 22:50:00.000	1900-01-01 00:48:00.000
1195	1	TU-154	Rostov	Moscow	1900-01-01 23:30:00.000	1900-01-01 01:11:00.000
1196	1	TU-154	Moscow	Rostov	1900-01-01 04:00:00.000	1900-01-01 05:45:00.000
7771	5	Boeing	London	Singapore	1900-01-01 01:00:00.000	1900-01-01 11:00:00.000
7772	5	Boeing	Singapore	London	1900-01-01 12:00:00.000	1900-01-01 02:00:00.000
7773	5	Boeing	London	Singapore	1900-01-01 03:00:00.000	1900-01-01 13:00:00.000
7774	5	Boeing	Singapore	London	1900-01-01 14:00:00.000	1900-01-01 06:00:00.000
7775	5	Boeing	London	Singapore	1900-01-01 09:00:00.000	1900-01-01 20:00:00.000
7776	5	Boeing	Singapore	London	1900-01-01 18:00:00.000	1900-01-01 08:00:00.000
7777	5	Boeing	London	Singapore	1900-01-01 18:00:00.000	1900-01-01 06:00:00.000
7778	5	Boeing	Singapore	London	1900-01-01 22:00:00.000	1900-01-01 12:00:00.000
8881	5	Boeing	London	Paris	1900-01-01 03:00:00.000	1900-01-01 04:00:00.000
8882	5	Boeing	Paris	London	1900-01-01 22:00:00.000	1900-01-01 23:00:00.000

4.3 Passenger

ID_psg	name
1	Bruce Willis
2	George Clooney
3	Kevin Costner
4	Donald Sutherland
5	Jennifer Lopez
6	Ray Liotta
7	Samuel L. Jackson
8	Nikole Kidman
9	Alan Rickman
10	Kurt Russell
11	Harrison Ford
12	Russell Crowe
13	Steve Martin
14	Michael Caine
15	Angelina Jolie
16	Mel Gibson
17	Michael Douglas
18	John Travolta
19	Sylvester Stallone
20	Tommy Lee Jones
21	Catherine Zeta-Jones
22	Antonio Banderas
23	Kim Basinger
24	Sam Neill
25	Gary Oldman
26	Clint Eastwood
27	Brad Pitt
28	Johnny Depp
29	Pierce Brosnan
30	Sean Connery
31	Bruce Willis
37	Mullah Omar

4.4 Pass_in_trip

trip_no	date	ID_psg	place
1100	2003-04-29 00:00:00.000	1	1a
1123	2003-04-05 00:00:00.000	3	2a
1123	2003-04-08 00:00:00.000	1	4c
1123	2003-04-08 00:00:00.000	6	4b
1124	2003-04-02 00:00:00.000	2	2d
1145	2003-04-05 00:00:00.000	3	2c
1181	2003-04-01 00:00:00.000	1	1a
1181	2003-04-01 00:00:00.000	6	1b
1181	2003-04-01 00:00:00.000	8	3c
1181	2003-04-13 00:00:00.000	5	1b
1182	2003-04-13 00:00:00.000	5	4b
1187	2003-04-14 00:00:00.000	8	3a
1188	2003-04-01 00:00:00.000	8	3a
1182	2003-04-13 00:00:00.000	9	6d
1145	2003-04-25 00:00:00.000	5	1d
8882	2005-11-06 00:00:00.000	37	1a
7771	2005-11-07 00:00:00.000	37	1c
7772	2005-11-07 00:00:00.000	37	1a
8881	2005-11-08 00:00:00.000	37	1d
7778	2005-11-05 00:00:00.000	10	2a
7772	2005-11-29 00:00:00.000	10	3a
7771	2005-11-04 00:00:00.000	11	4a
7771	2005-11-07 00:00:00.000	11	1b
7771	2005-11-09 00:00:00.000	11	5a
7772	2005-11-07 00:00:00.000	12	1d
7773	2005-11-07 00:00:00.000	13	2d
7772	2005-11-29 00:00:00.000	13	1b
8882	2005-11-13 00:00:00.000	14	3d
7771	2005-11-14 00:00:00.000	14	4d
7771	2005-11-16 00:00:00.000	14	5d
7772	2005-11-29 00:00:00.000	14	1c
1187	2003-04-14 00:00:00.000	10	3d

5. Painting

5.1 utQ – Название и ID квадрата, который изначально Черный

Q_ID	Q_NAME
1	Square # 01
2	Square # 02
3	Square # 03
4	Square # 04
5	Square # 05
6	Square # 06
7	Square # 07
8	Square # 08
9	Square # 09
10	Square # 10
11	Square # 11
12	Square # 12
13	Square # 13
14	Square # 14
15	Square # 15
16	Square # 16
17	Square # 17
18	Square # 18
19	Square # 19
20	Square # 20
21	Square # 21
22	Square # 22
23	Square # 23
25	Square # 25

5.2 utV – Название, ID и цвет баллончика с краской

V_ID	V_NAME	V_COLOR
1	Balloon # 01	R
2	Balloon # 02	R
3	Balloon # 03	R
4	Balloon # 04	G
5	Balloon # 05	G
6	Balloon # 06	G
7	Balloon # 07	B
8	Balloon # 08	B
9	Balloon # 09	B
10	Balloon # 10	R
11	Balloon # 11	R
12	Balloon # 12	R
13	Balloon # 13	G
14	Balloon # 14	G
15	Balloon # 15	B
16	Balloon # 16	B
17	Balloon # 17	R
18	Balloon # 18	G
19	Balloon # 19	B
20	Balloon # 20	R
21	Balloon # 21	G
22	Balloon # 22	B
23	Balloon # 23	R
24	Balloon # 24	G
25	Balloon # 25	B
26	Balloon # 26	B
27	Balloon # 27	R
28	Balloon # 28	G
29	Balloon # 29	R
30	Balloon # 30	G
31	Balloon # 31	R
32	Balloon # 32	G
33	Balloon # 33	B
34	Balloon # 34	R
35	Balloon # 35	G
36	Balloon # 36	B
37	Balloon # 37	R
38	Balloon # 38	G
39	Balloon # 39	B
40	Balloon # 40	R
41	Balloon # 41	R
42	Balloon # 42	G
43	Balloon # 43	B
44	Balloon # 44	R
45	Balloon # 45	G
46	Balloon # 46	B
47	Balloon # 47	B
48	Balloon # 48	G
49	Balloon # 49	R
50	Balloon # 50	G
51	Balloon # 51	B
52	Balloon # 52	R
53	Balloon # 53	G
54	Balloon # 54	B

5.3 utB – Время окраски, ID квадрата, ID баллончика и кол-во краски

B_DATETIME	B_Q_ID	B_V_ID	B_VOL
2000-01-01 01:13:36.000	22	50	50
2001-01-01 01:13:37.000	22	50	50
2002-01-01 01:13:38.000	22	51	50
2002-06-01 01:13:39.000	22	51	50
2003-01-01 01:12:01.000	1	1	155
2003-01-01 01:12:03.000	2	2	255
2003-01-01 01:12:04.000	3	3	255
2003-01-01 01:12:05.000	1	4	255
2003-01-01 01:12:06.000	2	5	255
2003-01-01 01:12:07.000	3	6	255
2003-01-01 01:12:08.000	1	7	255
2003-01-01 01:12:09.000	2	8	255
2003-01-01 01:12:10.000	3	9	255
2003-01-01 01:12:11.000	4	10	50
2003-01-01 01:12:12.000	5	11	100
2003-01-01 01:12:13.000	5	12	155
2003-01-01 01:12:14.000	5	13	155
2003-01-01 01:12:15.000	5	14	100
2003-01-01 01:12:16.000	5	15	50
2003-01-01 01:12:17.000	5	16	205
2003-01-01 01:12:18.000	6	10	155
2003-01-01 01:12:19.000	6	17	100
2003-01-01 01:12:20.000	6	18	255
2003-01-01 01:12:21.000	6	19	255
2003-01-01 01:12:22.000	7	17	155
2003-01-01 01:12:23.000	7	20	100
2003-01-01 01:12:24.000	7	21	255
2003-01-01 01:12:25.000	7	22	255
2003-01-01 01:12:26.000	8	10	50
2003-01-01 01:12:27.000	9	23	255
2003-01-01 01:12:28.000	9	24	255
2003-01-01 01:12:29.000	9	25	100
2003-01-01 01:12:30.000	9	26	155
2003-01-01 01:12:31.000	10	25	155
2003-01-01 01:12:31.000	10	26	100
2003-01-01 01:12:33.000	10	27	10
2003-01-01 01:12:34.000	10	28	10
2003-01-01 01:12:35.000	10	29	245
2003-01-01 01:12:36.000	10	30	245
2003-01-01 01:12:37.000	11	31	100
2003-01-01 01:12:38.000	11	32	100
2003-01-01 01:12:39.000	11	33	100
2003-01-01 01:12:40.000	11	34	155
2003-01-01 01:12:41.000	11	35	155
2003-01-01 01:12:42.000	11	36	155
2003-01-01 01:12:43.000	12	31	155
2003-01-01 01:12:44.000	12	32	155
2003-01-01 01:12:45.000	12	33	155
2003-01-01 01:12:46.000	12	34	100
2003-01-01 01:12:47.000	12	35	100
2003-01-01 01:12:48.000	12	36	100
2003-01-01 01:13:01.000	4	37	20
2003-01-01 01:13:02.000	8	38	20
2003-01-01 01:13:03.000	13	39	123
2003-01-01 01:13:04.000	14	39	111
2003-01-01 01:13:05.000	4	37	185
2003-01-01 01:13:05.000	14	40	50
2003-01-01 01:13:06.000	15	41	50
2003-01-01 01:13:07.000	15	41	50
2003-01-01 01:13:08.000	15	42	50
2003-01-01 01:13:09.000	15	42	50
2003-01-01 01:13:10.000	16	42	50
2003-01-01 01:13:11.000	16	42	50
2003-01-01 01:13:12.000	16	43	50
2003-01-01 01:13:13.000	16	43	50
2003-01-01 01:13:14.000	16	47	50
2003-01-01 01:13:15.000	17	44	10
2003-01-01 01:13:16.000	17	44	10
2003-01-01 01:13:17.000	17	45	10
2003-01-01 01:13:18.000	17	45	10
2003-01-01 01:13:24.000	19	44	10
2003-01-01 01:13:25.000	19	45	10
2003-01-01 01:13:26.000	19	45	10
2003-02-01 01:13:19.000	18	45	10
2003-02-01 01:13:27.000	20	45	10
2003-02-01 01:13:31.000	21	49	50
2003-02-02 01:13:32.000	21	49	50
2003-02-03 01:13:33.000	21	50	50
2003-02-04 01:13:34.000	21	50	50
2003-02-05 01:13:35.000	21	48	1
2003-03-01 01:13:20.000	18	45	10
2003-03-01 01:13:28.000	20	45	10
2003-04-01 01:13:21.000	18	46	10
2003-04-01 01:13:29.000	20	46	10
2003-05-01 01:13:22.000	18	46	10
2003-05-01 01:13:30.000	20	46	10
2003-06-11 01:13:23.000	19	44	10
2003-06-23 01:12:02.000	1	1	100