Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <НАЗВАНИЕ ТЕСТА>museum_5</НАЗВАНИЕ ТЕСТА>
- <ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>Нужно преобразовать запрос в свободной форме (тег «ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ») в SQL-запрос, воспользовавшись схемой базы данных (тег «СХЕМА БАЗЫ ДАННЫХ») и словарём знаний (тег «СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ»). При наличии комментариев и пояснений пишите их на русском языке.</ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>
- <ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>Show me whether items are in Accelerated Deterioration (Yes/No). For each artifact, determine if its Deterioration Index exceeds the accelerated threshold.</ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>
- <ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>Покажите для каждого экспоната, подпадает ли он под «ускоренное» ухудшение (Да/Нет). Определите, превышает ли его индекс ухудшения порог ускоренного.</ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>
- <СХЕМА БАЗЫ ДАННЫХ>
- CREATE TABLE "artifactscore" (
- artregistry character NOT NULL, /* CHAR(10) PRIMARY KEY uniquely identifying each artifact record (e.g., 'ART000012'). */
- artname character varying NOT NULL, /* VARCHAR(100) providing the artifact’s name or label (free text, no strict list). */
- artdynasty character varying NULL, /* VARCHAR(50) indicating the historical period/era/dynasty (e.g., 'Ming', 'Song', 'Qing', 'Han', 'Tang', 'Yuan'). No strict enumeration. */
- artageyears integer NULL, /* INT denoting the artifact’s approximate age in years (any integer value). */
- 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. */
- conservestatus USER-DEFINED NULL, /* VARCHAR(150) describing the artifact’s current conservation condition. Possible values might include 'Excellent', 'Good', 'Fair', 'Poor', 'Critical'. */
- PRIMARY KEY (artregistry)
- );
- First 3 rows:
- artregistry artname artdynasty artageyears mattype conservestatus
- ------------- ---------------- ------------ ------------- --------- ----------------
- ART54317 Culture Painting Ming 943 Stone Good
- ART54254 Poor Vase Song 2179 Textile Fair
- ART69978 Order Painting Qing 366 Bronze Poor
- ...
- CREATE TABLE "surfaceandphysicalreadings" (
- surfphysregistry bigint NOT NULL DEFAULT nextval('surfaceandphysicalreadings_surfphysregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, unique ID for each surface/physical reading record. */
- envreadref bigint NOT NULL, /* BIGINT FOREIGN KEY referencing EnvironmentalReadingsCore(EnvReadRegistry). Ties surface data to a general environment reading. */
- vibralvlmms2 real NULL, /* REAL measuring vibration level in mm/s² (millimeters per second squared). */
- noisedb smallint NULL, /* SMALLINT capturing noise level in decibels (dB). */
- dustaccummgm2 numeric NULL, /* NUMERIC(5,2) for dust accumulation in milligrams per square meter (mg/m²). */
- microbialcountcfu integer NULL, /* INT counting colony-forming units (CFU) of microbes on surfaces. */
- moldriskidx numeric NULL, /* NUMERIC(4,2) representing a calculated mold risk index (e.g., 0–10). */
- pestactivitylvl character varying NULL, /* VARCHAR(50) noting observed pest activity (could be enumerations like 'Medium', 'Low', 'High'). */
- pesttrapcount smallint NULL, /* SMALLINT indicating how many pests were caught in traps (if applicable). */
- pestspeciesdetected text NULL, /* TEXT listing pest species observed or identified (e.g., 'Beetles', 'Booklice', 'Moths', 'Silverfish'). */
- surfaceph numeric NULL, /* NUMERIC(3,1) measuring pH on the artifact’s surface. */
- matmoistcontent numeric NULL, /* NUMERIC(4,2) for the material’s moisture content in percentage (0–100%). */
- saltcrystalrisk character NULL, /* CHAR(20) describing risk of salt crystallization (possible values: 'High', 'Low', 'Medium'). */
- metalcorroderate numeric NULL, /* NUMERIC(4,2) capturing corrosion rate for metal surfaces, e.g., mg/cm² per day. */
- organicdegradidx numeric NULL, /* NUMERIC(4,2) measuring potential organic degradation (e.g., 0–10 scale). */
- colorchangedeltae real NULL, /* REAL indicating color change (Delta E) measurement. */
- surfacetempc numeric NULL, /* NUMERIC(5,2) temperature of the surface in Celsius. */
- surfacerh numeric NULL, /* NUMERIC(4,1) relative humidity at the surface (percentage). */
- condenserisk character varying NULL, /* VARCHAR(60) describing condensation risk level (possible values: 'Medium', 'High', 'Low'). */
- thermalimgstatus character NULL, /* CHAR(15) summarizing thermal imaging results (possible values: 'Normal', 'Critical', 'Attention Required'). */
- structstability character varying NULL, /* VARCHAR(50) describing structural stability (possible values: 'Stable', 'Minor Issues', 'Major Issues'). */
- crackmonitor text NULL, /* TEXT field noting crack monitoring details (possible values: 'Significant Changes', 'Minor Changes', 'No Changes'). */
- deformmm numeric NULL, /* NUMERIC(5,2) measuring any deformation in millimeters. */
- wtchangepct numeric NULL, /* NUMERIC(6,5) capturing weight change in percentage (e.g., 0.00001–99.99999). */
- surfdustcoverage smallint NULL, /* SMALLINT representing the percentage of surface area covered by dust (0–100%). */
- o2concentration numeric NULL, /* NUMERIC(4,2) measuring oxygen concentration (e.g., 21.00% for normal air). */
- n2concentration numeric NULL, /* NUMERIC(4,2) measuring nitrogen concentration (often ~78.00% in air). */
- PRIMARY KEY (surfphysregistry),
- FOREIGN KEY (envreadref) REFERENCES environmentalreadingscore(envreadregistry)
- );
- First 3 rows:
- 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
- ------------------ ------------ -------------- --------- --------------- ------------------- ------------- ----------------- --------------- --------------------- ----------- ----------------- ----------------- ------------------ ------------------ ------------------- -------------- ----------- -------------- ------------------ ----------------- ------------------- ---------- ------------- ------------------ ----------------- -----------------
- 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
- 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
- 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
- ...
- CREATE TABLE "usagerecords" (
- usagerecordregistry bigint NOT NULL DEFAULT nextval('usagerecords_usagerecordregistry_seq'::regclass), /* A BIGSERIAL primary key uniquely identifying each usage record. */
- artrefused character NOT NULL, /* A CHAR(10) NOT NULL foreign key referencing ArtifactsCore(ArtRegistry), indicating which artifact is being used. */
- showcaserefused character NULL, /* A CHAR(12) foreign key referencing Showcases(ShowcaseReg) if a showcase is involved in the usage. */
- sensdatalink bigint NULL, /* A BIGINT foreign key referencing SensitivityData(SensitivityRegistry). Links usage requirements to known sensitivities. */
- displayrotatesched character NULL, /* A CHAR(20) describing how often the artifact is rotated (possible values: 'Permanent', 'Resting', 'Active'). */
- displaydurmonths smallint NULL, /* A SMALLINT indicating how many months the artifact is displayed in a single rotation. */
- restperiodmonths smallint NULL, /* A SMALLINT for how many months the artifact rests between rotations. */
- displayreqs character varying NULL, /* A VARCHAR(120) listing any special display requirements (possible values: 'Special', 'Standard', 'Custom'). */
- storagereqs character varying NULL, /* A VARCHAR(60) describing special storage requirements (possible values: 'Standard', 'Custom', 'Special'). */
- handlingreqs character varying NULL, /* A VARCHAR(80) specifying guidelines for handling (possible values: 'Custom', 'Special', 'Standard'). */
- transportreqs text NULL, /* A TEXT field detailing transport requirements (possible values: 'Custom', 'Special', 'Standard'). */
- packingreqs character varying NULL, /* A VARCHAR(90) summarizing packing methods (possible values: 'Custom', 'Special', 'Standard'). */
- resaccessfreq character NULL, /* A CHAR(10) indicating how often the artifact is accessed for research (possible values: 'Frequent', 'Rare', 'Occasional'). */
- publicdispfreq character NULL, /* A CHAR(15) describing how often the artifact goes on public display (possible values: 'Frequent', 'Occasional', 'Rare'). */
- loanfreq character NULL, /* A CHAR(12) specifying how frequently the artifact is loaned out (possible values: 'Occasional', 'Frequent', 'Rare'). */
- handlefreq character NULL, /* A CHAR(10) indicating how frequently the artifact is handled (possible values: 'Rare', 'Frequent', 'Occasional'). */
- docufreq character varying NULL, /* A VARCHAR(20) describing how often documentation is updated (possible values: 'Frequent', 'Rare', 'Occasional'). */
- monitorfreq character varying NULL, /* A VARCHAR(35) for how often the artifact is monitored (possible values: 'Monthly', 'Daily', 'Weekly'). */
- assessfreq character NULL, /* A CHAR(15) for the frequency of condition assessments (possible values: 'Monthly', 'Quarterly', 'Annually'). */
- maintfreq character NULL, /* A CHAR(15) indicating the maintenance schedule (possible values: 'Monthly', 'Weekly', 'Quarterly'). */
- inspectfreq character NULL, /* A CHAR(15) describing the routine inspection frequency (possible values: 'Weekly', 'Monthly', 'Daily'). */
- calibfreq character NULL, /* A CHAR(15) stating how often instruments are calibrated (possible values: 'Monthly', 'Quarterly', 'Annually'). */
- certstatus character varying NULL, /* A VARCHAR(40) noting any certification status (possible values: 'Expired', 'Current', 'Pending'). */
- compliancestatus character varying NULL, /* A VARCHAR(55) summarizing compliance (possible values: 'Non-compliant', 'Partial', 'Compliant'). */
- auditstatus USER-DEFINED NULL, /* A CHAR(10) indicating the result of a related audit (possible values: 'Passed', 'Pending', 'Failed'). */
- qualityctrlstatus USER-DEFINED NULL, /* A VARCHAR(70) describing quality control status (possible values: 'Failed', 'Passed', 'Review'). */
- PRIMARY KEY (usagerecordregistry),
- FOREIGN KEY (artrefused) REFERENCES artifactscore(artregistry),
- FOREIGN KEY (sensdatalink) REFERENCES sensitivitydata(sensitivityregistry),
- FOREIGN KEY (showcaserefused) REFERENCES showcases(showcasereg)
- );
- First 3 rows:
- 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
- --------------------- ------------ ----------------- -------------- -------------------- ------------------ ------------------ ------------- ------------- -------------- --------------- ------------- --------------- ---------------- ---------- ------------ ---------- ------------- ------------ ----------- ------------- ----------- ------------ ------------------ ------------- -------------------
- 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
- 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
- 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
- ...
- CREATE TABLE "artifactratings" (
- ratingrecordregistry bigint NOT NULL DEFAULT nextval('artifactratings_ratingrecordregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, unique ID for each rating record. */
- artref character NOT NULL, /* CHAR(10) FOREIGN KEY referencing ArtifactsCore(ArtRegistry). Links the record to a specific artifact. */
- histsignrating smallint NULL, /* SMALLINT rating for historical significance (scale is flexible). */
- researchvalrating integer NULL, /* INT rating for research value (range is flexible). */
- exhibitvalrating integer NULL, /* INT rating evaluating the artifact’s exhibition value (scale is flexible). */
- cultscore smallint NULL, /* SMALLINT measuring the artifact’s cultural importance (common range or flexible scale). */
- publicaccessrating smallint NULL, /* SMALLINT rating the artifact’s public accessibility or appeal (scale is flexible). */
- eduvaluerating bigint NULL, /* BIGINT rating for how much educational value the artifact provides (scale is flexible). */
- conservediff USER-DEFINED NULL, /* VARCHAR(100) describing difficulty in conserving the artifact (possible values: 'Medium', 'High', 'Low'). */
- treatcomplexity character NULL, /* CHAR(10) indicating treatment complexity (possible values: 'Complex', 'Moderate', 'Simple'). */
- matstability character varying NULL, /* VARCHAR(30) for material stability classification (possible values: 'Unstable', 'Stable', 'Moderate'). */
- deteriorrate text NULL, /* TEXT field detailing the specific deterioration rate or pattern (e.g., 'Moderate', 'Rapid', 'Slow'). */
- PRIMARY KEY (ratingrecordregistry),
- FOREIGN KEY (artref) REFERENCES artifactscore(artregistry)
- );
- First 3 rows:
- ratingrecordregistry artref histsignrating researchvalrating exhibitvalrating cultscore publicaccessrating eduvaluerating conservediff treatcomplexity matstability deteriorrate
- ---------------------- -------- ---------------- ------------------- ------------------ ----------- -------------------- ---------------- -------------- ----------------- -------------- --------------
- 1 ART54317 7 9 4 25 9 9 Medium Complex Unstable Moderate
- 2 ART54254 3 5 7 13 1 3 High Moderate Stable Rapid
- 3 ART69978 5 10 4 4 7 3 High Moderate Moderate Rapid
- ...
- CREATE TABLE "lightandradiationreadings" (
- lightradregistry bigint NOT NULL DEFAULT nextval('lightandradiationreadings_lightradregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, uniquely identifying each light/radiation reading. */
- envreadref bigint NOT NULL, /* BIGINT FOREIGN KEY referencing EnvironmentalReadingsCore(EnvReadRegistry). Associates light data with an existing environment reading. */
- lightlux integer NULL, /* INT measuring visible light intensity in lux. */
- uvuwcm2 numeric NULL, /* NUMERIC(6,2) capturing UV radiation in microwatts per cm² (µW/cm²). */
- irwm2 numeric NULL, /* NUMERIC(6,2) measuring infrared radiation in W/m². */
- visibleexplxh integer NULL, /* INT indicating total visible light exposure over time in lux-hours (Lx·h). */
- PRIMARY KEY (lightradregistry),
- FOREIGN KEY (envreadref) REFERENCES environmentalreadingscore(envreadregistry)
- );
- First 3 rows:
- lightradregistry envreadref lightlux uvuwcm2 irwm2 visibleexplxh
- ------------------ ------------ ---------- --------- ------- ---------------
- 1 1 91 32.58 7.51 71166
- 2 2 138 64.99 7.81 69438
- 3 3 71 66.82 5.47 75541
- ...
- CREATE TABLE "artifactsecurityaccess" (
- secrecordregistry bigint NOT NULL DEFAULT nextval('artifactsecurityaccess_secrecordregistry_seq'::regclass), /* A BIGSERIAL primary key uniquely identifying each artifact security/access record. */
- artref character NOT NULL, /* A CHAR(10) NOT NULL foreign key referencing ArtifactsCore(ArtRegistry). Links this security record to a specific artifact. */
- ratingref bigint NULL, /* A BIGINT foreign key referencing ArtifactRatings(RatingRecordRegistry). Associates this security record with a particular artifact rating, if relevant. */
- loanstatus character NULL, /* A CHAR(15) indicating the artifact’s loan status (possible values: 'On Loan', 'Available', 'Not Available'). */
- insvalueusd numeric NULL, /* A NUMERIC(15,2) specifying the artifact’s insured value in USD. */
- seclevel character varying NULL, /* A VARCHAR(50) describing the security level (possible values: 'Level 3', 'Level 2', 'Level 1'). */
- accessrestrictions text NULL, /* A TEXT field detailing constraints on handling/viewing (possible values: 'Public', 'Restricted', 'Limited'). */
- docustatus character varying NULL, /* A VARCHAR(60) indicating the completeness of documentation (possible values: 'Updating', 'Partial', 'Complete'). */
- photodocu character varying NULL, /* A VARCHAR(100) noting photographic documentation status (possible values: 'Outdated', 'Required', 'Recent'). */
- condreportstatus character varying NULL, /* A VARCHAR(80) describing the artifact’s condition report status (possible values: 'Current', 'Due', 'Overdue'). */
- conserverecstatus character NULL, /* A CHAR(20) summarizing conservation record status (possible values: 'Review Required', 'Pending', 'Updated'). */
- researchaccessstatus character varying NULL, /* A VARCHAR(40) indicating if the artifact is open to researchers (possible values: 'Limited', 'Available', 'Restricted'). */
- digitalrecstatus text NULL, /* A TEXT field specifying any digital records or scans (possible values: 'In Progress', 'Partial', 'Complete'). */
- PRIMARY KEY (secrecordregistry),
- FOREIGN KEY (artref) REFERENCES artifactscore(artregistry),
- FOREIGN KEY (ratingref) REFERENCES artifactratings(ratingrecordregistry)
- );
- First 3 rows:
- secrecordregistry artref ratingref loanstatus insvalueusd seclevel accessrestrictions docustatus photodocu condreportstatus conserverecstatus researchaccessstatus digitalrecstatus
- ------------------- -------- ----------- ------------ ------------- ---------- -------------------- ------------ ----------- ------------------ ------------------- ---------------------- ------------------
- 1 ART54317 1 On Loan 968368 Level 3 Public Updating Outdated Current Review Required Limited In Progress
- 2 ART54254 2 Available 36135 Level 3 Public Partial Required Due Pending Limited Partial
- 3 ART69978 3 On Loan 330049 Level 2 Restricted Partial Required Current Review Required Limited Partial
- ...
- CREATE TABLE "sensitivitydata" (
- sensitivityregistry bigint NOT NULL DEFAULT nextval('sensitivitydata_sensitivityregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, unique ID for each record of sensitivity details. */
- artref character NOT NULL, /* CHAR(10) FOREIGN KEY referencing ArtifactsCore(ArtRegistry). */
- envsensitivity character NULL, /* CHAR(20) for overall environmental sensitivity (possible values: 'Low', 'High', 'Medium'). */
- lightsensitivity character varying NULL, /* VARCHAR(80) describing light/UV sensitivity (possible values: 'High', 'Low', 'Medium'). */
- tempsensitivity character varying NULL, /* VARCHAR(50) summarizing temperature tolerance (possible values: 'High', 'Low', 'Medium'). */
- humiditysensitivity text NULL, /* TEXT detailing humidity requirements or maximum humidity tolerance (possible values: 'Medium', 'High', 'Low'). */
- vibrasensitivity character NULL, /* CHAR(20) describing vibration tolerance (possible values: 'Medium', 'High', 'Low'). */
- pollutantsensitivity character varying NULL, /* VARCHAR(100) indicating susceptibility to pollutants (possible values: 'High', 'Medium', 'Low'). */
- pestsensitivity text NULL, /* TEXT describing vulnerability to pests (possible values: 'High', 'Low', 'Medium'). */
- handlesensitivity character NULL, /* CHAR(20) for handling sensitivity (possible values: 'Medium', 'Low', 'High'). */
- transportsensitivity character varying NULL, /* VARCHAR(50) specifying special packaging needs (possible values: 'High', 'Low', 'Medium'). */
- displaysensitivity character varying NULL, /* VARCHAR(120) noting special display requirements (possible values: 'Low', 'High', 'Medium'). */
- storagesensitivity text NULL, /* TEXT detailing storage conditions (possible values: 'Medium', 'Low', 'High'). */
- PRIMARY KEY (sensitivityregistry),
- FOREIGN KEY (artref) REFERENCES artifactscore(artregistry)
- );
- First 3 rows:
- sensitivityregistry artref envsensitivity lightsensitivity tempsensitivity humiditysensitivity vibrasensitivity pollutantsensitivity pestsensitivity handlesensitivity transportsensitivity displaysensitivity storagesensitivity
- --------------------- -------- ---------------- ------------------ ----------------- --------------------- ------------------ ---------------------- ----------------- ------------------- ---------------------- -------------------- --------------------
- 1 ART54317 Low High High Medium Medium High High Medium High Low Medium
- 2 ART54254 High Low Low High High Medium Low Medium High Low Low
- 3 ART69978 High High Medium Low Low High High Low Low High Medium
- ...
- CREATE TABLE "conditionassessments" (
- conditionassessregistry bigint NOT NULL DEFAULT nextval('conditionassessments_conditionassessregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, unique ID for each condition assessment record. */
- 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.) */
- showcaserefexamined text NULL, /* TEXT FOREIGN KEY referencing Showcases(ShowcaseReg). Ties the record to the showcase if it was part of the assessment. */
- lightreadrefobserved bigint NULL, /* BIGINT FOREIGN KEY referencing LightAndRadiationReadings(LightRadRegistry). Associates the assessment with relevant light data. */
- condassessscore integer NULL, /* INT rating or score representing the artifact/showcase condition (scale is flexible). */
- conserveassessdate date NULL, /* DATE when the conservation assessment took place. */
- nextassessdue date NULL, /* DATE by which the next condition assessment should occur. */
- PRIMARY KEY (conditionassessregistry),
- FOREIGN KEY (artrefexamined) REFERENCES artifactscore(artregistry),
- FOREIGN KEY (lightreadrefobserved) REFERENCES lightandradiationreadings(lightradregistry),
- FOREIGN KEY (showcaserefexamined) REFERENCES showcases(showcasereg)
- );
- First 3 rows:
- conditionassessregistry artrefexamined showcaserefexamined lightreadrefobserved condassessscore conserveassessdate nextassessdue
- ------------------------- ---------------- --------------------- ---------------------- ----------------- -------------------- ---------------
- 1 ART54317 SC9857 1 93 2024-09-15 2025-04-17
- 2 ART54254 SC7393 2 48 2024-03-27 2025-09-09
- 3 ART69978 SC9391 3 61 2024-05-01 2025-11-10
- ...
- CREATE TABLE "exhibitionhalls" (
- hallrecord character NOT NULL,
- cctvcoverage character varying NULL, /* VARCHAR(100) describing the CCTV coverage (possible values: 'Partial', 'Full', 'Limited'). */
- motiondetectstatus character varying NULL, /* VARCHAR(50) summarizing motion detection status (possible values: 'Active', 'Maintenance', 'Partial'). */
- alarmsysstatus character NULL, /* CHAR(15) for alarm system status (possible values: 'Armed', 'Maintenance', 'Partial'). */
- accessctrlstatus character varying NULL, /* VARCHAR(80) describing the level of access control (possible values: 'Maintenance', 'Active', 'Partial'). */
- visitorcountdaily integer NULL, /* INT representing the typical or observed daily visitor count (unbounded integer). */
- visitorflowrate USER-DEFINED NULL, /* SMALLINT indicating how many visitors pass through (possible values: 'Low', 'Medium', 'High'). */
- visitordwellmin smallint NULL, /* SMALLINT specifying the average dwell time (in minutes) per visitor. */
- visitorbehaviornotes text NULL, /* TEXT field for any additional notes on visitor behaviors, traffic patterns, or compliance issues. */
- PRIMARY KEY (hallrecord),
- FOREIGN KEY (hallrecord) REFERENCES artifactscore(artregistry)
- );
- First 3 rows:
- hallrecord cctvcoverage motiondetectstatus alarmsysstatus accessctrlstatus visitorcountdaily visitorflowrate visitordwellmin visitorbehaviornotes
- ------------ -------------- -------------------- ---------------- ------------------ ------------------- ----------------- ----------------- ----------------------
- ART54317 Partial Active Armed Maintenance 308 Low 16 Poor
- ART54254 Full Maintenance Armed Active 993 Low 11 Poor
- ART69978 Limited Partial Maintenance Partial 19 Medium 20 Good
- ...
- CREATE TABLE "riskassessments" (
- riskassessregistry bigint NOT NULL DEFAULT nextval('riskassessments_riskassessregistry_seq'::regclass), /* A BIGSERIAL primary key uniquely identifying each risk assessment record. */
- artrefconcerned character NOT NULL, /* A CHAR(10) NOT NULL foreign key referencing ArtifactsCore(ArtRegistry), linking this record to a specific artifact. */
- hallrefconcerned character NULL, /* A CHAR(8) foreign key referencing ExhibitionHalls(HallRegistry), indicating which hall is involved in this risk assessment (if any). */
- riskassesslevel USER-DEFINED NULL, /* A VARCHAR(50) describing the level of risk (possible values: 'Medium', 'High', 'Low'). */
- emergresponseplan text NULL, /* A TEXT field outlining the emergency response procedures if the risk materializes (possible values: 'Review Required', 'Under Revision', 'Updated'). */
- evacpriority character varying NULL, /* A CHAR(15) indicating the priority for evacuation (possible values: 'Priority 3', 'Priority 1', 'Priority 2'). */
- handlerestrictions character varying NULL, /* A VARCHAR(100) describing any handling restrictions (possible values: 'Minimal', 'Strict'). */
- conservepriorityscore smallint NULL, /* A SMALLINT rating (e.g., 1–10) indicating the urgency or priority for conservation actions based on identified risks. */
- PRIMARY KEY (riskassessregistry),
- FOREIGN KEY (artrefconcerned) REFERENCES artifactscore(artregistry),
- FOREIGN KEY (hallrefconcerned) REFERENCES exhibitionhalls(hallrecord)
- );
- First 3 rows:
- riskassessregistry artrefconcerned hallrefconcerned riskassesslevel emergresponseplan evacpriority handlerestrictions conservepriorityscore
- -------------------- ----------------- ------------------ ----------------- ------------------- -------------- -------------------- -----------------------
- 1 ART54317 ART54317 Medium Review Required Priority 3 Minimal 85
- 2 ART54254 ART54254 Medium Under Revision Priority 1 Strict 76
- 3 ART69978 ART69978 Medium Updated Priority 2 Minimal 91
- ...
- CREATE TABLE "showcases" (
- showcasereg character NOT NULL, /* CHAR(12) PRIMARY KEY for identifying each showcase (e.g., 'SHOW00000012'). */
- hallref character NULL, /* CHAR(8) FOREIGN KEY referencing ExhibitionHalls(HallRegistry). Connects the showcase to a particular hall. */
- airtightness real NULL, /* REAL measuring the physical seal quality, often tested as a numeric rating or leakage rate. */
- showcasematerial character varying NULL, /* VARCHAR(80) describing the material (possible values: 'Tempered Glass', 'Glass', 'Acrylic'). */
- sealcondition character varying NULL, /* VARCHAR(30) indicating the seal’s condition (possible values: 'Poor', 'Excellent', 'Good', 'Fair'). */
- maintstatus character NULL, /* CHAR(15) for the showcase’s maintenance status (possible values: 'Overdue', 'Due', 'Good'). */
- filterstatus text NULL, /* TEXT detailing installed filters (possible values: 'Replace Now', 'Replace Soon', 'Clean'). */
- silicagelstatus character NULL, /* CHAR(20) noting the condition of silica gel (possible values: 'Active', 'Replace Soon', 'Replace Now'). */
- silicagelchangedate date NULL, /* DATE of the last silica gel replacement or recharge. */
- humiditybuffercap smallint NULL, /* SMALLINT rating or index of the showcase’s capacity to buffer humidity. */
- pollutantabsorbcap numeric NULL, /* NUMERIC(5,2) for the pollutant absorption capacity (quantity or threshold). */
- leakrate real NULL, /* REAL specifying the rate of air leakage, often tested to ensure stable internal conditions. */
- pressurepa bigint NULL, /* BIGINT capturing the internal pressure (in pascals) if pressurization is used. */
- inertgassysstatus character varying NULL, /* VARCHAR(50) describing any inert gas system status (possible values: 'Active', 'Standby', 'Maintenance'). */
- firesuppresssys character varying NULL, /* VARCHAR(50) summarizing fire suppression condition (possible values: 'Maintenance', 'Active', 'Standby'). */
- empowerstatus character NULL, /* CHAR(10) indicating emergency power readiness (possible values: 'Testing', 'Active', 'Standby'). */
- backupsysstatus text NULL, /* TEXT describing any backup systems (possible values: 'Ready', 'Maintenance', 'Testing') and their condition. */
- PRIMARY KEY (showcasereg),
- FOREIGN KEY (hallref) REFERENCES exhibitionhalls(hallrecord)
- );
- First 3 rows:
- showcasereg hallref airtightness showcasematerial sealcondition maintstatus filterstatus silicagelstatus silicagelchangedate humiditybuffercap pollutantabsorbcap leakrate pressurepa inertgassysstatus firesuppresssys empowerstatus backupsysstatus
- ------------- --------- -------------- ------------------ --------------- ------------- -------------- ----------------- --------------------- ------------------- -------------------- ---------- ------------ ------------------- ----------------- --------------- -----------------
- SC9857 ART54317 95.1 Tempered Glass Poor Overdue Replace Now Active 2024-09-15 81 71.7 0.41 -2 Active Maintenance Testing Ready
- SC7393 ART54254 93 Tempered Glass Excellent Overdue Replace Now Active 2024-12-15 78 79.8 0.07 3 Standby Active Active Maintenance
- SC9391 ART69978 99.4 Glass Good Due Replace Soon Replace Soon 2024-12-21 92 66.3 0.2 -3 Active Active Active Testing
- ...
- CREATE TABLE "conservationandmaintenance" (
- conservemaintregistry bigint NOT NULL DEFAULT nextval('conservationandmaintenance_conservemaintregistry_seq'::regclass), /* A BIGSERIAL primary key uniquely identifying each record of conservation and maintenance. */
- artrefmaintained character NOT NULL, /* A CHAR(10) NOT NULL foreign key referencing ArtifactsCore(ArtRegistry). Ties this record to the maintained artifact. */
- hallrefmaintained character NULL, /* A CHAR(8) foreign key referencing ExhibitionHalls(HallRegistry), if the conservation applies to a specific hall area. */
- surfreadrefobserved bigint NULL, /* A BIGINT foreign key referencing SurfaceAndPhysicalReadings(SurfPhysRegistry). Links to surface/physical readings used in this maintenance record. */
- conservetreatstatus character varying NULL, /* A VARCHAR(50) describing the status of conservation treatment (possible values: 'In Progress', 'Not Required', 'Scheduled'). */
- treatpriority character NULL, /* A CHAR(10) indicating the priority of the treatment (possible values: 'High', 'Medium', 'Low', 'Urgent'). */
- lastcleaningdate date NULL, /* A DATE specifying the last cleaning date of the artifact/hall/showcase. */
- nextcleaningdue date NULL, /* A DATE indicating when the next cleaning is scheduled or recommended. */
- cleanintervaldays smallint NULL, /* A SMALLINT capturing the recommended cleaning interval in days. */
- maintlog text NULL, /* A TEXT field describing any notes, log details, or issues encountered during maintenance activities (possible values: 'Updated', 'Pending', 'Review'). */
- incidentreportstatus character varying NULL, /* A VARCHAR(50) summarizing the status of any incident reports (possible values: 'Closed', 'Open'). */
- emergencydrillstatus character NULL, /* A CHAR(15) indicating whether emergency drills are 'Current', 'Overdue', 'Due', etc. */
- stafftrainstatus character NULL, /* A VARCHAR(20) describing staff training status (possible values: 'Current', 'Overdue', 'Due'). */
- budgetallocstatus character varying NULL, /* A VARCHAR(50) describing budget allocation status (possible values: 'Review Required', 'Insufficient', 'Adequate'). */
- maintbudgetstatus character NULL, /* A CHAR(15) indicating if the current maintenance budget is 'Limited', 'Depleted', 'Available', etc. */
- conservefreq USER-DEFINED NULL, /* A VARCHAR(30) describing the frequency of conservation efforts (possible values: 'Rare', 'Occasional', 'Frequent'). */
- intervhistory text NULL, /* A TEXT field detailing the intervention or treatment history (possible values: 'Extensive', 'Minimal', 'Moderate'). */
- prevtreatments smallint NULL, /* A SMALLINT counting how many significant treatments have been done previously on this artifact/hall. */
- treateffectiveness character varying NULL, /* A VARCHAR(100) summarizing how effective previous treatments were (possible values: 'Low', 'Medium', 'High'). */
- reversibilitypotential USER-DEFINED NULL, /* A TEXT field describing if and how treatments can be reversed (possible values: 'Medium', 'High', 'Low'). */
- PRIMARY KEY (conservemaintregistry),
- FOREIGN KEY (artrefmaintained) REFERENCES artifactscore(artregistry),
- FOREIGN KEY (hallrefmaintained) REFERENCES exhibitionhalls(hallrecord),
- FOREIGN KEY (surfreadrefobserved) REFERENCES surfaceandphysicalreadings(surfphysregistry)
- );
- First 3 rows:
- conservemaintregistry artrefmaintained hallrefmaintained surfreadrefobserved conservetreatstatus treatpriority lastcleaningdate nextcleaningdue cleanintervaldays maintlog incidentreportstatus emergencydrillstatus stafftrainstatus budgetallocstatus maintbudgetstatus conservefreq intervhistory prevtreatments treateffectiveness reversibilitypotential
- ----------------------- ------------------ ------------------- --------------------- --------------------- --------------- ------------------ ----------------- ------------------- ---------- ---------------------- ---------------------- ------------------ ------------------- ------------------- -------------- --------------- ---------------- -------------------- ------------------------
- 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
- 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
- 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
- ...
- CREATE TABLE "environmentalreadingscore" (
- envreadregistry bigint NOT NULL DEFAULT nextval('environmentalreadingscore_envreadregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, uniquely identifying each environmental reading record. */
- monitorcode character NOT NULL, /* CHAR(10) identifier for the monitoring device or sensor (e.g., 'MON000001'). */
- readtimestamp timestamp without time zone NOT NULL, /* TIMESTAMP NOT NULL indicating the date and time the reading was recorded. */
- showcaseref character NULL, /* CHAR(12) FOREIGN KEY referencing Showcases(ShowcaseReg), linking the reading to a specific showcase being monitored. */
- tempc smallint NULL, /* SMALLINT representing the measured temperature in Celsius. */
- tempvar24h real NULL, /* REAL showing the 24-hour variation in temperature (in °C). */
- relhumidity integer NULL, /* INT capturing the relative humidity percentage (0–100). */
- humvar24h smallint NULL, /* SMALLINT indicating the 24-hour variation in humidity (percentage points). */
- airpresshpa real NULL, /* REAL specifying the measured air pressure in hectopascals (hPa). */
- PRIMARY KEY (envreadregistry),
- FOREIGN KEY (showcaseref) REFERENCES showcases(showcasereg)
- );
- First 3 rows:
- envreadregistry monitorcode readtimestamp showcaseref tempc tempvar24h relhumidity humvar24h airpresshpa
- ----------------- ------------- -------------------------- ------------- ------- ------------ ------------- ----------- -------------
- 1 MM191823 2024-08-06 08:38:48.050280 SC9857 21 0.85 53 2 1020
- 2 MM153427 2025-02-07 03:00:17.050280 SC7393 18 1.34 54 1 1013.4
- 3 MM675303 2024-07-25 09:37:21.050280 SC9391 21 1.75 47 1 1015.3
- ...
- CREATE TABLE "airqualityreadings" (
- aqrecordregistry bigint NOT NULL DEFAULT nextval('airqualityreadings_aqrecordregistry_seq'::regclass), /* BIGSERIAL PRIMARY KEY, uniquely identifying each air-quality reading record. */
- envreadref bigint NOT NULL, /* BIGINT FOREIGN KEY referencing EnvironmentalReadingsCore(EnvReadRegistry). Links this record to its main environmental reading. */
- co2ppm smallint NULL, /* SMALLINT measuring CO2 concentration in parts per million (ppm). Typical range: 300–2000. */
- tvocppb integer NULL, /* INT capturing total volatile organic compounds in parts per billion (ppb). */
- ozoneppb integer NULL, /* INT indicating ozone concentration in ppb. */
- so2ppb smallint NULL, /* SMALLINT for sulfur dioxide concentration in ppb. */
- no2ppb bigint NULL, /* BIGINT for nitrogen dioxide concentration in ppb. */
- pm25conc real NULL, /* REAL measuring particulate matter (PM2.5) in µg/m³ or a similar metric. */
- pm10conc numeric NULL, /* NUMERIC(5,2) measuring PM10 concentration, possibly µg/m³ as well. */
- hchoconc numeric NULL, /* NUMERIC(7,4) for formaldehyde (HCHO) concentration (e.g., mg/m³ or another scale). */
- airexrate numeric NULL, /* NUMERIC(4,1) indicating air exchange rate (e.g., air changes per hour). */
- airvelms numeric NULL, /* NUMERIC(5,2) capturing air velocity in meters per second (m/s). */
- PRIMARY KEY (aqrecordregistry),
- FOREIGN KEY (envreadref) REFERENCES environmentalreadingscore(envreadregistry)
- );
- First 3 rows:
- aqrecordregistry envreadref co2ppm tvocppb ozoneppb so2ppb no2ppb pm25conc pm10conc hchoconc airexrate airvelms
- ------------------ ------------ -------- --------- ---------- -------- -------- ---------- ---------- ---------- ----------- ----------
- 1 1 794 89 11 12 27 16.7 34.1 0.014 6.4 0.18
- 2 2 539 420 12 18 21 10.7 16.4 0.035 4.3 0.19
- 3 3 402 393 47 14 13 5.4 29 0.077 5.9 0.14
- ...
- </СХЕМА БАЗЫ ДАННЫХ>
- <СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
- {"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}
- {"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}
- {"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]}
- {"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]}
- {"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]}
- {"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}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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}
- {"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]}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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]}
- {"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}
- {"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}
- {"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]}
- </СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
Advertisement
Add Comment
Please, Sign In to add comment