Leping

Majandus- ja Kommunikatsiooniministeerium Tarbijakaitse ja Tehnilise Järelevalve Ameti järelevalve infosüsteemi andmemudeli diagrammi ja andmebaasi tabelite kirjleduse loomise hinnapakkumus  Hinnapakkumus 25.07.2022 1 Sisukord 1 Sisukord 2 2 Dokumendi ajalugu 3 3 Tööde sisu 3 Teostatavad tööd 4 4 Ajakava 14 5 Hinnapakkumus 14 www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 2  Hinnapakkumus 25.07.2022 2 Dokumendi ajalugu KUUPÄEV VERSIOON KIRJELDUS AUTOR 25.07.2022 1.0 Tarbijakaitse ja Tehnilise Järelevalve Ameti Alar Sillaots järelevalve infosüsteemi andmemudeli diagrammi ja andmebaasi tabelite kirjleduse loomine. 16.08.2022 1.1 Täiendused Alar Sillaots 3 Tööde sisu Tarbijakaitse ja Tehnilise Järelevalve Ameti järelevalve infosüsteemi: 1. Andmemudeli diagramm – luuakse ERD skeem moodulite kaupa. 2. Andmebaasi tabelite kirjeldus - andmebaasi tabelite ja andmeväljade kirjeldamine. Semantika ja näiteväärtuse väljal kirjeldatakse ka tabelite omavahelisi seosed ja klassifikaatorite nimed. Näidistabel koos andmete ja kirjeldusega: Tabel "admin" Kirjeldus Kasutajate (administraatorite) tabel Andmeväli Andmetüüp Täpsustused Semantika id integer PK Unikaalne kood firstname string(255) Eesnimi middlename string(255) Keskmine nimi lastname string(255) Perekonnanimi email string(255) null E-posti aaddress phone string(255) null Telefon username string(255) Kasutajanimi password string(255) Salasõna www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 3  Hinnapakkumus 25.07.2022 salt string(255) Salasõna krüpteeritud status string(255) Klassifikaator: jvis.admin.status created datetime Kirje loomise aeg whitelist json_array Lubatud IP-aadressid superadmin boolean On/ei ole peahaldur notice_send_timeo ut integer Teavituste väljasaatmise intervall list_size integer Vaikimisi nimekirja suurus locale string(5) Asukoht settings json Salvestatud seaded person_id int FK Seos tabeliga: isik Teostatavad tööd Hinnapakkumuse sisu on järgnev: A. JVIS andmemudeli diagramm B. JVIS andmebaasi tabelid mida tööde käigus kirjeldatakse: 1. Table "act" 2. Table "act_bystander" 3. Table "act_checkedobjects" 4. Table "act_signer" 5. Table "activity" 6. Table "activitytype" 7. Table "address" 8. Table "address_ads" 9. Table "address_ads_address_postcode" 10. Table "address_custom" 11. Table "address_normalization_failure" 12. Table "address_normalization_request" 13. Table "address_normalization_success" 14. Table "address_search" 15. Table "admin" 16. Table "admin_formconfigurator_model" 17. Table "admin_frontpage_block" 18. Table "admin_group" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 4  Hinnapakkumus 25.07.2022 19. Table "admin_group_priv" 20. Table "admin_noticecontext" 21. Table "admin_priv" 22. Table "ads_address" 23. Table "ads_last_update" 24. Table "ads_level" 25. Table "application" 26. Table "asjade_eraldamise_maarus" 27. Table "asjade_uhendamise_maarus" 28. Table "audit_email" 29. Table "auditdecision" 30. Table "audittypetext" 31. Table "auth_communication_collection" 32. Table "auth_communications" 33. Table "auth_communications_admin_notice_config" 34. Table "auth_communications_formconfigurator_field" 35. Table "auth_communications_numbers" 36. Table "auth_communications_status" 37. Table "auth_delivery_address" 38. Table "authcommunications_transmitter" 39. Table "authdomcommunications" 40. Table "authdomcommunications_air_and_water_craft_fields" 41. Table "authdomcommunications_amateurradio" 42. Table "authdomcommunications_broadcasting" 43. Table "authdomcommunications_communications_base_fields" 44. Table "authdomcommunications_frequency" 45. Table "authdomcommunications_frequency_range" 46. Table "authdomcommunications_frequencyfields" 47. Table "authdomcommunications_media_fields" 48. Table "authdomcommunications_number_fields" 49. Table "authdomcommunications_satellite_fields" 50. Table "authdomlegalperson" 51. Table "authdomphysperson" 52. Table "authdomphysperson_competencescope" 53. Table "authlegalperson" 54. Table "authlegalperson_formconfigurator_field" 55. Table "authlegalperson_status" 56. Table "authphysperson" 57. Table "authphysperson_formconfigurator_field" 58. Table "authphysperson_status" 59. Table "authphysperson_training_institution" 60. Table "bo_itemlist_savedsearch" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 5  Hinnapakkumus 25.07.2022 61. Table "building" 62. Table "building_parts" 63. Table "building_parts_check" 64. Table "building_parts_installations_checked" 65. Table "calendar" 66. Table "calendar_persons" 67. Table "cdc" 68. Table "cdc_application" 69. Table "cdc_application_committee_members" 70. Table "cdc_application_company" 71. Table "cdc_application_consumer" 72. Table "cdc_application_decision" 73. Table "cdc_application_formconfigurator_field" 74. Table "cdc_application_statuschanges" 75. Table "cdc_application_task" 76. Table "cdc_application_task_attachment" 77. Table "cdc_application_tasktypes" 78. Table "checklist" 79. Table "checklist_object" 80. Table "checklist_object_claim" 81. Table "classification__category" 82. Table "classification__collection" 83. Table "classification__context" 84. Table "classification__tag" 85. Table "classifier" 86. Table "classifierlabel" 87. Table "classifiervalue" 88. Table "communications_ersp_document_parent" 89. Table "communications_ersp_document_type" 90. Table "communications_ersp_erspfrequencystep" 91. Table "communications_ersp_ersppower" 92. Table "communications_ersp_erspservice" 93. Table "communications_ersp_frequency" 94. Table "communications_ersp_frequencyarea" 95. Table "communications_ersp_informativepart" 96. Table "communications_ersp_informativepart_files" 97. Table "communications_ersp_ip_document" 98. Table "communications_ersp_log" 99. Table "communications_ersp_modulation" 100. Table "communications_frequencies" 101. Table "communications_frequencyareas" 102. Table "communications_itu_footnote" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 6  Hinnapakkumus 25.07.2022 103. Table "communications_itu_frequencyarea" 104. Table "communications_itu_log" 105. Table "communications_itu_radioservice" 106. Table "communications_regulation" 107. Table "communications_regulation_annex" 108. Table "communications_resource" 109. Table "communications_resources_antenna" 110. Table "communications_resources_antennatypes" 111. Table "communications_resources_argus" 112. Table "communications_resources_argusdata" 113. Table "communications_resources_coordinates" 114. Table "communications_resources_device" 115. Table "communications_resources_maparea" 116. Table "communications_resources_radiationpattern" 117. Table "communications_resources_tower" 118. Table "communications_resources_tower_name" 119. Table "communications_translation" 120. Table "competency_certificate" 121. Table "consumer_dispute_committe_decisions" 122. Table "consumer_dispute_committee" 123. Table "consumer_dispute_committee_hearings" 124. Table "consumer_dispute_committee_members_dummy" 125. Table "coordination" 126. Table "coordination_contract" 127. Table "coordination_contract_frequencyarea" 128. Table "coordination_itu_antenna_data" 129. Table "coordination_itu_data" 130. Table "coordination_rxstation" 131. Table "counsel" 132. Table "counsel_activity_types" 133. Table "counsel_product_types" 134. Table "decision_subject" 135. Table "digidoc" 136. Table "digidoc_promise" 137. Table "digidoc_signature" 138. Table "dms_archivepackage" 139. Table "dms_deadline" 140. Table "dms_dmsconf" 141. Table "dms_document" 142. Table "dms_document_activity" 143. Table "dms_document_activity_operation" 144. Table "dms_document_activity_operation_approve" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 7  Hinnapakkumus 25.07.2022 145. Table "dms_document_activity_operation_complete" 146. Table "dms_document_activity_operation_confirm" 147. Table "dms_document_activity_operation_note" 148. Table "dms_document_activity_operation_proposal" 149. Table "dms_document_activity_operation_sign" 150. Table "dms_document_activity_person" 151. Table "dms_document_activity_person_reminder" 152. Table "dms_document_attachments_link" 153. Table "dms_document_formconfiguratorfield" 154. Table "dms_document_public" 155. Table "dms_forwarded_document" 156. Table "dms_fromemail_email" 157. Table "dms_fromemail_failed" 158. Table "dms_thing" 159. Table "dms_thing_formconfiguratorfield" 160. Table "docnumbergenalgo" 161. Table "document" 162. Table "document_access_restriction" 163. Table "document_access_restriction_triggercode" 164. Table "document_signer" 165. Table "documentissuer" 166. Table "documentmanagementcoordinationring" 167. Table "documentmanagementcoordinationring_people" 168. Table "documentmanagementseries" 169. Table "documentmanagementtype" 170. Table "ekspertiisimaarus" 171. Table "email" 172. Table "energy_consumption" 173. Table "energy_measure" 174. Table "energy_profile" 175. Table "energyaudit" 176. Table "energyaudit_person" 177. Table "energyaudit_signer" 178. Table "energysavingsmeasure" 179. Table "etoimik_legal_act" 180. Table "expertise" 181. Table "formconfigurator" 182. Table "formconfigurator_field" 183. Table "formconfigurator_field_option" 184. Table "formconfigurator_publication" 185. Table "formconfigurator_searchfield" 186. Table "formconfigurator_test" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 8  Hinnapakkumus 25.07.2022 187. Table "formconfigurator_test_field" 188. Table "formconfigurator_valuedate" 189. Table "formconfigurator_valuefloat" 190. Table "formconfigurator_valuestring" 191. Table "frontpage_block" 192. Table "help" 193. Table "import_installation_form_update" 194. Table "installation" 195. Table "installation_changerequest" 196. Table "installation_formconfigurator_field" 197. Table "installation_formconfigurator_model" 198. Table "installation_gas_check" 199. Table "installation_gas_check_signer" 200. Table "installation_installers" 201. Table "installation_manufacturers" 202. Table "installation_merge" 203. Table "installation_multi_edit" 204. Table "installation_public_count" 205. Table "installation_registration_certificate_multi" 206. Table "installation_relation" 207. Table "installation_rinf_operationalpointgeneral" 208. Table "installation_rinf_opsiding" 209. Table "installation_rinf_optrack" 210. Table "installation_rinf_optrackplatform" 211. Table "installation_rinf_sectionoflinegeneral" 212. Table "installation_rinf_soltrack" 213. Table "installation_rinfdata" 214. Table "installationgroup" 215. Table "installationgroup_changerequestgroup" 216. Table "installationgroup_techinspectiongroup" 217. Table "invitation" 218. Table "jvis_address_normalization_reviewed" 219. Table "jvis_admin" 220. Table "jvis_chemical" 221. Table "jvis_chemical_calculator_data" 222. Table "jvis_chemical_calculator_data_chemical" 223. Table "jvis_chemical_danger_level" 224. Table "jvis_chemical_danger_level_category" 225. Table "jvis_chemical_danger_level_category_slogan" 226. Table "jvis_chemical_data_sheet" 227. Table "jvis_chemical_data_sheet_chemical" 228. Table "jvis_chemical_emergency_plan" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 9  Hinnapakkumus 25.07.2022 229. Table "jvis_chemical_emergency_plan_major_disaster" 230. Table "jvis_chemical_emergency_plan_residential_in_danger_area" 231. Table "jvis_chemical_emergency_plan_responsible_person" 232. Table "jvis_chemical_emergency_plan_risk_reduce_measure" 233. Table "jvis_chemical_emergency_plan_thermal_radiation" 234. Table "jvis_chemical_emergency_plan_threatening_situation" 235. Table "jvis_chemical_emergency_plan_training" 236. Table "jvis_chemical_installation" 237. Table "jvis_chemical_installation_chemical" 238. Table "jvis_chemical_pending_document" 239. Table "jvis_chemical_risk_analysis" 240. Table "jvis_chemical_risk_analysis_past_occurrence" 241. Table "jvis_chemical_risk_analysis_process" 242. Table "jvis_chemical_risk_analysis_script" 243. Table "jvis_chemical_safety_report" 244. Table "jvis_chemical_safety_system_description" 245. Table "jvis_chemical_workflow_status_change" 246. Table "jvis_installation_items_formconfigurator_searchfield" 247. Table "jvis_installation_items_formconfigurator_valuedate" 248. Table "jvis_installation_items_formconfigurator_valuefloat" 249. Table "jvis_installation_items_formconfigurator_valuestring" 250. Table "jvis_installation_xroad_user" 251. Table "jvis_multi_action_request" 252. Table "jvis_occurrence_items_formconfigurator_searchfield" 253. Table "jvis_occurrence_items_formconfigurator_valuedate" 254. Table "jvis_occurrence_items_formconfigurator_valuefloat" 255. Table "jvis_occurrence_items_formconfigurator_valuestring" 256. Table "jvis_rinfinstallation" 257. Table "jvis_workflow_status_change" 258. Table "kiirmenetluse_otsus" 259. Table "maritime_callsigns" 260. Table "media__gallery" 261. Table "media__gallery_media" 262. Table "media__media" 263. Table "media_formconfigurator_model" 264. Table "media_owner" 265. Table "misdemeanor" 266. Table "misdemeanor_collection" 267. Table "misdemeanor_document_person" 268. Table "misdemeanor_document_place" 269. Table "misdemeanor_protocol" 270. Table "misdemeanor_qualification_collection" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 10  Hinnapakkumus 25.07.2022 271. Table "misdemeanordocument" 272. Table "misdemeanorlegalact" 273. Table "misdemeanorperson" 274. Table "misdemeanorqualification" 275. Table "mmsi_call_group" 276. Table "mmsi_code" 277. Table "mtrreg" 278. Table "muu_maarus" 279. Table "muu_protokoll" 280. Table "neighbourcontacts" 281. Table "note" 282. Table "notice" 283. Table "notice_context" 284. Table "notice_send" 285. Table "notice_user_send" 286. Table "notice_user_send_notice" 287. Table "notice_userstatus" 288. Table "number" 289. Table "occurrence" 290. Table "occurrence_formconfigurator_field" 291. Table "occurrence_legalperson" 292. Table "occurrence_object_activity" 293. Table "occurrence_object_installation" 294. Table "occurrence_object_product" 295. Table "occurrence_physperson" 296. Table "occurrence_procedure" 297. Table "occurrencegroup" 298. Table "occurrenceobject" 299. Table "offencetyperegbase" 300. Table "paymentprop" 301. Table "person" 302. Table "person_authorized" 303. Table "person_blacklist" 304. Table "person_business_location" 305. Table "person_certificate" 306. Table "person_chain_mark" 307. Table "person_chembizsector" 308. Table "person_email" 309. Table "person_fax" 310. Table "person_form_person_type_token" 311. Table "person_formconfigurator_model" 312. Table "person_merge" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 11  Hinnapakkumus 25.07.2022 313. Table "person_namehistory" 314. Table "person_phone" 315. Table "person_quarterlyreport_temporary_exemption_date" 316. Table "person_quarterlyreportexemption_date" 317. Table "person_quarterlyreportexemptions" 318. Table "person_quarterlyreportsubtype" 319. Table "person_sevesosector" 320. Table "person_tourism_collateral" 321. Table "person_training" 322. Table "person_x_address" 323. Table "precept" 324. Table "precept_bystander" 325. Table "precept_checkedobjects" 326. Table "precept_done" 327. Table "precept_extend" 328. Table "precept_mtrsend" 329. Table "precept_person" 330. Table "precept_row" 331. Table "precept_seal" 332. Table "precept_signer" 333. Table "priv_resolver_cache" 334. Table "procedure" 335. Table "procedure_attachment" 336. Table "procedure_deadline" 337. Table "procedure_object_activity" 338. Table "procedure_object_chemical_installation" 339. Table "procedure_object_installation" 340. Table "procedure_object_product" 341. Table "procedure_object_productgroup" 342. Table "procedure_starred_person" 343. Table "procedure_summary" 344. Table "procedure_supervisiongroup" 345. Table "procedureobject" 346. Table "procedureperson" 347. Table "proceedingbase" 348. Table "product" 349. Table "productgroup" 350. Table "protocol" 351. Table "protocol_bystander" 352. Table "protocol_checkedobjects" 353. Table "protocol_person" 354. Table "protocol_row" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 12  Hinnapakkumus 25.07.2022 355. Table "protocol_signer" 356. Table "public_auth" 357. Table "public_auth_legal" 358. Table "public_auth_phys" 359. Table "publicdocumentmanagementtype" 360. Table "quarterlyreport" 361. Table "quarterlyreport_payment_data" 362. Table "quarterlyreport_signer" 363. Table "quarterlyreportsubtype" 364. Table "questionnaire" 365. Table "questionnaire_formconfigurator_field" 366. Table "questionnaire_responses" 367. Table "queuecommand" 368. Table "reference" 369. Table "regdomprotobase" 370. Table "regdomtypeviolation" 371. Table "regulatorydomain" 372. Table "regulatorydomaincontent" 373. Table "sanction" 374. Table "signalparameters" 375. Table "statistic_occurrence" 376. Table "sundmuskoha_vaatlusprotokoll" 377. Table "techinspectiontemplate" 378. Table "technicalinspection" 379. Table "technicalinspection_formconfigurator_field" 380. Table "technicalinspection_gas" 381. Table "technicalinspection_gas_inspectiontype" 382. Table "technicalinspection_inspectiontype" 383. Table "technicalinspection_version" 384. Table "templates" 385. Table "traindrivercert" 386. Table "traindrivercert_infrastructure" 387. Table "traindrivercert_languageinspection" 388. Table "traindrivercert_languageproficiency" 389. Table "traindrivercert_modification" 390. Table "traindrivercert_revocation" 391. Table "traindrivercert_suspension" 392. Table "traindrivercert_update" 393. Table "traindriverexam" 394. Table "traindriverexam_known_infrastructure" 395. Table "traindriverexam_knownrollingstock" 396. Table "traindriverlicence_application" www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 13  Hinnapakkumus 25.07.2022 397. Table "traindriverlicence_send" 398. Table "translation_label" 399. Table "translation_marker" 400. Table "userlog_log" 401. Table "userlog_metadata" 402. Table "userlog_row" 403. Table "userlog_user" 404. Table "vaarteomenetluse_alustamata_jatmise_teatis" 405. Table "vaarteomenetluse_lopetamise_maarus" 406. Table "vabatoiming" 407. Table "visit" 408. Table "warning" 409. Table "warning_bystander" 410. Table "warning_person" 411. Table "warning_precept_row_penalty" 412. Table "warning_signer" 413. Table "we_classifier_deleted_label" 414. Table "we_items_export_queue" 415. Table "we_media_dummy" 416. Table "we_media_formconfigurator_token" 417. Table "xrd_modified_ref" 418. Table "yldmenetluse_otsus" 4 Ajakava Tarbijakaitse ja Tehnilise Järelevalve Ameti järelevalve infosüsteemi andmemudeli diagrammi ja andmebaasi tabelite kirjleduse loomise teostamise aeg kokku on 12 nädalat. Tööde teostamise aega hakkame arvestama hankelepingu mõlemapoolsest allkirjastamise hetkest. www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 14  Hinnapakkumus 25.07.2022 5 Hinnapakkumus TÖÖDE NIMETUS TUNNID HIND MAKSUMUS KM-ga Andmemudeli diagrammi 200 € 34.00 € 6 800.00 € 8 160.00 Andmebaasi tabelite kirjeldus 400 € 34.00 € 13 600.00 € 16 320.00 Kokku: 600 € 20 400.00 € 24 480.00 www.we.ee [email protected] Metalli 3, 10615 Tallinn, Eesti Lk. 15  Hankeleping nr 10{regNumber} Tallinnas, {regDateTime} Majandus- ja Kommunikatsiooniministeerium, registrikood 70003158, asukoht Suur-Ameerika 1, Tallinn 10122, mida esindab põhimääruse alusel transpordi asekantsler Ahti Kuningas kantsleri ülesannetes (edaspidi Tellija), ja OÜ Web Expert, registrikood 10838848, asukoht Pärnu maakond, Pärnu linn, Pikk tn 12, 80013, mida esindab põhikirja alusel juhatuse liige Magnus Igasta (edaspidi Täitja), keda edaspidi nimetatakse ka Poolteks, sõlmisid käesoleva hankelepingu (edaspidi Leping) alljärgnevas: 1. Üldsätted 1.1. Leping sõlmitakse Tellija läbiviidud riigihanke “Tarbijakaitse ja tehnilise järelevalve infosüsteemi arendus“ (viitenumber 225258) tulemusena ning 28.09.2020 sõlmitud raamlepingu nr 1.9-21/20-306-1 (edaspidi Raamleping) alusel. 1.2. Lepingu dokumendid koosnevad Lepingust, Lepingu lisadest, Raamlepingust ning Lepingu võimalikest muudatustest, milles lepitakse kokku pärast Lepingule allakirjutamist. 1.3. Käesoleva Lepingu allakirjutamise hetkel on Lepingule lisatud: 1.3.1. Lisa 1 – Lähteülesanne, 1.3.2. Lisa 2 – Pakkumus. 2. Lepingu ese ja Töö teostamise tähtaeg 2.1. Lepingu esemeks on Tarbijakaitse ja tehnilise järelevalve infosüsteemi andmemudeli diagramm ja andmebaasi tabelite kirjeldused (edaspidi Töö) Lepingu Lisas 1 ja 2 esitatud tingimustel. 2.2. Täitja kohustub Töö üle andma 12 nädala jooksul peale lepingu allkirjastamist. 3. Tasu suurus Lepingu kogumaksumus, arvestades pakkumuses esitatud töö mahtu (600 töötundi) ja Raamlepingus nimetatud ühe töötunni hinda (34 eurot), on 20 400.00 eurot käibemaksuta ning käibemaksuga 24 480.00 eurot. Poolte allkirjad: Tellija: Täitja: Majandus- ja Kommunikatsiooni- Web Expert OÜ ministeerium Ahti Kuningas Magnus Igasta transpordi asekantsler kantsleri ülesannetes juhatuse liige  Hankelepingu 10 lisa 1 Lähteülesanne Hankelepingu alusel teostatav Tarbijakaitse ja Tehnilise Järelevalve Ameti järelevalve infosüsteemi andmemudeli diagrammi ja andmebaasi tabelite kirjelduse loomise Töö koosneb: 1. Andmemudeli diagramm – luuakse ERD skeem moodulite kaupa. 2. Andmebaasi tabelite kirjeldus - andmebaasi tabelite ja andmeväljade kirjeldamine. Semantika ja näiteväärtuse väljal kirjeldatakse ka tabelite omavahelisi seosed ja klassifikaatorite nimed. Tööde kirjeldused: A. JVIS andmemudeli diagramm B. JVIS andmebaasi tabelid mida tööde käigus kirjeldatakse: 1. Table "act" 2. Table "act_bystander" 3. Table "act_checkedobjects" 4. Table "act_signer" 5. Table "activity" 6. Table "activitytype" 7. Table "address" 8. Table "address_ads" 9. Table "address_ads_address_postcode" 10. Table "address_custom" 11. Table "address_normalization_failure" 12. Table "address_normalization_request" 13. Table "address_normalization_success" 14. Table "address_search" 15. Table "admin" 16. Table "admin_formconfigurator_model" 17. Table "admin_frontpage_block" 18. Table "admin_group" 19. Table "admin_group_priv" 20. Table "admin_noticecontext" 21. Table "admin_priv" 22. Table "ads_address" 23. Table "ads_last_update" 24. Table "ads_level" 25. Table "application" 26. Table "asjade_eraldamise_maarus" 27. Table "asjade_uhendamise_maarus" 28. Table "audit_email" 29. Table "auditdecision" 30. Table "audittypetext" 31. Table "auth_communication_collection" 32. Table "auth_communications" 33. Table "auth_communications_admin_notice_config" 34. Table "auth_communications_formconfigurator_field" 35. Table "auth_communications_numbers" 36. Table "auth_communications_status" 37. Table "auth_delivery_address" 38. Table "authcommunications_transmitter" 39. Table "authdomcommunications" 40. Table "authdomcommunications_air_and_water_craft_fields" 41. Table "authdomcommunications_amateurradio" 42. Table "authdomcommunications_broadcasting" 43. Table "authdomcommunications_communications_base_fields" 44. Table "authdomcommunications_frequency" 45. Table "authdomcommunications_frequency_range" 46. Table "authdomcommunications_frequencyfields" 47. Table "authdomcommunications_media_fields" 48. Table "authdomcommunications_number_fields" 49. Table "authdomcommunications_satellite_fields" 50. Table "authdomlegalperson" 51. Table "authdomphysperson" 52. Table "authdomphysperson_competencescope" 53. Table "authlegalperson" 54. Table "authlegalperson_formconfigurator_field" 55. Table "authlegalperson_status" 56. Table "authphysperson" 57. Table "authphysperson_formconfigurator_field" 58. Table "authphysperson_status" 59. Table "authphysperson_training_institution" 60. Table "bo_itemlist_savedsearch" 61. Table "building" 62. Table "building_parts" 63. Table "building_parts_check" 64. Table "building_parts_installations_checked" 65. Table "calendar" 66. Table "calendar_persons" 67. Table "cdc" 68. Table "cdc_application" 69. Table "cdc_application_committee_members" 70. Table "cdc_application_company" 71. Table "cdc_application_consumer" 72. Table "cdc_application_decision" 73. Table "cdc_application_formconfigurator_field" 74. Table "cdc_application_statuschanges" 75. Table "cdc_application_task" 76. Table "cdc_application_task_attachment" 77. Table "cdc_application_tasktypes" 78. Table "checklist" 79. Table "checklist_object" 80. Table "checklist_object_claim" 81. Table "classification__category" 82. Table "classification__collection" 83. Table "classification__context" 84. Table "classification__tag" 85. Table "classifier" 86. Table "classifierlabel" 87. Table "classifiervalue" 88. Table "communications_ersp_document_parent" 89. Table "communications_ersp_document_type" 90. Table "communications_ersp_erspfrequencystep" 91. Table "communications_ersp_ersppower" 92. Table "communications_ersp_erspservice" 93. Table "communications_ersp_frequency" 94. Table "communications_ersp_frequencyarea" 95. Table "communications_ersp_informativepart" 96. Table "communications_ersp_informativepart_files" 97. Table "communications_ersp_ip_document" 98. Table "communications_ersp_log" 99. Table "communications_ersp_modulation" 100. Table "communications_frequencies" 101. Table "communications_frequencyareas" 102. Table "communications_itu_footnote" 103. Table "communications_itu_frequencyarea" 104. Table "communications_itu_log" 105. Table "communications_itu_radioservice" 106. Table "communications_regulation" 107. Table "communications_regulation_annex" 108. Table "communications_resource" 109. Table "communications_resources_antenna" 110. Table "communications_resources_antennatypes" 111. Table "communications_resources_argus" 112. Table "communications_resources_argusdata" 113. Table "communications_resources_coordinates" 114. Table "communications_resources_device" 115. Table "communications_resources_maparea" 116. Table "communications_resources_radiationpattern" 117. Table "communications_resources_tower" 118. Table "communications_resources_tower_name" 119. Table "communications_translation" 120. Table "competency_certificate" 121. Table "consumer_dispute_committe_decisions" 122. Table "consumer_dispute_committee" 123. Table "consumer_dispute_committee_hearings" 124. Table "consumer_dispute_committee_members_dummy" 125. Table "coordination" 126. Table "coordination_contract" 127. Table "coordination_contract_frequencyarea" 128. Table "coordination_itu_antenna_data" 129. Table "coordination_itu_data" 130. Table "coordination_rxstation" 131. Table "counsel" 132. Table "counsel_activity_types" 133. Table "counsel_product_types" 134. Table "decision_subject" 135. Table "digidoc" 136. Table "digidoc_promise" 137. Table "digidoc_signature" 138. Table "dms_archivepackage" 139. Table "dms_deadline" 140. Table "dms_dmsconf" 141. Table "dms_document" 142. Table "dms_document_activity" 143. Table "dms_document_activity_operation" 144. Table "dms_document_activity_operation_approve" 145. Table "dms_document_activity_operation_complete" 146. Table "dms_document_activity_operation_confirm" 147. Table "dms_document_activity_operation_note" 148. Table "dms_document_activity_operation_proposal" 149. Table "dms_document_activity_operation_sign" 150. Table "dms_document_activity_person" 151. Table "dms_document_activity_person_reminder" 152. Table "dms_document_attachments_link" 153. Table "dms_document_formconfiguratorfield" 154. Table "dms_document_public" 155. Table "dms_forwarded_document" 156. Table "dms_fromemail_email" 157. Table "dms_fromemail_failed" 158. Table "dms_thing" 159. Table "dms_thing_formconfiguratorfield" 160. Table "docnumbergenalgo" 161. Table "document" 162. Table "document_access_restriction" 163. Table "document_access_restriction_triggercode" 164. Table "document_signer" 165. Table "documentissuer" 166. Table "documentmanagementcoordinationring" 167. Table "documentmanagementcoordinationring_people" 168. Table "documentmanagementseries" 169. Table "documentmanagementtype" 170. Table "ekspertiisimaarus" 171. Table "email" 172. Table "energy_consumption" 173. Table "energy_measure" 174. Table "energy_profile" 175. Table "energyaudit" 176. Table "energyaudit_person" 177. Table "energyaudit_signer" 178. Table "energysavingsmeasure" 179. Table "etoimik_legal_act" 180. Table "expertise" 181. Table "formconfigurator" 182. Table "formconfigurator_field" 183. Table "formconfigurator_field_option" 184. Table "formconfigurator_publication" 185. Table "formconfigurator_searchfield" 186. Table "formconfigurator_test" 187. Table "formconfigurator_test_field" 188. Table "formconfigurator_valuedate" 189. Table "formconfigurator_valuefloat" 190. Table "formconfigurator_valuestring" 191. Table "frontpage_block" 192. Table "help" 193. Table "import_installation_form_update" 194. Table "installation" 195. Table "installation_changerequest" 196. Table "installation_formconfigurator_field" 197. Table "installation_formconfigurator_model" 198. Table "installation_gas_check" 199. Table "installation_gas_check_signer" 200. Table "installation_installers" 201. Table "installation_manufacturers" 202. Table "installation_merge" 203. Table "installation_multi_edit" 204. Table "installation_public_count" 205. Table "installation_registration_certificate_multi" 206. Table "installation_relation" 207. Table "installation_rinf_operationalpointgeneral" 208. Table "installation_rinf_opsiding" 209. Table "installation_rinf_optrack" 210. Table "installation_rinf_optrackplatform" 211. Table "installation_rinf_sectionoflinegeneral" 212. Table "installation_rinf_soltrack" 213. Table "installation_rinfdata" 214. Table "installationgroup" 215. Table "installationgroup_changerequestgroup" 216. Table "installationgroup_techinspectiongroup" 217. Table "invitation" 218. Table "jvis_address_normalization_reviewed" 219. Table "jvis_admin" 220. Table "jvis_chemical" 221. Table "jvis_chemical_calculator_data" 222. Table "jvis_chemical_calculator_data_chemical" 223. Table "jvis_chemical_danger_level" 224. Table "jvis_chemical_danger_level_category" 225. Table "jvis_chemical_danger_level_category_slogan" 226. Table "jvis_chemical_data_sheet" 227. Table "jvis_chemical_data_sheet_chemical" 228. Table "jvis_chemical_emergency_plan" 229. Table "jvis_chemical_emergency_plan_major_disaster" 230. Table "jvis_chemical_emergency_plan_residential_in_danger_area" 231. Table "jvis_chemical_emergency_plan_responsible_person" 232. Table "jvis_chemical_emergency_plan_risk_reduce_measure" 233. Table "jvis_chemical_emergency_plan_thermal_radiation" 234. Table "jvis_chemical_emergency_plan_threatening_situation" 235. Table "jvis_chemical_emergency_plan_training" 236. Table "jvis_chemical_installation" 237. Table "jvis_chemical_installation_chemical" 238. Table "jvis_chemical_pending_document" 239. Table "jvis_chemical_risk_analysis" 240. Table "jvis_chemical_risk_analysis_past_occurrence" 241. Table "jvis_chemical_risk_analysis_process" 242. Table "jvis_chemical_risk_analysis_script" 243. Table "jvis_chemical_safety_report" 244. Table "jvis_chemical_safety_system_description" 245. Table "jvis_chemical_workflow_status_change" 246. Table "jvis_installation_items_formconfigurator_searchfield" 247. Table "jvis_installation_items_formconfigurator_valuedate" 248. Table "jvis_installation_items_formconfigurator_valuefloat" 249. Table "jvis_installation_items_formconfigurator_valuestring" 250. Table "jvis_installation_xroad_user" 251. Table "jvis_multi_action_request" 252. Table "jvis_occurrence_items_formconfigurator_searchfield" 253. Table "jvis_occurrence_items_formconfigurator_valuedate" 254. Table "jvis_occurrence_items_formconfigurator_valuefloat" 255. Table "jvis_occurrence_items_formconfigurator_valuestring" 256. Table "jvis_rinfinstallation" 257. Table "jvis_workflow_status_change" 258. Table "kiirmenetluse_otsus" 259. Table "maritime_callsigns" 260. Table "media__gallery" 261. Table "media__gallery_media" 262. Table "media__media" 263. Table "media_formconfigurator_model" 264. Table "media_owner" 265. Table "misdemeanor" 266. Table "misdemeanor_collection" 267. Table "misdemeanor_document_person" 268. Table "misdemeanor_document_place" 269. Table "misdemeanor_protocol" 270. Table "misdemeanor_qualification_collection" 271. Table "misdemeanordocument" 272. Table "misdemeanorlegalact" 273. Table "misdemeanorperson" 274. Table "misdemeanorqualification" 275. Table "mmsi_call_group" 276. Table "mmsi_code" 277. Table "mtrreg" 278. Table "muu_maarus" 279. Table "muu_protokoll" 280. Table "neighbourcontacts" 281. Table "note" 282. Table "notice" 283. Table "notice_context" 284. Table "notice_send" 285. Table "notice_user_send" 286. Table "notice_user_send_notice" 287. Table "notice_userstatus" 288. Table "number" 289. Table "occurrence" 290. Table "occurrence_formconfigurator_field" 291. Table "occurrence_legalperson" 292. Table "occurrence_object_activity" 293. Table "occurrence_object_installation" 294. Table "occurrence_object_product" 295. Table "occurrence_physperson" 296. Table "occurrence_procedure" 297. Table "occurrencegroup" 298. Table "occurrenceobject" 299. Table "offencetyperegbase" 300. Table "paymentprop" 301. Table "person" 302. Table "person_authorized" 303. Table "person_blacklist" 304. Table "person_business_location" 305. Table "person_certificate" 306. Table "person_chain_mark" 307. Table "person_chembizsector" 308. Table "person_email" 309. Table "person_fax" 310. Table "person_form_person_type_token" 311. Table "person_formconfigurator_model" 312. Table "person_merge" 313. Table "person_namehistory" 314. Table "person_phone" 315. Table "person_quarterlyreport_temporary_exemption_date" 316. Table "person_quarterlyreportexemption_date" 317. Table "person_quarterlyreportexemptions" 318. Table "person_quarterlyreportsubtype" 319. Table "person_sevesosector" 320. Table "person_tourism_collateral" 321. Table "person_training" 322. Table "person_x_address" 323. Table "precept" 324. Table "precept_bystander" 325. Table "precept_checkedobjects" 326. Table "precept_done" 327. Table "precept_extend" 328. Table "precept_mtrsend" 329. Table "precept_person" 330. Table "precept_row" 331. Table "precept_seal" 332. Table "precept_signer" 333. Table "priv_resolver_cache" 334. Table "procedure" 335. Table "procedure_attachment" 336. Table "procedure_deadline" 337. Table "procedure_object_activity" 338. Table "procedure_object_chemical_installation" 339. Table "procedure_object_installation" 340. Table "procedure_object_product" 341. Table "procedure_object_productgroup" 342. Table "procedure_starred_person" 343. Table "procedure_summary" 344. Table "procedure_supervisiongroup" 345. Table "procedureobject" 346. Table "procedureperson" 347. Table "proceedingbase" 348. Table "product" 349. Table "productgroup" 350. Table "protocol" 351. Table "protocol_bystander" 352. Table "protocol_checkedobjects" 353. Table "protocol_person" 354. Table "protocol_row" 355. Table "protocol_signer" 356. Table "public_auth" 357. Table "public_auth_legal" 358. Table "public_auth_phys" 359. Table "publicdocumentmanagementtype" 360. Table "quarterlyreport" 361. Table "quarterlyreport_payment_data" 362. Table "quarterlyreport_signer" 363. Table "quarterlyreportsubtype" 364. Table "questionnaire" 365. Table "questionnaire_formconfigurator_field" 366. Table "questionnaire_responses" 367. Table "queuecommand" 368. Table "reference" 369. Table "regdomprotobase" 370. Table "regdomtypeviolation" 371. Table "regulatorydomain" 372. Table "regulatorydomaincontent" 373. Table "sanction" 374. Table "signalparameters" 375. Table "statistic_occurrence" 376. Table "sundmuskoha_vaatlusprotokoll" 377. Table "techinspectiontemplate" 378. Table "technicalinspection" 379. Table "technicalinspection_formconfigurator_field" 380. Table "technicalinspection_gas" 381. Table "technicalinspection_gas_inspectiontype" 382. Table "technicalinspection_inspectiontype" 383. Table "technicalinspection_version" 384. Table "templates" 385. Table "traindrivercert" 386. Table "traindrivercert_infrastructure" 387. Table "traindrivercert_languageinspection" 388. Table "traindrivercert_languageproficiency" 389. Table "traindrivercert_modification" 390. Table "traindrivercert_revocation" 391. Table "traindrivercert_suspension" 392. Table "traindrivercert_update" 393. Table "traindriverexam" 394. Table "traindriverexam_known_infrastructure" 395. Table "traindriverexam_knownrollingstock" 396. Table "traindriverlicence_application" 397. Table "traindriverlicence_send" 398. Table "translation_label" 399. Table "translation_marker" 400. Table "userlog_log" 401. Table "userlog_metadata" 402. Table "userlog_row" 403. Table "userlog_user" 404. Table "vaarteomenetluse_alustamata_jatmise_teatis" 405. Table "vaarteomenetluse_lopetamise_maarus" 406. Table "vabatoiming" 407. Table "visit" 408. Table "warning" 409. Table "warning_bystander" 410. Table "warning_person" 411. Table "warning_precept_row_penalty" 412. Table "warning_signer" 413. Table "we_classifier_deleted_label" 414. Table "we_items_export_queue" 415. Table "we_media_dummy" 416. Table "we_media_formconfigurator_token" 417. Table "xrd_modified_ref" 418. Table "yldmenetluse_otsus"