II 03 Базы данных
.pdfSQL SELECT
«Post»
.
:
- Region – (id – , Name –
);
- City – , (id –
, idRegion – ( ), Name –
, isCentr – , TimeDel – );
- RateZone – (id – , Name – );
- CityinZone – (idCity –
( ), idRateZone –
( ));
-RateZonePrice – (idRateZone –
( ), idMass –
), Price - );
- Mass – (id – , Name –
, BeginM – , EndM – , Stm – ).
1
1 – «Post»
,
...
1.,
2., ,
3.,
4.,
5., , ,
6., , ,
7., , , , , .
8., ,
9., « »
10. , « »
11. ,
2
12. , , , 1 5
13. , , 6-10
14. ,
15. ,
16. ,
17. , ,
« » « »
18. 10 ( ).
19. , 5.
20. , 6 (
)
21. , ,
3-4
22. , ,
« »
23. , ,
.
24. ,
30 25. (
)
«Medic»
,
.
:
- Firm – (id – , Name –
; date – );
3
- Worker – (id –
), id – , Name –
, sex – , bdate – , PIWork – , Standing –
, Post - );
- diag – (id –
( ), number – ( ), idmedic – ( ), iddiag –
));
- ref_medic– (id – , post – , name – );
- ref_diag – (id – , code –
, name – );
- PointerOrder – ,
(id – ( ), id –
( ), id_tree –
( ));
- ref_tree – (id – , tr_id –
( ), name – , pos –
);
- ref_ResearchList –
(id_tree – , tr_research –
));
-ref_Research – (id –
, TypeCheckupL – , Sex- , Price – , typeresearch – ( ));
- ref_TypeResearch – (id –
, name – ).
4
2 – «Medic»
,
...
1., ,
2., , , ,
3., , , ,
4., ,
5.,
5
6., , ,
7.,
8., , ,
9.,
10. , , ,
11. , , ,
12. , , ,
13. , , ,
14. , , , ,
15. , , ,
16. ,
17. , , ,
18. ,
19. , ,
,
20. , , ,
21. , ,
22. , , ,
23. , , , , 50 24. , , ,
« »
25. , , ,
26. , , , ,
100 27. , , ,
6
28. , ,
, ,
« »
29. , ,
« »
30. , , , –
31. , , ,
»
32. , , ,
«M42»
33. , , «*»
34. ,
35. ,
36. , 50
37. , 25
38. , ,
39. , ,
40. , ,
41. , , ,
42. , ,
,
43. , , ,
44. , « »
45. , ,
46. ,
« »
7
47. « »
48. ,
49. , , ,
50. ,
13 51. , 3
52. , 300
53. , 100 54. , 50
40
55. , 25
5
56. , ,
25 57. , , 3
58. , , 7,
59. , ,
, 8 60. , , ,
15 61. , 3
« »
62. , 60 63. , , 10
8
1
|
|
|
|
|
|
|
|
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1. |
medic |
1 |
11 |
31 |
34 |
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
medic |
2 |
12 |
22 |
35 |
51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3. |
medic |
3 |
13 |
23 |
36 |
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4. |
medic |
4 |
14 |
24 |
37 |
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5. |
post |
1 |
5 |
9 |
14 |
20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6. |
medic |
5 |
15 |
25 |
38 |
54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7. |
medic |
6 |
16 |
26 |
39 |
55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8. |
medic |
7 |
17 |
27 |
40 |
56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9. |
medic |
8 |
18 |
28 |
41 |
57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10. |
post |
2 |
6 |
10 |
15 |
21 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11. |
medic |
9 |
19 |
29 |
42 |
58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12. |
medic |
10 |
20 |
30 |
43 |
59 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13. |
medic |
1 |
21 |
31 |
44 |
60 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14. |
medic |
2 |
20 |
32 |
45 |
61 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15. |
post |
3 |
7 |
11 |
16 |
22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16. |
medic |
3 |
17 |
33 |
46 |
62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
17. |
medic |
4 |
14 |
22 |
47 |
63 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18. |
medic |
5 |
11 |
23 |
48 |
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19. |
medic |
6 |
12 |
24 |
49 |
51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20. |
post |
4 |
8 |
12 |
17 |
23 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21. |
medic |
7 |
13 |
25 |
34 |
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
22. |
medic |
8 |
16 |
26 |
35 |
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
23. |
medic |
9 |
18 |
27 |
36 |
54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
24. |
medic |
10 |
19 |
28 |
37 |
55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
25. |
post |
2 |
5 |
13 |
18 |
24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
26. |
medic |
1 |
20 |
28 |
38 |
56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
27. |
medic |
2 |
17 |
29 |
39 |
57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
28. |
medic |
3 |
14 |
30 |
40 |
58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
29. |
medic |
4 |
11 |
31 |
41 |
59 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
30. |
post |
1 |
7 |
10 |
19 |
25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
31. |
medic |
5 |
13 |
32 |
42 |
60 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
32. |
medic |
6 |
16 |
25 |
43 |
61 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
33. |
medic |
7 |
21 |
31 |
44 |
62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
34. |
medic |
8 |
19 |
28 |
45 |
63 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9
|
|
|
|
|
|
|
|
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
35. |
post |
2 |
6 |
11 |
17 |
21 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
36. |
medic |
10 |
15 |
29 |
46 |
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4
|
|
|
|
|
|
|
|
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1. |
medic |
4 |
11 |
28 |
34 |
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
medic |
3 |
13 |
22 |
35 |
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3. |
medic |
2 |
12 |
23 |
36 |
54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4. |
medic |
1 |
14 |
24 |
37 |
55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5. |
post |
1 |
6 |
11 |
14 |
21 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6. |
medic |
7 |
15 |
27 |
38 |
56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7. |
medic |
5 |
16 |
25 |
39 |
57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8. |
medic |
8 |
18 |
26 |
40 |
58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9. |
medic |
6 |
17 |
28 |
41 |
59 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10. |
post |
2 |
5 |
9 |
15 |
22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11. |
medic |
9 |
20 |
29 |
42 |
60 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12. |
medic |
10 |
19 |
30 |
43 |
61 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13. |
medic |
2 |
15 |
32 |
44 |
62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14. |
medic |
1 |
20 |
31 |
45 |
63 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15. |
post |
3 |
8 |
10 |
16 |
23 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16. |
medic |
3 |
14 |
33 |
46 |
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
17. |
medic |
4 |
17 |
23 |
47 |
51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18. |
medic |
5 |
12 |
22 |
48 |
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19. |
medic |
6 |
11 |
24 |
49 |
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20. |
post |
4 |
9 |
12 |
17 |
24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21. |
medic |
9 |
16 |
25 |
34 |
54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
22. |
medic |
8 |
13 |
26 |
35 |
55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
23. |
medic |
7 |
18 |
25 |
36 |
56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
24. |
medic |
10 |
19 |
27 |
37 |
57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
25. |
post |
1 |
5 |
12 |
18 |
25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
26. |
medic |
10 |
21 |
26 |
38 |
58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11
|
|
|
|
|
|
|
|
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1. |
medic |
4 |
11 |
28 |
34 |
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10