Guest User

Промт для теста text-to-SQL 9 (museum_5)

a guest
Jul 5th, 2025
23
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 67.06 KB | None | 0 0
  1. <НАЗВАНИЕ ТЕСТА>museum_5</НАЗВАНИЕ ТЕСТА>
  2. <ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>Нужно преобразовать запрос в свободной форме (тег «ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ») в SQL-запрос, воспользовавшись схемой базы данных (тег «СХЕМА БАЗЫ ДАННЫХ») и словарём знаний (тег «СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ»). При наличии комментариев и пояснений пишите их на русском языке.</ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>
  3. <ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>Show me whether items are in Accelerated Deterioration (Yes/No). For each artifact, determine if its Deterioration Index exceeds the accelerated threshold.</ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>
  4. <ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>Покажите для каждого экспоната, подпадает ли он под «ускоренное» ухудшение (Да/Нет). Определите, превышает ли его индекс ухудшения порог ускоренного.</ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>
  5. <СХЕМА БАЗЫ ДАННЫХ>
  6. CREATE TABLE "artifactscore" (
  7. artregistry character NOT NULL, /* CHAR(10) PRIMARY KEY uniquely identifying each artifact record (e.g., 'ART000012'). */
  8. artname character varying NOT NULL, /* VARCHAR(100) providing the artifact’s name or label (free text, no strict list). */
  9. artdynasty character varying NULL, /* VARCHAR(50) indicating the historical period/era/dynasty (e.g., 'Ming', 'Song', 'Qing', 'Han', 'Tang', 'Yuan'). No strict enumeration. */
  10. artageyears integer NULL, /* INT denoting the artifact’s approximate age in years (any integer value). */
  11. mattype USER-DEFINED NULL, /* CHAR(30) showing the artifact’s primary material (e.g., 'Stone', 'Textile', 'Bronze', 'Jade', 'Wood', 'Ceramic', 'Paper'). Could be enumerated by your policy but often open-ended. */
  12. conservestatus USER-DEFINED NULL, /* VARCHAR(150) describing the artifact’s current conservation condition. Possible values might include 'Excellent', 'Good', 'Fair', 'Poor', 'Critical'. */
  13. PRIMARY KEY (artregistry)
  14. );
  15.  
  16. First 3 rows:
  17. artregistry artname artdynasty artageyears mattype conservestatus
  18. ------------- ---------------- ------------ ------------- --------- ----------------
  19. ART54317 Culture Painting Ming 943 Stone Good
  20. ART54254 Poor Vase Song 2179 Textile Fair
  21. ART69978 Order Painting Qing 366 Bronze Poor
  22. ...
  23.  
  24.  
  25. CREATE TABLE "surfaceandphysicalreadings" (
  26. surfphysregistry bigint NOT NULL DEFAULT nextval('surfaceandphysicalreadings_surfphysregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, unique ID for each surface/physical reading record. */
  27. envreadref bigint NOT NULL, /* BIGINT FOREIGN KEY referencing EnvironmentalReadingsCore(EnvReadRegistry). Ties surface data to a general environment reading. */
  28. vibralvlmms2 real NULL, /* REAL measuring vibration level in mm/s² (millimeters per second squared). */
  29. noisedb smallint NULL, /* SMALLINT capturing noise level in decibels (dB). */
  30. dustaccummgm2 numeric NULL, /* NUMERIC(5,2) for dust accumulation in milligrams per square meter (mg/m²). */
  31. microbialcountcfu integer NULL, /* INT counting colony-forming units (CFU) of microbes on surfaces. */
  32. moldriskidx numeric NULL, /* NUMERIC(4,2) representing a calculated mold risk index (e.g., 0–10). */
  33. pestactivitylvl character varying NULL, /* VARCHAR(50) noting observed pest activity (could be enumerations like 'Medium', 'Low', 'High'). */
  34. pesttrapcount smallint NULL, /* SMALLINT indicating how many pests were caught in traps (if applicable). */
  35. pestspeciesdetected text NULL, /* TEXT listing pest species observed or identified (e.g., 'Beetles', 'Booklice', 'Moths', 'Silverfish'). */
  36. surfaceph numeric NULL, /* NUMERIC(3,1) measuring pH on the artifact’s surface. */
  37. matmoistcontent numeric NULL, /* NUMERIC(4,2) for the material’s moisture content in percentage (0–100%). */
  38. saltcrystalrisk character NULL, /* CHAR(20) describing risk of salt crystallization (possible values: 'High', 'Low', 'Medium'). */
  39. metalcorroderate numeric NULL, /* NUMERIC(4,2) capturing corrosion rate for metal surfaces, e.g., mg/cm² per day. */
  40. organicdegradidx numeric NULL, /* NUMERIC(4,2) measuring potential organic degradation (e.g., 0–10 scale). */
  41. colorchangedeltae real NULL, /* REAL indicating color change (Delta E) measurement. */
  42. surfacetempc numeric NULL, /* NUMERIC(5,2) temperature of the surface in Celsius. */
  43. surfacerh numeric NULL, /* NUMERIC(4,1) relative humidity at the surface (percentage). */
  44. condenserisk character varying NULL, /* VARCHAR(60) describing condensation risk level (possible values: 'Medium', 'High', 'Low'). */
  45. thermalimgstatus character NULL, /* CHAR(15) summarizing thermal imaging results (possible values: 'Normal', 'Critical', 'Attention Required'). */
  46. structstability character varying NULL, /* VARCHAR(50) describing structural stability (possible values: 'Stable', 'Minor Issues', 'Major Issues'). */
  47. crackmonitor text NULL, /* TEXT field noting crack monitoring details (possible values: 'Significant Changes', 'Minor Changes', 'No Changes'). */
  48. deformmm numeric NULL, /* NUMERIC(5,2) measuring any deformation in millimeters. */
  49. wtchangepct numeric NULL, /* NUMERIC(6,5) capturing weight change in percentage (e.g., 0.00001–99.99999). */
  50. surfdustcoverage smallint NULL, /* SMALLINT representing the percentage of surface area covered by dust (0–100%). */
  51. o2concentration numeric NULL, /* NUMERIC(4,2) measuring oxygen concentration (e.g., 21.00% for normal air). */
  52. n2concentration numeric NULL, /* NUMERIC(4,2) measuring nitrogen concentration (often ~78.00% in air). */
  53. PRIMARY KEY (surfphysregistry),
  54. FOREIGN KEY (envreadref) REFERENCES environmentalreadingscore(envreadregistry)
  55. );
  56.  
  57. First 3 rows:
  58. surfphysregistry envreadref vibralvlmms2 noisedb dustaccummgm2 microbialcountcfu moldriskidx pestactivitylvl pesttrapcount pestspeciesdetected surfaceph matmoistcontent saltcrystalrisk metalcorroderate organicdegradidx colorchangedeltae surfacetempc surfacerh condenserisk thermalimgstatus structstability crackmonitor deformmm wtchangepct surfdustcoverage o2concentration n2concentration
  59. ------------------ ------------ -------------- --------- --------------- ------------------- ------------- ----------------- --------------- --------------------- ----------- ----------------- ----------------- ------------------ ------------------ ------------------- -------------- ----------- -------------- ------------------ ----------------- ------------------- ---------- ------------- ------------------ ----------------- -----------------
  60. 1 1 0.461 47 1.74 234 0.1 Medium 10 6.7 10.3 High 0.04 0.47 1.99 19.11 45.5 Medium Normal Stable Significant Changes 0.08 -0.001 5 20.8 78.75
  61. 2 2 0.053 50 0.39 450 0.33 Low 6 6.5 11 High 0.05 0.37 0.87 20.09 53 Critical Stable Significant Changes 0.07 -0.011 4 20.53 78.3
  62. 3 3 0.018 42 2.77 486 0.43 Low 7 Beetles 6.6 10.1 Low 0.02 0.92 1.48 20.53 54.8 Critical Stable Minor Changes 0.16 -0.099 3 20.31 78.62
  63. ...
  64.  
  65.  
  66. CREATE TABLE "usagerecords" (
  67. usagerecordregistry bigint NOT NULL DEFAULT nextval('usagerecords_usagerecordregistry_seq'::regclass), /* A BIGSERIAL primary key uniquely identifying each usage record. */
  68. artrefused character NOT NULL, /* A CHAR(10) NOT NULL foreign key referencing ArtifactsCore(ArtRegistry), indicating which artifact is being used. */
  69. showcaserefused character NULL, /* A CHAR(12) foreign key referencing Showcases(ShowcaseReg) if a showcase is involved in the usage. */
  70. sensdatalink bigint NULL, /* A BIGINT foreign key referencing SensitivityData(SensitivityRegistry). Links usage requirements to known sensitivities. */
  71. displayrotatesched character NULL, /* A CHAR(20) describing how often the artifact is rotated (possible values: 'Permanent', 'Resting', 'Active'). */
  72. displaydurmonths smallint NULL, /* A SMALLINT indicating how many months the artifact is displayed in a single rotation. */
  73. restperiodmonths smallint NULL, /* A SMALLINT for how many months the artifact rests between rotations. */
  74. displayreqs character varying NULL, /* A VARCHAR(120) listing any special display requirements (possible values: 'Special', 'Standard', 'Custom'). */
  75. storagereqs character varying NULL, /* A VARCHAR(60) describing special storage requirements (possible values: 'Standard', 'Custom', 'Special'). */
  76. handlingreqs character varying NULL, /* A VARCHAR(80) specifying guidelines for handling (possible values: 'Custom', 'Special', 'Standard'). */
  77. transportreqs text NULL, /* A TEXT field detailing transport requirements (possible values: 'Custom', 'Special', 'Standard'). */
  78. packingreqs character varying NULL, /* A VARCHAR(90) summarizing packing methods (possible values: 'Custom', 'Special', 'Standard'). */
  79. resaccessfreq character NULL, /* A CHAR(10) indicating how often the artifact is accessed for research (possible values: 'Frequent', 'Rare', 'Occasional'). */
  80. publicdispfreq character NULL, /* A CHAR(15) describing how often the artifact goes on public display (possible values: 'Frequent', 'Occasional', 'Rare'). */
  81. loanfreq character NULL, /* A CHAR(12) specifying how frequently the artifact is loaned out (possible values: 'Occasional', 'Frequent', 'Rare'). */
  82. handlefreq character NULL, /* A CHAR(10) indicating how frequently the artifact is handled (possible values: 'Rare', 'Frequent', 'Occasional'). */
  83. docufreq character varying NULL, /* A VARCHAR(20) describing how often documentation is updated (possible values: 'Frequent', 'Rare', 'Occasional'). */
  84. monitorfreq character varying NULL, /* A VARCHAR(35) for how often the artifact is monitored (possible values: 'Monthly', 'Daily', 'Weekly'). */
  85. assessfreq character NULL, /* A CHAR(15) for the frequency of condition assessments (possible values: 'Monthly', 'Quarterly', 'Annually'). */
  86. maintfreq character NULL, /* A CHAR(15) indicating the maintenance schedule (possible values: 'Monthly', 'Weekly', 'Quarterly'). */
  87. inspectfreq character NULL, /* A CHAR(15) describing the routine inspection frequency (possible values: 'Weekly', 'Monthly', 'Daily'). */
  88. calibfreq character NULL, /* A CHAR(15) stating how often instruments are calibrated (possible values: 'Monthly', 'Quarterly', 'Annually'). */
  89. certstatus character varying NULL, /* A VARCHAR(40) noting any certification status (possible values: 'Expired', 'Current', 'Pending'). */
  90. compliancestatus character varying NULL, /* A VARCHAR(55) summarizing compliance (possible values: 'Non-compliant', 'Partial', 'Compliant'). */
  91. auditstatus USER-DEFINED NULL, /* A CHAR(10) indicating the result of a related audit (possible values: 'Passed', 'Pending', 'Failed'). */
  92. qualityctrlstatus USER-DEFINED NULL, /* A VARCHAR(70) describing quality control status (possible values: 'Failed', 'Passed', 'Review'). */
  93. PRIMARY KEY (usagerecordregistry),
  94. FOREIGN KEY (artrefused) REFERENCES artifactscore(artregistry),
  95. FOREIGN KEY (sensdatalink) REFERENCES sensitivitydata(sensitivityregistry),
  96. FOREIGN KEY (showcaserefused) REFERENCES showcases(showcasereg)
  97. );
  98.  
  99. First 3 rows:
  100. usagerecordregistry artrefused showcaserefused sensdatalink displayrotatesched displaydurmonths restperiodmonths displayreqs storagereqs handlingreqs transportreqs packingreqs resaccessfreq publicdispfreq loanfreq handlefreq docufreq monitorfreq assessfreq maintfreq inspectfreq calibfreq certstatus compliancestatus auditstatus qualityctrlstatus
  101. --------------------- ------------ ----------------- -------------- -------------------- ------------------ ------------------ ------------- ------------- -------------- --------------- ------------- --------------- ---------------- ---------- ------------ ---------- ------------- ------------ ----------- ------------- ----------- ------------ ------------------ ------------- -------------------
  102. 1 ART54317 SC9857 1 Permanent 1 22 Special Standard Custom Custom Custom Frequent Frequent Occasional Rare Frequent Monthly Monthly Monthly Weekly Monthly Expired Non-compliant Passed Failed
  103. 2 ART54254 SC7393 2 Resting 5 11 Standard Custom Special Special Special Rare Frequent Frequent Rare Rare Daily Quarterly Weekly Monthly Quarterly Current Partial Pending Failed
  104. 3 ART69978 SC9391 3 Permanent 6 10 Custom Custom Standard Standard Special Rare Occasional Occasional Rare Frequent Weekly Quarterly Weekly Daily Monthly Pending Non-compliant Failed Passed
  105. ...
  106.  
  107.  
  108. CREATE TABLE "artifactratings" (
  109. ratingrecordregistry bigint NOT NULL DEFAULT nextval('artifactratings_ratingrecordregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, unique ID for each rating record. */
  110. artref character NOT NULL, /* CHAR(10) FOREIGN KEY referencing ArtifactsCore(ArtRegistry). Links the record to a specific artifact. */
  111. histsignrating smallint NULL, /* SMALLINT rating for historical significance (scale is flexible). */
  112. researchvalrating integer NULL, /* INT rating for research value (range is flexible). */
  113. exhibitvalrating integer NULL, /* INT rating evaluating the artifact’s exhibition value (scale is flexible). */
  114. cultscore smallint NULL, /* SMALLINT measuring the artifact’s cultural importance (common range or flexible scale). */
  115. publicaccessrating smallint NULL, /* SMALLINT rating the artifact’s public accessibility or appeal (scale is flexible). */
  116. eduvaluerating bigint NULL, /* BIGINT rating for how much educational value the artifact provides (scale is flexible). */
  117. conservediff USER-DEFINED NULL, /* VARCHAR(100) describing difficulty in conserving the artifact (possible values: 'Medium', 'High', 'Low'). */
  118. treatcomplexity character NULL, /* CHAR(10) indicating treatment complexity (possible values: 'Complex', 'Moderate', 'Simple'). */
  119. matstability character varying NULL, /* VARCHAR(30) for material stability classification (possible values: 'Unstable', 'Stable', 'Moderate'). */
  120. deteriorrate text NULL, /* TEXT field detailing the specific deterioration rate or pattern (e.g., 'Moderate', 'Rapid', 'Slow'). */
  121. PRIMARY KEY (ratingrecordregistry),
  122. FOREIGN KEY (artref) REFERENCES artifactscore(artregistry)
  123. );
  124.  
  125. First 3 rows:
  126. ratingrecordregistry artref histsignrating researchvalrating exhibitvalrating cultscore publicaccessrating eduvaluerating conservediff treatcomplexity matstability deteriorrate
  127. ---------------------- -------- ---------------- ------------------- ------------------ ----------- -------------------- ---------------- -------------- ----------------- -------------- --------------
  128. 1 ART54317 7 9 4 25 9 9 Medium Complex Unstable Moderate
  129. 2 ART54254 3 5 7 13 1 3 High Moderate Stable Rapid
  130. 3 ART69978 5 10 4 4 7 3 High Moderate Moderate Rapid
  131. ...
  132.  
  133.  
  134. CREATE TABLE "lightandradiationreadings" (
  135. lightradregistry bigint NOT NULL DEFAULT nextval('lightandradiationreadings_lightradregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, uniquely identifying each light/radiation reading. */
  136. envreadref bigint NOT NULL, /* BIGINT FOREIGN KEY referencing EnvironmentalReadingsCore(EnvReadRegistry). Associates light data with an existing environment reading. */
  137. lightlux integer NULL, /* INT measuring visible light intensity in lux. */
  138. uvuwcm2 numeric NULL, /* NUMERIC(6,2) capturing UV radiation in microwatts per cm² (µW/cm²). */
  139. irwm2 numeric NULL, /* NUMERIC(6,2) measuring infrared radiation in W/m². */
  140. visibleexplxh integer NULL, /* INT indicating total visible light exposure over time in lux-hours (Lx·h). */
  141. PRIMARY KEY (lightradregistry),
  142. FOREIGN KEY (envreadref) REFERENCES environmentalreadingscore(envreadregistry)
  143. );
  144.  
  145. First 3 rows:
  146. lightradregistry envreadref lightlux uvuwcm2 irwm2 visibleexplxh
  147. ------------------ ------------ ---------- --------- ------- ---------------
  148. 1 1 91 32.58 7.51 71166
  149. 2 2 138 64.99 7.81 69438
  150. 3 3 71 66.82 5.47 75541
  151. ...
  152.  
  153.  
  154. CREATE TABLE "artifactsecurityaccess" (
  155. secrecordregistry bigint NOT NULL DEFAULT nextval('artifactsecurityaccess_secrecordregistry_seq'::regclass), /* A BIGSERIAL primary key uniquely identifying each artifact security/access record. */
  156. artref character NOT NULL, /* A CHAR(10) NOT NULL foreign key referencing ArtifactsCore(ArtRegistry). Links this security record to a specific artifact. */
  157. ratingref bigint NULL, /* A BIGINT foreign key referencing ArtifactRatings(RatingRecordRegistry). Associates this security record with a particular artifact rating, if relevant. */
  158. loanstatus character NULL, /* A CHAR(15) indicating the artifact’s loan status (possible values: 'On Loan', 'Available', 'Not Available'). */
  159. insvalueusd numeric NULL, /* A NUMERIC(15,2) specifying the artifact’s insured value in USD. */
  160. seclevel character varying NULL, /* A VARCHAR(50) describing the security level (possible values: 'Level 3', 'Level 2', 'Level 1'). */
  161. accessrestrictions text NULL, /* A TEXT field detailing constraints on handling/viewing (possible values: 'Public', 'Restricted', 'Limited'). */
  162. docustatus character varying NULL, /* A VARCHAR(60) indicating the completeness of documentation (possible values: 'Updating', 'Partial', 'Complete'). */
  163. photodocu character varying NULL, /* A VARCHAR(100) noting photographic documentation status (possible values: 'Outdated', 'Required', 'Recent'). */
  164. condreportstatus character varying NULL, /* A VARCHAR(80) describing the artifact’s condition report status (possible values: 'Current', 'Due', 'Overdue'). */
  165. conserverecstatus character NULL, /* A CHAR(20) summarizing conservation record status (possible values: 'Review Required', 'Pending', 'Updated'). */
  166. researchaccessstatus character varying NULL, /* A VARCHAR(40) indicating if the artifact is open to researchers (possible values: 'Limited', 'Available', 'Restricted'). */
  167. digitalrecstatus text NULL, /* A TEXT field specifying any digital records or scans (possible values: 'In Progress', 'Partial', 'Complete'). */
  168. PRIMARY KEY (secrecordregistry),
  169. FOREIGN KEY (artref) REFERENCES artifactscore(artregistry),
  170. FOREIGN KEY (ratingref) REFERENCES artifactratings(ratingrecordregistry)
  171. );
  172.  
  173. First 3 rows:
  174. secrecordregistry artref ratingref loanstatus insvalueusd seclevel accessrestrictions docustatus photodocu condreportstatus conserverecstatus researchaccessstatus digitalrecstatus
  175. ------------------- -------- ----------- ------------ ------------- ---------- -------------------- ------------ ----------- ------------------ ------------------- ---------------------- ------------------
  176. 1 ART54317 1 On Loan 968368 Level 3 Public Updating Outdated Current Review Required Limited In Progress
  177. 2 ART54254 2 Available 36135 Level 3 Public Partial Required Due Pending Limited Partial
  178. 3 ART69978 3 On Loan 330049 Level 2 Restricted Partial Required Current Review Required Limited Partial
  179. ...
  180.  
  181.  
  182. CREATE TABLE "sensitivitydata" (
  183. sensitivityregistry bigint NOT NULL DEFAULT nextval('sensitivitydata_sensitivityregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, unique ID for each record of sensitivity details. */
  184. artref character NOT NULL, /* CHAR(10) FOREIGN KEY referencing ArtifactsCore(ArtRegistry). */
  185. envsensitivity character NULL, /* CHAR(20) for overall environmental sensitivity (possible values: 'Low', 'High', 'Medium'). */
  186. lightsensitivity character varying NULL, /* VARCHAR(80) describing light/UV sensitivity (possible values: 'High', 'Low', 'Medium'). */
  187. tempsensitivity character varying NULL, /* VARCHAR(50) summarizing temperature tolerance (possible values: 'High', 'Low', 'Medium'). */
  188. humiditysensitivity text NULL, /* TEXT detailing humidity requirements or maximum humidity tolerance (possible values: 'Medium', 'High', 'Low'). */
  189. vibrasensitivity character NULL, /* CHAR(20) describing vibration tolerance (possible values: 'Medium', 'High', 'Low'). */
  190. pollutantsensitivity character varying NULL, /* VARCHAR(100) indicating susceptibility to pollutants (possible values: 'High', 'Medium', 'Low'). */
  191. pestsensitivity text NULL, /* TEXT describing vulnerability to pests (possible values: 'High', 'Low', 'Medium'). */
  192. handlesensitivity character NULL, /* CHAR(20) for handling sensitivity (possible values: 'Medium', 'Low', 'High'). */
  193. transportsensitivity character varying NULL, /* VARCHAR(50) specifying special packaging needs (possible values: 'High', 'Low', 'Medium'). */
  194. displaysensitivity character varying NULL, /* VARCHAR(120) noting special display requirements (possible values: 'Low', 'High', 'Medium'). */
  195. storagesensitivity text NULL, /* TEXT detailing storage conditions (possible values: 'Medium', 'Low', 'High'). */
  196. PRIMARY KEY (sensitivityregistry),
  197. FOREIGN KEY (artref) REFERENCES artifactscore(artregistry)
  198. );
  199.  
  200. First 3 rows:
  201. sensitivityregistry artref envsensitivity lightsensitivity tempsensitivity humiditysensitivity vibrasensitivity pollutantsensitivity pestsensitivity handlesensitivity transportsensitivity displaysensitivity storagesensitivity
  202. --------------------- -------- ---------------- ------------------ ----------------- --------------------- ------------------ ---------------------- ----------------- ------------------- ---------------------- -------------------- --------------------
  203. 1 ART54317 Low High High Medium Medium High High Medium High Low Medium
  204. 2 ART54254 High Low Low High High Medium Low Medium High Low Low
  205. 3 ART69978 High High Medium Low Low High High Low Low High Medium
  206. ...
  207.  
  208.  
  209. CREATE TABLE "conditionassessments" (
  210. conditionassessregistry bigint NOT NULL DEFAULT nextval('conditionassessments_conditionassessregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, unique ID for each condition assessment record. */
  211. artrefexamined text NOT NULL, /* TEXT NOT NULL FOREIGN KEY referencing ArtifactsCore(ArtRegistry). Links to the artifact under assessment. (In practice, should match CHAR(10) type if needed.) */
  212. showcaserefexamined text NULL, /* TEXT FOREIGN KEY referencing Showcases(ShowcaseReg). Ties the record to the showcase if it was part of the assessment. */
  213. lightreadrefobserved bigint NULL, /* BIGINT FOREIGN KEY referencing LightAndRadiationReadings(LightRadRegistry). Associates the assessment with relevant light data. */
  214. condassessscore integer NULL, /* INT rating or score representing the artifact/showcase condition (scale is flexible). */
  215. conserveassessdate date NULL, /* DATE when the conservation assessment took place. */
  216. nextassessdue date NULL, /* DATE by which the next condition assessment should occur. */
  217. PRIMARY KEY (conditionassessregistry),
  218. FOREIGN KEY (artrefexamined) REFERENCES artifactscore(artregistry),
  219. FOREIGN KEY (lightreadrefobserved) REFERENCES lightandradiationreadings(lightradregistry),
  220. FOREIGN KEY (showcaserefexamined) REFERENCES showcases(showcasereg)
  221. );
  222.  
  223. First 3 rows:
  224. conditionassessregistry artrefexamined showcaserefexamined lightreadrefobserved condassessscore conserveassessdate nextassessdue
  225. ------------------------- ---------------- --------------------- ---------------------- ----------------- -------------------- ---------------
  226. 1 ART54317 SC9857 1 93 2024-09-15 2025-04-17
  227. 2 ART54254 SC7393 2 48 2024-03-27 2025-09-09
  228. 3 ART69978 SC9391 3 61 2024-05-01 2025-11-10
  229. ...
  230.  
  231.  
  232. CREATE TABLE "exhibitionhalls" (
  233. hallrecord character NOT NULL,
  234. cctvcoverage character varying NULL, /* VARCHAR(100) describing the CCTV coverage (possible values: 'Partial', 'Full', 'Limited'). */
  235. motiondetectstatus character varying NULL, /* VARCHAR(50) summarizing motion detection status (possible values: 'Active', 'Maintenance', 'Partial'). */
  236. alarmsysstatus character NULL, /* CHAR(15) for alarm system status (possible values: 'Armed', 'Maintenance', 'Partial'). */
  237. accessctrlstatus character varying NULL, /* VARCHAR(80) describing the level of access control (possible values: 'Maintenance', 'Active', 'Partial'). */
  238. visitorcountdaily integer NULL, /* INT representing the typical or observed daily visitor count (unbounded integer). */
  239. visitorflowrate USER-DEFINED NULL, /* SMALLINT indicating how many visitors pass through (possible values: 'Low', 'Medium', 'High'). */
  240. visitordwellmin smallint NULL, /* SMALLINT specifying the average dwell time (in minutes) per visitor. */
  241. visitorbehaviornotes text NULL, /* TEXT field for any additional notes on visitor behaviors, traffic patterns, or compliance issues. */
  242. PRIMARY KEY (hallrecord),
  243. FOREIGN KEY (hallrecord) REFERENCES artifactscore(artregistry)
  244. );
  245.  
  246. First 3 rows:
  247. hallrecord cctvcoverage motiondetectstatus alarmsysstatus accessctrlstatus visitorcountdaily visitorflowrate visitordwellmin visitorbehaviornotes
  248. ------------ -------------- -------------------- ---------------- ------------------ ------------------- ----------------- ----------------- ----------------------
  249. ART54317 Partial Active Armed Maintenance 308 Low 16 Poor
  250. ART54254 Full Maintenance Armed Active 993 Low 11 Poor
  251. ART69978 Limited Partial Maintenance Partial 19 Medium 20 Good
  252. ...
  253.  
  254.  
  255. CREATE TABLE "riskassessments" (
  256. riskassessregistry bigint NOT NULL DEFAULT nextval('riskassessments_riskassessregistry_seq'::regclass), /* A BIGSERIAL primary key uniquely identifying each risk assessment record. */
  257. artrefconcerned character NOT NULL, /* A CHAR(10) NOT NULL foreign key referencing ArtifactsCore(ArtRegistry), linking this record to a specific artifact. */
  258. hallrefconcerned character NULL, /* A CHAR(8) foreign key referencing ExhibitionHalls(HallRegistry), indicating which hall is involved in this risk assessment (if any). */
  259. riskassesslevel USER-DEFINED NULL, /* A VARCHAR(50) describing the level of risk (possible values: 'Medium', 'High', 'Low'). */
  260. emergresponseplan text NULL, /* A TEXT field outlining the emergency response procedures if the risk materializes (possible values: 'Review Required', 'Under Revision', 'Updated'). */
  261. evacpriority character varying NULL, /* A CHAR(15) indicating the priority for evacuation (possible values: 'Priority 3', 'Priority 1', 'Priority 2'). */
  262. handlerestrictions character varying NULL, /* A VARCHAR(100) describing any handling restrictions (possible values: 'Minimal', 'Strict'). */
  263. conservepriorityscore smallint NULL, /* A SMALLINT rating (e.g., 1–10) indicating the urgency or priority for conservation actions based on identified risks. */
  264. PRIMARY KEY (riskassessregistry),
  265. FOREIGN KEY (artrefconcerned) REFERENCES artifactscore(artregistry),
  266. FOREIGN KEY (hallrefconcerned) REFERENCES exhibitionhalls(hallrecord)
  267. );
  268.  
  269. First 3 rows:
  270. riskassessregistry artrefconcerned hallrefconcerned riskassesslevel emergresponseplan evacpriority handlerestrictions conservepriorityscore
  271. -------------------- ----------------- ------------------ ----------------- ------------------- -------------- -------------------- -----------------------
  272. 1 ART54317 ART54317 Medium Review Required Priority 3 Minimal 85
  273. 2 ART54254 ART54254 Medium Under Revision Priority 1 Strict 76
  274. 3 ART69978 ART69978 Medium Updated Priority 2 Minimal 91
  275. ...
  276.  
  277.  
  278. CREATE TABLE "showcases" (
  279. showcasereg character NOT NULL, /* CHAR(12) PRIMARY KEY for identifying each showcase (e.g., 'SHOW00000012'). */
  280. hallref character NULL, /* CHAR(8) FOREIGN KEY referencing ExhibitionHalls(HallRegistry). Connects the showcase to a particular hall. */
  281. airtightness real NULL, /* REAL measuring the physical seal quality, often tested as a numeric rating or leakage rate. */
  282. showcasematerial character varying NULL, /* VARCHAR(80) describing the material (possible values: 'Tempered Glass', 'Glass', 'Acrylic'). */
  283. sealcondition character varying NULL, /* VARCHAR(30) indicating the seal’s condition (possible values: 'Poor', 'Excellent', 'Good', 'Fair'). */
  284. maintstatus character NULL, /* CHAR(15) for the showcase’s maintenance status (possible values: 'Overdue', 'Due', 'Good'). */
  285. filterstatus text NULL, /* TEXT detailing installed filters (possible values: 'Replace Now', 'Replace Soon', 'Clean'). */
  286. silicagelstatus character NULL, /* CHAR(20) noting the condition of silica gel (possible values: 'Active', 'Replace Soon', 'Replace Now'). */
  287. silicagelchangedate date NULL, /* DATE of the last silica gel replacement or recharge. */
  288. humiditybuffercap smallint NULL, /* SMALLINT rating or index of the showcase’s capacity to buffer humidity. */
  289. pollutantabsorbcap numeric NULL, /* NUMERIC(5,2) for the pollutant absorption capacity (quantity or threshold). */
  290. leakrate real NULL, /* REAL specifying the rate of air leakage, often tested to ensure stable internal conditions. */
  291. pressurepa bigint NULL, /* BIGINT capturing the internal pressure (in pascals) if pressurization is used. */
  292. inertgassysstatus character varying NULL, /* VARCHAR(50) describing any inert gas system status (possible values: 'Active', 'Standby', 'Maintenance'). */
  293. firesuppresssys character varying NULL, /* VARCHAR(50) summarizing fire suppression condition (possible values: 'Maintenance', 'Active', 'Standby'). */
  294. empowerstatus character NULL, /* CHAR(10) indicating emergency power readiness (possible values: 'Testing', 'Active', 'Standby'). */
  295. backupsysstatus text NULL, /* TEXT describing any backup systems (possible values: 'Ready', 'Maintenance', 'Testing') and their condition. */
  296. PRIMARY KEY (showcasereg),
  297. FOREIGN KEY (hallref) REFERENCES exhibitionhalls(hallrecord)
  298. );
  299.  
  300. First 3 rows:
  301. showcasereg hallref airtightness showcasematerial sealcondition maintstatus filterstatus silicagelstatus silicagelchangedate humiditybuffercap pollutantabsorbcap leakrate pressurepa inertgassysstatus firesuppresssys empowerstatus backupsysstatus
  302. ------------- --------- -------------- ------------------ --------------- ------------- -------------- ----------------- --------------------- ------------------- -------------------- ---------- ------------ ------------------- ----------------- --------------- -----------------
  303. SC9857 ART54317 95.1 Tempered Glass Poor Overdue Replace Now Active 2024-09-15 81 71.7 0.41 -2 Active Maintenance Testing Ready
  304. SC7393 ART54254 93 Tempered Glass Excellent Overdue Replace Now Active 2024-12-15 78 79.8 0.07 3 Standby Active Active Maintenance
  305. SC9391 ART69978 99.4 Glass Good Due Replace Soon Replace Soon 2024-12-21 92 66.3 0.2 -3 Active Active Active Testing
  306. ...
  307.  
  308.  
  309. CREATE TABLE "conservationandmaintenance" (
  310. conservemaintregistry bigint NOT NULL DEFAULT nextval('conservationandmaintenance_conservemaintregistry_seq'::regclass), /* A BIGSERIAL primary key uniquely identifying each record of conservation and maintenance. */
  311. artrefmaintained character NOT NULL, /* A CHAR(10) NOT NULL foreign key referencing ArtifactsCore(ArtRegistry). Ties this record to the maintained artifact. */
  312. hallrefmaintained character NULL, /* A CHAR(8) foreign key referencing ExhibitionHalls(HallRegistry), if the conservation applies to a specific hall area. */
  313. surfreadrefobserved bigint NULL, /* A BIGINT foreign key referencing SurfaceAndPhysicalReadings(SurfPhysRegistry). Links to surface/physical readings used in this maintenance record. */
  314. conservetreatstatus character varying NULL, /* A VARCHAR(50) describing the status of conservation treatment (possible values: 'In Progress', 'Not Required', 'Scheduled'). */
  315. treatpriority character NULL, /* A CHAR(10) indicating the priority of the treatment (possible values: 'High', 'Medium', 'Low', 'Urgent'). */
  316. lastcleaningdate date NULL, /* A DATE specifying the last cleaning date of the artifact/hall/showcase. */
  317. nextcleaningdue date NULL, /* A DATE indicating when the next cleaning is scheduled or recommended. */
  318. cleanintervaldays smallint NULL, /* A SMALLINT capturing the recommended cleaning interval in days. */
  319. maintlog text NULL, /* A TEXT field describing any notes, log details, or issues encountered during maintenance activities (possible values: 'Updated', 'Pending', 'Review'). */
  320. incidentreportstatus character varying NULL, /* A VARCHAR(50) summarizing the status of any incident reports (possible values: 'Closed', 'Open'). */
  321. emergencydrillstatus character NULL, /* A CHAR(15) indicating whether emergency drills are 'Current', 'Overdue', 'Due', etc. */
  322. stafftrainstatus character NULL, /* A VARCHAR(20) describing staff training status (possible values: 'Current', 'Overdue', 'Due'). */
  323. budgetallocstatus character varying NULL, /* A VARCHAR(50) describing budget allocation status (possible values: 'Review Required', 'Insufficient', 'Adequate'). */
  324. maintbudgetstatus character NULL, /* A CHAR(15) indicating if the current maintenance budget is 'Limited', 'Depleted', 'Available', etc. */
  325. conservefreq USER-DEFINED NULL, /* A VARCHAR(30) describing the frequency of conservation efforts (possible values: 'Rare', 'Occasional', 'Frequent'). */
  326. intervhistory text NULL, /* A TEXT field detailing the intervention or treatment history (possible values: 'Extensive', 'Minimal', 'Moderate'). */
  327. prevtreatments smallint NULL, /* A SMALLINT counting how many significant treatments have been done previously on this artifact/hall. */
  328. treateffectiveness character varying NULL, /* A VARCHAR(100) summarizing how effective previous treatments were (possible values: 'Low', 'Medium', 'High'). */
  329. reversibilitypotential USER-DEFINED NULL, /* A TEXT field describing if and how treatments can be reversed (possible values: 'Medium', 'High', 'Low'). */
  330. PRIMARY KEY (conservemaintregistry),
  331. FOREIGN KEY (artrefmaintained) REFERENCES artifactscore(artregistry),
  332. FOREIGN KEY (hallrefmaintained) REFERENCES exhibitionhalls(hallrecord),
  333. FOREIGN KEY (surfreadrefobserved) REFERENCES surfaceandphysicalreadings(surfphysregistry)
  334. );
  335.  
  336. First 3 rows:
  337. conservemaintregistry artrefmaintained hallrefmaintained surfreadrefobserved conservetreatstatus treatpriority lastcleaningdate nextcleaningdue cleanintervaldays maintlog incidentreportstatus emergencydrillstatus stafftrainstatus budgetallocstatus maintbudgetstatus conservefreq intervhistory prevtreatments treateffectiveness reversibilitypotential
  338. ----------------------- ------------------ ------------------- --------------------- --------------------- --------------- ------------------ ----------------- ------------------- ---------- ---------------------- ---------------------- ------------------ ------------------- ------------------- -------------- --------------- ---------------- -------------------- ------------------------
  339. 1 ART54317 ART54317 1 In Progress High 2024-12-16 2025-05-10 83 Updated Closed Current Current Review Required Limited Rare Extensive 4 Low Medium
  340. 2 ART54254 ART54254 2 In Progress Medium 2024-12-13 2025-03-26 27 Updated Overdue Overdue Review Required Depleted Rare Minimal 1 Low High
  341. 3 ART69978 ART69978 3 Not Required Low 2024-11-21 2025-05-14 85 Pending Closed Overdue Overdue Insufficient Limited Rare Moderate 8 Low Low
  342. ...
  343.  
  344.  
  345. CREATE TABLE "environmentalreadingscore" (
  346. envreadregistry bigint NOT NULL DEFAULT nextval('environmentalreadingscore_envreadregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, uniquely identifying each environmental reading record. */
  347. monitorcode character NOT NULL, /* CHAR(10) identifier for the monitoring device or sensor (e.g., 'MON000001'). */
  348. readtimestamp timestamp without time zone NOT NULL, /* TIMESTAMP NOT NULL indicating the date and time the reading was recorded. */
  349. showcaseref character NULL, /* CHAR(12) FOREIGN KEY referencing Showcases(ShowcaseReg), linking the reading to a specific showcase being monitored. */
  350. tempc smallint NULL, /* SMALLINT representing the measured temperature in Celsius. */
  351. tempvar24h real NULL, /* REAL showing the 24-hour variation in temperature (in °C). */
  352. relhumidity integer NULL, /* INT capturing the relative humidity percentage (0–100). */
  353. humvar24h smallint NULL, /* SMALLINT indicating the 24-hour variation in humidity (percentage points). */
  354. airpresshpa real NULL, /* REAL specifying the measured air pressure in hectopascals (hPa). */
  355. PRIMARY KEY (envreadregistry),
  356. FOREIGN KEY (showcaseref) REFERENCES showcases(showcasereg)
  357. );
  358.  
  359. First 3 rows:
  360. envreadregistry monitorcode readtimestamp showcaseref tempc tempvar24h relhumidity humvar24h airpresshpa
  361. ----------------- ------------- -------------------------- ------------- ------- ------------ ------------- ----------- -------------
  362. 1 MM191823 2024-08-06 08:38:48.050280 SC9857 21 0.85 53 2 1020
  363. 2 MM153427 2025-02-07 03:00:17.050280 SC7393 18 1.34 54 1 1013.4
  364. 3 MM675303 2024-07-25 09:37:21.050280 SC9391 21 1.75 47 1 1015.3
  365. ...
  366.  
  367.  
  368. CREATE TABLE "airqualityreadings" (
  369. aqrecordregistry bigint NOT NULL DEFAULT nextval('airqualityreadings_aqrecordregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, uniquely identifying each air-quality reading record. */
  370. envreadref bigint NOT NULL, /* BIGINT FOREIGN KEY referencing EnvironmentalReadingsCore(EnvReadRegistry). Links this record to its main environmental reading. */
  371. co2ppm smallint NULL, /* SMALLINT measuring CO2 concentration in parts per million (ppm). Typical range: 300–2000. */
  372. tvocppb integer NULL, /* INT capturing total volatile organic compounds in parts per billion (ppb). */
  373. ozoneppb integer NULL, /* INT indicating ozone concentration in ppb. */
  374. so2ppb smallint NULL, /* SMALLINT for sulfur dioxide concentration in ppb. */
  375. no2ppb bigint NULL, /* BIGINT for nitrogen dioxide concentration in ppb. */
  376. pm25conc real NULL, /* REAL measuring particulate matter (PM2.5) in µg/m³ or a similar metric. */
  377. pm10conc numeric NULL, /* NUMERIC(5,2) measuring PM10 concentration, possibly µg/m³ as well. */
  378. hchoconc numeric NULL, /* NUMERIC(7,4) for formaldehyde (HCHO) concentration (e.g., mg/m³ or another scale). */
  379. airexrate numeric NULL, /* NUMERIC(4,1) indicating air exchange rate (e.g., air changes per hour). */
  380. airvelms numeric NULL, /* NUMERIC(5,2) capturing air velocity in meters per second (m/s). */
  381. PRIMARY KEY (aqrecordregistry),
  382. FOREIGN KEY (envreadref) REFERENCES environmentalreadingscore(envreadregistry)
  383. );
  384.  
  385. First 3 rows:
  386. aqrecordregistry envreadref co2ppm tvocppb ozoneppb so2ppb no2ppb pm25conc pm10conc hchoconc airexrate airvelms
  387. ------------------ ------------ -------- --------- ---------- -------- -------- ---------- ---------- ---------- ----------- ----------
  388. 1 1 794 89 11 12 27 16.7 34.1 0.014 6.4 0.18
  389. 2 2 539 420 12 18 21 10.7 16.4 0.035 4.3 0.19
  390. 3 3 402 393 47 14 13 5.4 29 0.077 5.9 0.14
  391. ...
  392. </СХЕМА БАЗЫ ДАННЫХ>
  393. <СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
  394. {"id": 0, "knowledge": "Conservation Priority Index (CPI)", "description": "Calculates the overall conservation priority for an artifact based on multiple factors.", "definition": "CPI = \\frac{(HistSignRating + ResearchValRating + CultScore) \\times (10 - ConserveStatus)}{30}, \\text{where ConserveStatus is numerically mapped: Excellent=1, Good=3, Fair=5, Poor=7, Critical=10}", "type": "calculation_knowledge", "children_knowledge": -1}
  395. {"id": 1, "knowledge": "Sensitivity Weight Values", "description": "Numerical weights for sensitivity calculations", "definition": "EnvSensitivity: Low=1, Medium=5, High=10; LightSensitivity: Low=1, Medium=5, High=10; TempSensitivity: Low=1, Medium=5, High=10; HumiditySensitivity: Low=1, Medium=5, High=10", "type": "value_illustration", "children_knowledge": -1}
  396. {"id": 2, "knowledge": "Environmental Risk Factor (ERF)", "description": "Quantifies the overall environmental risk to an artifact based on its sensitivities.", "definition": "ERF = \\frac{\\sum_{i \\in sensitivities} SensWeight_i}{|sensitivities|}, \\text{where sensitivities includes EnvSensitivity, LightSensitivity, TempSensitivity, etc, with value mapping based on Sensitivity Weight Values.}", "type": "calculation_knowledge", "children_knowledge": [1]}
  397. {"id": 3, "knowledge": "Artifact Vulnerability Score (AVS)", "description": "Comprehensive score indicating how vulnerable an artifact is based on its conservation priority and environmental sensitivities.", "definition": "AVS = CPI \\times ERF, \\text{where higher scores indicate artifacts requiring more urgent attention}", "type": "calculation_knowledge", "children_knowledge": [0, 2]}
  398. {"id": 4, "knowledge": "Display Safety Duration (DSD)", "description": "Calculates the recommended maximum display duration for an artifact based on its sensitivities.", "definition": "DSD = \\frac{BaseDuration \\times (10 - LightSensWeight) \\times (10 - TempSensWeight) \\times (10 - HumidSensWeight)}{1000}, \\text{where BaseDuration=36 months, and SensWeight uses Sensitivity Weight Values.}", "type": "calculation_knowledge", "children_knowledge": [1]}
  399. {"id": 5, "knowledge": "Showcase Environmental Stability Rating (SESR)", "description": "Measures how well a showcase maintains stable environmental conditions.", "definition": "SESR = 10 - \\frac{(TempVar24h + \\frac{HumVar24h}{5} + LeakRate)}{3}, \\text{where higher scores indicate more stable showcases}", "type": "calculation_knowledge", "children_knowledge": -1}
  400. {"id": 6, "knowledge": "Artifact Exhibition Compatibility (AEC)", "description": "Determines how compatible an artifact is with its current showcase environment.", "definition": "AEC = 10 - |ERF - SESR|, \\text{where a score closer to 10 indicates better compatibility}", "type": "calculation_knowledge", "children_knowledge": [2, 5]}
  401. {"id": 7, "knowledge": "Material Deterioration Rate (MDR)", "description": "Estimates the rate of material deterioration based on environmental factors.", "definition": "MDR = \\frac{ArtAgeYears \\times ERF \\times (RelHumidity - 50)^2 \\times TempC}{100000}, \\text{where higher values indicate faster deterioration}", "type": "calculation_knowledge", "children_knowledge": [2]}
  402. {"id": 8, "knowledge": "Light Exposure Risk (LER)", "description": "Quantifies the risk from light exposure based on artifact sensitivity and current light levels.", "definition": "LER = \\frac{LightLux \\times LightSensWeight \\times VisibleExpLxh}{1000}, \\text{where LightSensWeight uses Sensitivity Weight Values}", "type": "calculation_knowledge", "children_knowledge": [1]}
  403. {"id": 9, "knowledge": "Conservation Budget Efficiency (CBE)", "description": "Measures the efficiency of conservation budget allocation relative to artifact importance.", "definition": "CBE = \\frac{\\sum_{i \\in artifacts} (CPI_i \\times BudgetRatio_i)}{|artifacts|}, \\text{where BudgetRatio is the proportion of total conservation budget allocated to each artifact}", "type": "calculation_knowledge", "children_knowledge": [0]}
  404. {"id": 10, "knowledge": "Visitor Impact Risk (VIR)", "description": "Assesses the risk posed by visitor traffic to artifacts in exhibition halls.", "definition": "VIR = \\frac{VisitorCountDaily \\times VisitorFlowRate \\times VisitorDwellMin}{1000}, \\text{where VisitorFlowRate is numerically mapped: Low=1, Medium=3, High=5}", "type": "calculation_knowledge", "children_knowledge": -1}
  405. {"id": 11, "knowledge": "High-Value Artifact", "description": "Identifies artifacts with exceptional historical, cultural, or monetary value requiring special attention.", "definition": "An artifact is considered high-value when its InsValueUSD exceeds $1,000,000 OR when both HistSignRating and CultScore are in the top 10% of all artifacts.", "type": "domain_knowledge", "children_knowledge": -1}
  406. {"id": 12, "knowledge": "Conservation Emergency", "description": "Identifies artifacts requiring immediate conservation intervention.", "definition": "A situation where an artifact has ConserveStatus='Critical' AND a TreatPriority='Urgent'.", "type": "domain_knowledge", "children_knowledge": -1}
  407. {"id": 13, "knowledge": "Environmental Instability Event", "description": "Identifies periods when showcase environmental conditions fluctuate beyond acceptable parameters.", "definition": "Occurs when TempVar24h > 1°C OR HumVar24h > 3 within a 24-hour period.", "type": "domain_knowledge", "children_knowledge": -1}
  408. {"id": 14, "knowledge": "Accelerated Deterioration Scenario", "description": "Identifies conditions that could lead to rapid artifact deterioration.", "definition": "Occurs when MDR > 5 AND at least two SensitivityData values are 'High'.", "type": "domain_knowledge", "children_knowledge": [7]}
  409. {"id": 15, "knowledge": "Exhibition Rotation Candidate", "description": "Identifies artifacts that should be considered for rotation out of display.", "definition": "An artifact is a rotation candidate when its current display duration exceeds 75% of its DSD OR LER > 7.", "type": "domain_knowledge", "children_knowledge": [4, 8]}
  410. {"id": 16, "knowledge": "Showcase Failure Risk", "description": "Identifies showcases at risk of failing to maintain proper environmental conditions.", "definition": "Occurs when SESR < 4 OR at least three of the following are true: SealCondition='Poor', MaintStatus='Overdue', FilterStatus='Replace Now', SilicaGelStatus='Replace Now'.", "type": "domain_knowledge", "children_knowledge": [5]}
  411. {"id": 17, "knowledge": "Conservation Budget Crisis", "description": "Identifies when conservation budget allocation is insufficient for high-priority artifacts.", "definition": "Occurs when CBE < 0.5 AND at least one artifact has ConserveStatus='Critical' and BudgetAllocStatus='Insufficient'.", "type": "domain_knowledge", "children_knowledge": [9]}
  412. {"id": 18, "knowledge": "Dynasty Value Artifact", "description": "Identifies artifacts from historically significant dynasties with higher research and cultural value.", "definition": "Artifacts from 'Ming', 'Han', or 'Tang' dynasties that also have ResearchValRating > 8.", "type": "domain_knowledge", "children_knowledge": -1}
  413. {"id": 19, "knowledge": "Visitor Crowd Risk", "description": "Identifies exhibition halls where high visitor numbers pose risks to artifact safety.", "definition": "Occurs when VIR > 5 AND SecLevel='Level 1' for any artifact in the hall.", "type": "domain_knowledge", "children_knowledge": [10]}
  414. {"id": 20, "knowledge": "Organic Material Vulnerability", "description": "Identifies organic materials requiring special environmental conditions.", "definition": "Artifacts with MatType='Wood', 'Textile', or 'Paper' AND EnvSensitivity='High' require specialized environmental controls with narrower humidity and temperature ranges than inorganic materials.", "type": "domain_knowledge", "children_knowledge": -1}
  415. {"id": 21, "knowledge": "ArtifactsCore.ConserveStatus", "description": "Illustrates the conservation status values and their meanings.", "definition": "Values range from 'Excellent' (recently conserved, no issues), 'Good' (stable with minor issues), 'Fair' (stable but with noticeable issues), 'Poor' (active deterioration), to 'Critical' (severe deterioration requiring immediate intervention).", "type": "value_illustration", "children_knowledge": -1}
  416. {"id": 22, "knowledge": "ArtifactRatings.HistSignRating", "description": "Illustrates the historical significance rating scale.", "definition": "A SMALLINT typically ranging from 1-10, where 1-3 indicates minor historical significance, 4-7 indicates moderate significance, and 8-10 indicates exceptional historical importance that fundamentally contributes to our understanding of past cultures or events.", "type": "value_illustration", "children_knowledge": -1}
  417. {"id": 23, "knowledge": "SensitivityData.LightSensitivity", "description": "Illustrates light sensitivity classifications and their implications.", "definition": "Values include 'Low' (can tolerate up to 300 lux, like stone artifacts), 'Medium' (should be limited to 150-200 lux, like oil paintings), and 'High' (restricted to 50 lux or less, like textiles and works on paper).", "type": "value_illustration", "children_knowledge": -1}
  418. {"id": 24, "knowledge": "SensitivityData.HumiditySensitivity", "description": "Illustrates humidity sensitivity classifications and their implications.", "definition": "Values include 'Low' (can tolerate 30-65% RH, like stone artifacts), 'Medium' (requires 40-60% RH, like wood), and 'High' (requires 45-55% RH with minimal fluctuation, like lacquer work).", "type": "value_illustration", "children_knowledge": -1}
  419. {"id": 25, "knowledge": "ExhibitionHalls.CCTVCoverage", "description": "Illustrates CCTV coverage classifications.", "definition": "'Full' indicates 100% exhibition space coverage with overlapping cameras, 'Partial' indicates 60-90% coverage with possible blind spots, and 'Limited' indicates less than 60% coverage focusing only on high-value areas.", "type": "value_illustration", "children_knowledge": -1}
  420. {"id": 26, "knowledge": "Showcases.Airtightness", "description": "Illustrates showcase airtightness measurement.", "definition": "A REAL value typically ranging from 0.01 (extremely airtight, less than 0.01 air changes per day) to 5.0 (poor airtightness, multiple air changes per day). Museum-grade showcases typically maintain values below 0.1.", "type": "value_illustration", "children_knowledge": -1}
  421. {"id": 27, "knowledge": "EnvironmentalReadingsCore.TempC", "description": "Illustrates temperature readings and their conservation implications.", "definition": "Values typically range from 15-25°C, with 18-22°C being ideal for most collections. Fluctuations greater than 2°C within 24 hours can stress materials. Values outside 10-30°C indicate environmental control failure requiring immediate attention.", "type": "value_illustration", "children_knowledge": -1}
  422. {"id": 28, "knowledge": "EnvironmentalReadingsCore.RelHumidity", "description": "Illustrates relative humidity readings and their conservation implications.", "definition": "Values typically range from 30-65%, with 45-55% being ideal for mixed collections. Fluctuations greater than 5% within 24 hours can cause dimensional changes in organic materials. Values below 30% risk embrittlement, while above 65% risk mold growth.", "type": "value_illustration", "children_knowledge": -1}
  423. {"id": 29, "knowledge": "LightAndRadiationReadings.LightLux", "description": "Illustrates light intensity measurements and their conservation implications.", "definition": "Values in lux range from near-dark (5-10 lux) to typical indoor lighting (300-500 lux). Conservation standards recommend 50 lux for highly sensitive materials, 150-200 lux for paintings and wood, and up to 300 lux for stone and metal. Daylight can exceed 10,000 lux and should be filtered.", "type": "value_illustration", "children_knowledge": -1}
  424. {"id": 30, "knowledge": "AirQualityReadings.PM25Conc", "description": "Illustrates fine particulate matter measurements and their conservation implications.", "definition": "Values represent PM2.5 concentration in µg/m³. Clean museum air should measure below 5 µg/m³. Values of 5-15 indicate acceptable conditions, 15-30 indicate potential risk to sensitive materials, and above 30 represent hazardous conditions requiring immediate air filtration review.", "type": "value_illustration", "children_knowledge": -1}
  425. {"id": 31, "knowledge": "Total Environmental Threat Level (TETL)", "description": "Comprehensive measurement of all environmental threats to an artifact based on multiple risk factors.", "definition": "TETL = ERF + LER + (MDR × 2), where ERF is the Environmental Risk Factor, LER is the Light Exposure Risk, and MDR is the Material Deterioration Rat.", "type": "calculation_knowledge", "children_knowledge": [2, 8, 7]}
  426. {"id": 32, "knowledge": "Showcase Protection Adequacy (SPA)", "description": "Measures how well a showcase protects its artifacts based on its stability and the artifacts' requirements.", "definition": "SPA = SESR - (ERF × 0.5), where SESR is the Showcase Environmental Stability Rating and ERF is the Environmental Risk Factor. Positive values indicate adequate protection.", "type": "calculation_knowledge", "children_knowledge": [5, 2]}
  427. {"id": 33, "knowledge": "Conservation Backlog Risk (CBR)", "description": "Quantifies the risk associated with delayed conservation treatments.", "definition": "CBR = (CPI × (Days since LastCleaningDate - CleanIntervalDays)) ÷ 100, where CPI is the Conservation Priority Index. Higher values indicate higher risk from delayed conservation.", "type": "calculation_knowledge", "children_knowledge": [0]}
  428. {"id": 34, "knowledge": "Visitor Capacity Safety Factor (VCSF)", "description": "Determines the safe visitor capacity for exhibition halls containing sensitive artifacts.", "definition": "VCSF = VIR ÷ (AVS × 0.1), where VIR is the Visitor Impact Risk and AVS is the Artifact Vulnerability Score. Lower values indicate safer visitor capacities.", "type": "calculation_knowledge", "children_knowledge": [10, 3]}
  429. {"id": 35, "knowledge": "Exhibition Safety Quotient (ESQ)", "description": "Comprehensive safety rating for an exhibition based on artifacts, showcases, and visitor factors.", "definition": "ESQ = ((10 - AVS) + AEC + (10 - VIR)) ÷ 3, where AVS is the Artifact Vulnerability Score, AEC is the Artifact Exhibition Compatibility, and VIR is the Visitor Impact Risk. Higher values indicate safer exhibitions.", "type": "calculation_knowledge", "children_knowledge": [3, 6, 10]}
  430. {"id": 36, "knowledge": "Conservation Resource Allocation Efficiency (CRAE)", "description": "Measures how efficiently conservation resources are allocated based on priorities and budget.", "definition": "CRAE = CBE × (1 - (CBR ÷ 10)), where CBE is the Conservation Budget Efficiency and CBR is the Conservation Backlog Risk. Higher values indicate more efficient resource allocation.", "type": "calculation_knowledge", "children_knowledge": [9, 33]}
  431. {"id": 37, "knowledge": "Material Aging Projection (MAP)", "description": "Projects the rate of artifact aging based on material type and environmental conditions.", "definition": "MAP = MDR × (1 + (TETL ÷ 20)), where MDR is the Material Deterioration Rate and TETL is the Total Environmental Threat Level. Higher values indicate faster projected aging.", "type": "calculation_knowledge", "children_knowledge": [7, 31]}
  432. {"id": 38, "knowledge": "Exhibition Rotation Priority Score (ERPS)", "description": "Calculates priority for rotating artifacts in and out of exhibition based on multiple factors.", "definition": "ERPS = (DSD - DisplayDurMonths) × (LER + 1) × (CPI + 1) ÷ 100, where DSD is the Display Safety Duration, LER is the Light Exposure Risk, and CPI is the Conservation Priority Index. Lower values indicate higher rotation priority.", "type": "calculation_knowledge", "children_knowledge": [4, 8, 0]}
  433. {"id": 39, "knowledge": "Environmental Compliance Index (ECI)", "description": "Measures how well current environmental conditions meet the requirements for an artifact.", "definition": "ECI = 10 - (|(TempC - IdealTemp)| + |(RelHumidity - IdealHumidity)| ÷ 5 + ERF ÷ 2), where ERF is the Environmental Risk Factor. Higher values indicate better compliance with requirements.", "type": "calculation_knowledge", "children_knowledge": [2]}
  434. {"id": 40, "knowledge": "Security Risk Exposure (SRE)", "description": "Quantifies an artifact's exposure to security risks based on value and security measures.", "definition": "SRE = (InsValueUSD ÷ 100000) × (10 - VIR) ÷ 10, where VIR is the Visitor Impact Risk. Higher values indicate greater security risk exposure.", "type": "calculation_knowledge", "children_knowledge": [10]}
  435. {"id": 41, "knowledge": "Critical Conservation Alert", "description": "Identifies artifacts in critical condition requiring immediate intervention.", "definition": "An artifact that meets both the Conservation Emergency criteria AND has an AVS > 8.", "type": "domain_knowledge", "children_knowledge": [12, 3]}
  436. {"id": 42, "knowledge": "High Deterioration Risk Artifact", "description": "Identifies artifacts at high risk of rapid deterioration due to environmental factors.", "definition": "An artifact that has TETL > 15 AND falls under the Accelerated Deterioration Scenario.", "type": "domain_knowledge", "children_knowledge": [31, 14]}
  437. {"id": 43, "knowledge": "Exhibition Rotation Urgency", "description": "Identifies artifacts that should be immediately removed from exhibition.", "definition": "Occurs when an artifact is an Exhibition Rotation Candidate AND has an ERPS < 0.", "type": "domain_knowledge", "children_knowledge": [15, 38]}
  438. {"id": 44, "knowledge": "Showcase Compatibility Issue", "description": "Identifies incompatible artifact-showcase pairings requiring adjustment.", "definition": "Occurs when SPA < 0 AND the artifact is classified as having High-Value.", "type": "domain_knowledge", "children_knowledge": [32, 11]}
  439. {"id": 45, "knowledge": "Conservation Resource Crisis", "description": "Identifies serious conservation resource allocation problems.", "definition": "Occurs when CRAE < 0.3 AND there is a Conservation Budget Crisis.", "type": "domain_knowledge", "children_knowledge": [36, 17]}
  440. {"id": 46, "knowledge": "Dynasty Artifact at Risk", "description": "Identifies historically significant dynasty artifacts at conservation risk.", "definition": "An artifact that qualifies as a Dynasty Value Artifact AND has a MAP > 3.", "type": "domain_knowledge", "children_knowledge": [18, 37]}
  441. {"id": 47, "knowledge": "Environmental Control Failure", "description": "Identifies situations where environmental controls are failing to protect artifacts.", "definition": "Occurs when ECI < 4 AND there is an Environmental Instability Event.", "type": "domain_knowledge", "children_knowledge": [39, 13]}
  442. {"id": 48, "knowledge": "High Security Priority Artifact", "description": "Identifies artifacts requiring enhanced security measures.", "definition": "An artifact that is classified as High-Value AND has an SRE > 5.", "type": "domain_knowledge", "children_knowledge": [11, 40]}
  443. {"id": 49, "knowledge": "Visitor Traffic Safety Concern", "description": "Identifies situations where visitor traffic poses safety concerns for exhibitions.", "definition": "Occurs when VCSF > 2 AND there is a Visitor Crowd Risk situation.", "type": "domain_knowledge", "children_knowledge": [34, 19]}
  444. {"id": 50, "knowledge": "Organic Material Emergency", "description": "Identifies emergency situations for organic materials.", "definition": "Occurs when an artifact falls under the Organic Material Vulnerability classification AND has a TETL > 12.", "type": "domain_knowledge", "children_knowledge": [20, 31]}
  445. {"id": 51, "knowledge": "High-Value Category", "description": "Classification system for categorizing high-value artifacts based on their monetary or cultural/historical significance.", "definition": "An artifact falls into 'Monetary High-Value' category when its InsValueUSD exceeds $1,000,000. It qualifies as 'Cultural/Historical High-Value' when both its HistSignRating and CultScore are in the top 10% of all artifacts (percentile rank = 1). Otherwise 'Other'.", "type": "domain_knowledge", "children_knowledge": [11]}
  446. {"id": 52, "knowledge": "ERPS Decision Threshold", "description": "Converts ERPS scores into conservation actions", "definition": "When ERPS < 0, trigger 'Immediate Rotation'; otherwise 'Monitor'.", "type": "domain_knowledge", "children_knowledge": [38]}
  447. {"id": 53, "knowledge": "Light Exposure Thresholds", "description": "Defines maximum safe light exposure levels for artifacts based on material sensitivity", "definition": "High sensitivity artifacts (textiles, paper) must not exceed 50 lux; Medium sensitivity (paintings, wood) must not exceed 200 lux. Based on conservation research about light-induced deterioration rates.", "type": "domain_knowledge", "children_knowledge": [8, 21]}
  448. {"id": 54, "knowledge": "Conservation Environment Chronology (CEC)", "description": "A methodological approach used in museum conservation to segment environmental monitoring data into chronological intervals. This approach enables curators to identify seasonal trends, long-term shifts, and anomalies in environmental conditions that can affect artifact stability and preservation.", "definition": "CEC involves grouping readings (e.g., temperature, humidity, air pressure) by fixed time intervals (such as by year) to discern patterns and inform conservation strategies.", "type": "domain_knowledge", "children_knowledge": -1}
  449. {"id": 55, "knowledge": "Artifact Rarity & Valuation (ARV)", "description": "Establishes criteria for identifying artifacts of exceptional rarity and valuation that demand heightened preservation measures and limited public access.", "definition": "Artifacts are categorized as ARV if their insurance value exceed $1,000,000.", "type": "domain_knowledge", "children_knowledge": -1}
  450. {"id": 56, "knowledge": "Conservation Priority Level", "description": "Classifies artifacts into priority levels based on their CPI scores", "definition": "'High Priority': CPI > 7 (Artifacts requiring immediate conservation attention); 'Medium Priority': 4 < CPI ≤ 7 (Artifacts needing monitoring and planned conservation); 'Low Priority': CPI ≤ 4 (Artifacts in stable condition).", "type": "domain_knowledge", "children_knowledge": [0]}
  451. </СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
Advertisement
Add Comment
Please, Sign In to add comment