forked from dodeeric/omeka-s-docker
-
Notifications
You must be signed in to change notification settings - Fork 0
/
omeka.sql
4258 lines (3981 loc) · 623 KB
/
omeka.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: db
-- Generation Time: Nov 20, 2020 at 06:31 PM
-- Server version: 10.5.8-MariaDB-1:10.5.8+maria~focal
-- PHP Version: 7.4.11
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `omeka`
--
-- --------------------------------------------------------
--
-- Table structure for table `api_key`
--
CREATE TABLE `api_key` (
`id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`owner_id` int(11) NOT NULL,
`label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`credential_hash` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_ip` varbinary(16) DEFAULT NULL COMMENT '(DC2Type:ip_address)',
`last_accessed` datetime DEFAULT NULL,
`created` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `asset`
--
CREATE TABLE `asset` (
`id` int(11) NOT NULL,
`owner_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`media_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`storage_id` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
`extension` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `csvimport_entity`
--
CREATE TABLE `csvimport_entity` (
`id` int(11) NOT NULL,
`job_id` int(11) NOT NULL,
`entity_id` int(11) NOT NULL,
`resource_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `csvimport_entity`
--
INSERT INTO `csvimport_entity` (`id`, `job_id`, `entity_id`, `resource_type`) VALUES
(1, 1, 4, 'items'),
(2, 1, 5, 'items'),
(3, 1, 6, 'items'),
(4, 1, 7, 'items'),
(5, 1, 8, 'items'),
(6, 2, 9, 'media'),
(7, 2, 10, 'media'),
(8, 2, 11, 'media'),
(9, 2, 12, 'media'),
(10, 2, 13, 'media');
-- --------------------------------------------------------
--
-- Table structure for table `csvimport_import`
--
CREATE TABLE `csvimport_import` (
`id` int(11) NOT NULL,
`job_id` int(11) NOT NULL,
`undo_job_id` int(11) DEFAULT NULL,
`comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`resource_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`has_err` tinyint(1) NOT NULL,
`stats` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:json_array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `csvimport_import`
--
INSERT INTO `csvimport_import` (`id`, `job_id`, `undo_job_id`, `comment`, `resource_type`, `has_err`, `stats`) VALUES
(1, 1, NULL, '', 'items', 0, '{\"added\":{\"items\":5}}'),
(2, 2, NULL, '', 'media', 0, '{\"added\":{\"media\":5}}');
-- --------------------------------------------------------
--
-- Table structure for table `fulltext_search`
--
CREATE TABLE `fulltext_search` (
`id` int(11) NOT NULL,
`resource` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
`owner_id` int(11) DEFAULT NULL,
`is_public` tinyint(1) NOT NULL,
`title` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`text` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `fulltext_search`
--
INSERT INTO `fulltext_search` (`id`, `resource`, `owner_id`, `is_public`, `title`, `text`) VALUES
(2, 'item_sets', 1, 1, 'Views', 'Views\nVistas\nviews'),
(4, 'items', 1, 1, 'Museu Nacional, antigo Palácio Imperial de São Cristóvão', '0072430cx097-12\nMuseu Nacional, antigo Palácio Imperial de São Cristóvão\nAo longo do tempo, o Paço de São Cristóvão, que abriga hoje o Museu Nacional, sofreu diversas transformações, como a ampliação do palácio feita por D. Pedro II a partir de 1850. Lá ele viveu em um período de longa duração, tornando este edifício testemunha de diversos momentos importantes na História do Brasil.\nMarc Ferrez\n1879/1889 1879 – 1889\nNEGATIVO/ Vidro\nhttp://acervos.ims.com.br/portals/#/detailpage/75361 Instituto Moreira Salles\nhttp://www.wikidata.org/entity/Q65620957 Wikidata\n30.0\n24.0'),
(5, 'items', 1, 1, 'Teatro Municipal', '0072430cx098-08\nTeatro Municipal\nVista do Teatro Municipal, vendo-se a Escola Nacional de Belas Artes ao lado.\nMarc Ferrez\n1905/1915 1905 – 1915\nNEGATIVO/ Vidro\nhttp://acervos.ims.com.br/portals/#/detailpage/75352 Instituto Moreira Salles\nhttp://www.wikidata.org/entity/Q56650144 Wikidata\nhttp://www.wikidata.org/entity/Q1968538 Teatro Municipal\nhttp://www.wikidata.org/entity/Q4828121 Avenida Rio Branco\nhttp://www.wikidata.org/entity/Q55439919 Escola Nacional de Belas Artes\n30.0\n24.0'),
(6, 'items', 1, 1, 'Vista do Rio de Janeiro, tendo o Gasômetro em primeiro plano', '013RJ001004\nVista do Rio de Janeiro, tendo o Gasômetro em primeiro plano\nA fábrica do Barão de Mauá perto do Canal do Mangue chamava-se oficialmente Companhia de Iluminação a Gás, e, em 1865, foi vendida para uma empresa canadense, que assumiu o serviço de gás através da Rio de Janeiro Gas Company Limited. Em 1876 a concessão do abastecimento de gás passou para a empresa belga Société Anonyme du Gaz (SAG) que por sua vez passou a ser controlada pela The Rio de Janeiro Tramway Light and Power Company Limited (Light) a partir de 1910. Para ampliar a produção de gás na cidade, a SAG decidiu construir, em 1911, uma nova fábrica no bairro de São Cristóvão. É esta fábrica que podemos ver na fotografia de Malta.\nAugusto Malta\n1920/1932 1920 – 1932\nFOTOGRAFIA/ Papel\nhttp://acervos.ims.com.br/portals/#/detailpage/78550 Instituto Moreira Salles\nhttp://www.wikidata.org/entity/Q65621019 Wikidata\nhttp://www.wikidata.org/entity/Q2408175 São Cristóvão'),
(7, 'items', 1, 1, 'Substituição da iluminação pública de gás para lâmpadas incandescentes', '013RJ001005\nSubstituição da iluminação pública de gás para lâmpadas incandescentes\nA partir de 1907, quando a empresa canadense Light ganhou a concessão do governo para distribuir energia elétrica para a cidade, é que a iluminação pública começou a ser modificada, transformando a luz à gás para luz incandescente. Conhecida como polvo canadense pela população carioca, a empresa monopolizou não apenas a distribuição elétrica, mas foi aos poucos tomando conta do transporte público dos bondes e das linhas telefônicas.\nAugusto Malta\n1921 1921\nFOTOGRAFIA/ Papel\nhttp://acervos.ims.com.br/portals/#/detailpage/16995 Instituto Moreira Salles\nhttp://www.wikidata.org/entity/Q65621020 Wikidata\nhttp://www.wikidata.org/entity/Q10353330 Praça Mauá\n16.5\n23.0'),
(8, 'items', 1, 1, 'Avenida Vieira Souto - depois da substituição da iluminação pública de gás para lâmpadas incandescentes', '013RJ001009\nAvenida Vieira Souto - depois da substituição da iluminação pública de gás para lâmpadas incandescentes\nAugusto Malta\n1921 1921\nFOTOGRAFIA/ Papel\nhttp://acervos.ims.com.br/portals/#/detailpage/78551 Instituto Moreira Salles\nhttp://www.wikidata.org/entity/Q65621021 Wikidata\nhttp://www.wikidata.org/entity/Q3375097 Avenida Vieira Souto'),
(9, 'media', 1, 1, NULL, '0072430cx097-12'),
(10, 'media', 1, 1, NULL, '0072430cx098-08'),
(11, 'media', 1, 1, NULL, '013RJ001004'),
(12, 'media', 1, 1, NULL, '013RJ001005'),
(13, 'media', 1, 1, NULL, '013RJ001009'),
(14, 'item_sets', 1, 1, 'Smapshot', 'smapshot\nSmapshot\nSmapshot'),
(15, 'item_sets', 1, 1, 'Maps', 'maps\nMaps\nMapas'),
(16, 'item_sets', 1, 1, 'Aerials', 'aerials\nAerials\nImagens aéreas'),
(17, 'item_sets', 1, 1, 'All', 'all\nAll\nTodos'),
(18, 'item_sets', 1, 1, 'Plans', 'plans\nPlans\nPlanos');
-- --------------------------------------------------------
--
-- Table structure for table `item`
--
CREATE TABLE `item` (
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `item`
--
INSERT INTO `item` (`id`) VALUES
(4),
(5),
(6),
(7),
(8);
-- --------------------------------------------------------
--
-- Table structure for table `item_item_set`
--
CREATE TABLE `item_item_set` (
`item_id` int(11) NOT NULL,
`item_set_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `item_item_set`
--
INSERT INTO `item_item_set` (`item_id`, `item_set_id`) VALUES
(4, 17),
(5, 17),
(6, 17),
(7, 17),
(8, 17);
-- --------------------------------------------------------
--
-- Table structure for table `item_set`
--
CREATE TABLE `item_set` (
`id` int(11) NOT NULL,
`is_open` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `item_set`
--
INSERT INTO `item_set` (`id`, `is_open`) VALUES
(2, 0),
(14, 0),
(15, 0),
(16, 0),
(17, 0),
(18, 0);
-- --------------------------------------------------------
--
-- Table structure for table `item_site`
--
CREATE TABLE `item_site` (
`item_id` int(11) NOT NULL,
`site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `item_site`
--
INSERT INTO `item_site` (`item_id`, `site_id`) VALUES
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1);
-- --------------------------------------------------------
--
-- Table structure for table `job`
--
CREATE TABLE `job` (
`id` int(11) NOT NULL,
`owner_id` int(11) DEFAULT NULL,
`pid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`args` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:json_array)',
`log` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`started` datetime NOT NULL,
`ended` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `job`
--
INSERT INTO `job` (`id`, `owner_id`, `pid`, `status`, `class`, `args`, `log`, `started`, `ended`) VALUES
(1, 1, '58', 'completed', 'CSVImport\\Job\\Import', '{\"filename\":\"omeka-import-sample-ims.csv\",\"filesize\":\"3955\",\"filepath\":\"\\/tmp\\/omekag3kzp6\",\"media_type\":\"text\\/csv\",\"resource_type\":\"items\",\"comment\":\"\",\"automap_check_names_alone\":false,\"column-property\":{\"0\":{\"dcterms:identifier\":10},\"1\":{\"dcterms:title\":1},\"2\":{\"dcterms:description\":4},\"3\":{\"dcterms:creator\":2},\"4\":{\"dcterms:date\":7},\"5\":{\"dcterms:temporal\":41},\"6\":{\"dcterms:type\":8},\"7\":{\"dcterms:rights\":15},\"8\":{\"dcterms:bibliographicCitation\":48},\"9\":{\"dcterms:source\":11},\"10\":{\"dcterms:hasVersion\":28},\"13\":{\"foaf:depicts\":156},\"14\":{\"schema:width\":242},\"15\":{\"schema:height\":799}},\"column-data-type\":[\"literal\",\"literal\",\"literal\",\"literal\",\"numeric:timestamp\",\"numeric:interval\",\"literal\",\"literal\",\"literal\",\"uri\",\"uri\",\"literal\",\"literal\",\"uri\",\"literal\",\"literal\",\"literal\"],\"column-language\":{\"1\":\"pt-br\",\"2\":\"pt-br\"},\"column-map-lat\":{\"11\":\"1\"},\"column-map-lng\":{\"12\":\"1\"},\"column-multivalue\":{\"13\":\"1\"},\"generic-data\":\"default\",\"media-source\":\"default\",\"mapping-module\":\"default\",\"default-view\":\"default\",\"o:resource_template\":{\"o:id\":2},\"o:resource_class\":{\"o:id\":32},\"o:owner\":{\"o:id\":1},\"o:is_public\":1,\"o:item_set\":[\"2\"],\"multivalue_separator\":\"||\",\"global_language\":\"\",\"action\":\"create\",\"identifier_column\":0,\"identifier_property\":\"\",\"action_unidentified\":\"skip\",\"rows_by_batch\":20,\"delimiter\":\",\",\"enclosure\":\"\\\"\",\"escape\":\"\\\\\"}', NULL, '2020-07-29 17:53:17', '2020-07-29 17:53:17'),
(2, 1, '61', 'completed', 'CSVImport\\Job\\Import', '{\"filename\":\"omeka-import-sample-ims.csv\",\"filesize\":\"3955\",\"filepath\":\"\\/tmp\\/omekaih3IJb\",\"media_type\":\"text\\/csv\",\"resource_type\":\"media\",\"comment\":\"\",\"automap_check_names_alone\":false,\"column-item\":[\"dcterms:identifier\"],\"column-data-type\":[\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\",\"literal\"],\"column-media_source\":{\"16\":\"tile\"},\"generic-data\":\"default\",\"media-source\":\"default\",\"o:resource_template\":{\"o:id\":3},\"o:resource_class\":{\"o:id\":26},\"o:owner\":{\"o:id\":1},\"o:is_public\":1,\"multivalue_separator\":\"||\",\"global_language\":\"\",\"action\":\"create\",\"identifier_column\":0,\"identifier_property\":\"\",\"action_unidentified\":\"skip\",\"rows_by_batch\":1,\"column-multivalue\":[],\"delimiter\":\",\",\"enclosure\":\"\\\"\",\"escape\":\"\\\\\"}', NULL, '2020-07-29 17:54:57', '2020-07-29 17:55:58'),
(3, 1, '82', 'completed', 'ImageServer\\Job\\Tiler', '{\"storageId\":\"73b7f49184ef3fe5c5f1f9e9a2d1faf19c4993f2\",\"storagePath\":\"original\\/73b7f49184ef3fe5c5f1f9e9a2d1faf19c4993f2.jpg\",\"storeOriginal\":true,\"type\":\"url\"}', NULL, '2020-07-29 17:55:08', '2020-07-29 18:01:53'),
(4, 1, '105', 'completed', 'ImageServer\\Job\\Tiler', '{\"storageId\":\"bc699722a174c59f6fb3028b06ab57cfe86cea40\",\"storagePath\":\"original\\/bc699722a174c59f6fb3028b06ab57cfe86cea40.jpg\",\"storeOriginal\":true,\"type\":\"url\"}', NULL, '2020-07-29 17:55:21', '2020-07-29 18:02:00'),
(5, 1, '140', 'completed', 'ImageServer\\Job\\Tiler', '{\"storageId\":\"d6d25b9d13553248627f660ee12c0a94c2fc1208\",\"storagePath\":\"original\\/d6d25b9d13553248627f660ee12c0a94c2fc1208.jpg\",\"storeOriginal\":true,\"type\":\"url\"}', NULL, '2020-07-29 17:55:34', '2020-07-29 18:00:37'),
(6, 1, '175', 'completed', 'ImageServer\\Job\\Tiler', '{\"storageId\":\"9263dd1c031fc128a9a429876adbdc9f9be5d3f3\",\"storagePath\":\"original\\/9263dd1c031fc128a9a429876adbdc9f9be5d3f3.jpg\",\"storeOriginal\":true,\"type\":\"url\"}', NULL, '2020-07-29 17:55:47', '2020-07-29 18:00:51'),
(7, 1, '210', 'completed', 'ImageServer\\Job\\Tiler', '{\"storageId\":\"80c697e9285157e0529925b6f0f72fd886a83590\",\"storagePath\":\"original\\/80c697e9285157e0529925b6f0f72fd886a83590.jpg\",\"storeOriginal\":true,\"type\":\"url\"}', NULL, '2020-07-29 17:55:58', '2020-07-29 18:01:51'),
(8, NULL, '26', 'completed', 'Omeka\\Job\\UpdateSiteItems', '{\"sites\":{\"1\":{\"o:summary\":\"\",\"fulltext_search\":\"\",\"property\":[{\"joiner\":\"and\",\"property\":\"\",\"type\":\"eq\",\"text\":\"\"}],\"resource_class_id\":[\"\"],\"resource_template_id\":[\"\"],\"item_set_id\":[\"\"],\"site_id\":\"\"}},\"action\":\"add\"}', NULL, '2020-11-12 18:25:59', '2020-11-12 18:25:59');
-- --------------------------------------------------------
--
-- Table structure for table `mapping`
--
CREATE TABLE `mapping` (
`id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`bounds` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `mapping_marker`
--
CREATE TABLE `mapping_marker` (
`id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`media_id` int(11) DEFAULT NULL,
`lat` double NOT NULL,
`lng` double NOT NULL,
`label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `mapping_marker`
--
INSERT INTO `mapping_marker` (`id`, `item_id`, `media_id`, `lat`, `lng`, `label`) VALUES
(1, 4, NULL, -22.903364, -43.223602, NULL),
(2, 5, NULL, -22.910046, -43.175833, NULL),
(3, 6, NULL, -22.894799, -43.21669, NULL),
(4, 7, NULL, -22.896965, -43.18003, NULL),
(5, 8, NULL, -22.986784, -43.198543, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `media`
--
CREATE TABLE `media` (
`id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`ingester` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`renderer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`data` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:json_array)',
`source` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`media_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`storage_id` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`extension` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sha256` char(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`size` bigint(20) DEFAULT NULL,
`has_original` tinyint(1) NOT NULL,
`has_thumbnails` tinyint(1) NOT NULL,
`position` int(11) DEFAULT NULL,
`lang` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `media`
--
INSERT INTO `media` (`id`, `item_id`, `ingester`, `renderer`, `data`, `source`, `media_type`, `storage_id`, `extension`, `sha256`, `size`, `has_original`, `has_thumbnails`, `position`, `lang`) VALUES
(9, 4, 'tile', 'tile', '{\"dimensions\":{\"original\":{\"width\":9515,\"height\":7706},\"large\":{\"width\":800,\"height\":648},\"medium\":{\"width\":200,\"height\":162},\"square\":{\"width\":200,\"height\":200}}}', 'https://rioiconography.sfo2.digitaloceanspaces.com/situatedviews/0072430cx097-12.jpg', 'image/jpeg', '73b7f49184ef3fe5c5f1f9e9a2d1faf19c4993f2', 'jpg', '10d9b92c3485fa4891cdb41456f55a80d8f32ecd7a03392bced65556ac9423cc', 13720928, 1, 1, 1, NULL),
(10, 5, 'tile', 'tile', '{\"dimensions\":{\"original\":{\"width\":9343,\"height\":7460},\"large\":{\"width\":800,\"height\":639},\"medium\":{\"width\":200,\"height\":160},\"square\":{\"width\":200,\"height\":200}}}', 'https://rioiconography.sfo2.digitaloceanspaces.com/situatedviews/0072430cx098-08.jpg', 'image/jpeg', 'bc699722a174c59f6fb3028b06ab57cfe86cea40', 'jpg', '1858ac99c3a889741b43ea8354b1f56a6d3d37d6d0375d41309d656696b6c018', 10824033, 1, 1, 1, NULL),
(11, 6, 'tile', 'tile', '{\"dimensions\":{\"original\":{\"width\":9159,\"height\":6327},\"large\":{\"width\":800,\"height\":553},\"medium\":{\"width\":200,\"height\":138},\"square\":{\"width\":200,\"height\":200}}}', 'https://rioiconography.sfo2.digitaloceanspaces.com/situatedviews/013RJ001004.jpg', 'image/jpeg', 'd6d25b9d13553248627f660ee12c0a94c2fc1208', 'jpg', '31a928d773faea572bab8e191f22a634bb448a9efa94129d7e6504923210696d', 6094931, 1, 1, 1, NULL),
(12, 7, 'tile', 'tile', '{\"dimensions\":{\"original\":{\"width\":8986,\"height\":6857},\"large\":{\"width\":800,\"height\":610},\"medium\":{\"width\":200,\"height\":153},\"square\":{\"width\":200,\"height\":200}}}', 'https://rioiconography.sfo2.digitaloceanspaces.com/situatedviews/013RJ001005.jpg', 'image/jpeg', '9263dd1c031fc128a9a429876adbdc9f9be5d3f3', 'jpg', 'a797b1a89e5e10d583b01cd813268aa7aff03c66e0a70f6549be78ee2bd131b7', 4940969, 1, 1, 1, NULL),
(13, 8, 'tile', 'tile', '{\"dimensions\":{\"original\":{\"width\":8999,\"height\":6852},\"large\":{\"width\":800,\"height\":609},\"medium\":{\"width\":200,\"height\":152},\"square\":{\"width\":200,\"height\":200}}}', 'https://rioiconography.sfo2.digitaloceanspaces.com/situatedviews/013RJ001009.jpg', 'image/jpeg', '80c697e9285157e0529925b6f0f72fd886a83590', 'jpg', 'c1fc64aed9979e49de2983ca913bc1de618fb822f42248b3a605f44a8ea3b8b6', 3982196, 1, 1, 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `migration`
--
CREATE TABLE `migration` (
`version` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `migration`
--
INSERT INTO `migration` (`version`) VALUES
('20171128053327'),
('20180412035023'),
('20180919072656'),
('20180924033501'),
('20181002015551'),
('20181004043735'),
('20181106060421'),
('20190307043537'),
('20190319020708'),
('20190412090532'),
('20190423040354'),
('20190423071228'),
('20190514061351'),
('20190515055359'),
('20190729023728'),
('20190809092609'),
('20190815062003'),
('20200224022356'),
('20200226064602'),
('20200325091157'),
('20200326091310'),
('20200803000000'),
('20200831000000');
-- --------------------------------------------------------
--
-- Table structure for table `module`
--
CREATE TABLE `module` (
`id` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_active` tinyint(1) NOT NULL,
`version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `module`
--
INSERT INTO `module` (`id`, `is_active`, `version`) VALUES
('CleanUrl', 1, '3.16.2.3'),
('CSVImport', 1, '2.2.0'),
('IiifServer', 1, '3.6.3.0'),
('ImageServer', 1, '3.6.3.0'),
('Mapping', 1, '1.4.0'),
('NumericDataTypes', 1, '1.5.1'),
('UniversalViewer', 1, '3.6.3.1');
-- --------------------------------------------------------
--
-- Table structure for table `numeric_data_types_duration`
--
CREATE TABLE `numeric_data_types_duration` (
`id` int(11) NOT NULL,
`resource_id` int(11) NOT NULL,
`property_id` int(11) NOT NULL,
`value` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `numeric_data_types_integer`
--
CREATE TABLE `numeric_data_types_integer` (
`id` int(11) NOT NULL,
`resource_id` int(11) NOT NULL,
`property_id` int(11) NOT NULL,
`value` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `numeric_data_types_interval`
--
CREATE TABLE `numeric_data_types_interval` (
`id` int(11) NOT NULL,
`resource_id` int(11) NOT NULL,
`property_id` int(11) NOT NULL,
`value` bigint(20) NOT NULL,
`value2` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `numeric_data_types_interval`
--
INSERT INTO `numeric_data_types_interval` (`id`, `resource_id`, `property_id`, `value`, `value2`) VALUES
(1, 4, 41, -2871676800, -2524521601),
(2, 5, 41, -2051222400, -1704153601),
(3, 6, 41, -1577923200, -1167609601);
-- --------------------------------------------------------
--
-- Table structure for table `numeric_data_types_timestamp`
--
CREATE TABLE `numeric_data_types_timestamp` (
`id` int(11) NOT NULL,
`resource_id` int(11) NOT NULL,
`property_id` int(11) NOT NULL,
`value` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `numeric_data_types_timestamp`
--
INSERT INTO `numeric_data_types_timestamp` (`id`, `resource_id`, `property_id`, `value`) VALUES
(1, 7, 7, -1546300800),
(2, 8, 7, -1546300800);
-- --------------------------------------------------------
--
-- Table structure for table `password_creation`
--
CREATE TABLE `password_creation` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`user_id` int(11) NOT NULL,
`created` datetime NOT NULL,
`activate` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `property`
--
CREATE TABLE `property` (
`id` int(11) NOT NULL,
`owner_id` int(11) DEFAULT NULL,
`vocabulary_id` int(11) NOT NULL,
`local_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`comment` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `property`
--
INSERT INTO `property` (`id`, `owner_id`, `vocabulary_id`, `local_name`, `label`, `comment`) VALUES
(1, NULL, 1, 'title', 'Title', 'A name given to the resource.'),
(2, NULL, 1, 'creator', 'Creator', 'An entity primarily responsible for making the resource.'),
(3, NULL, 1, 'subject', 'Subject', 'The topic of the resource.'),
(4, NULL, 1, 'description', 'Description', 'An account of the resource.'),
(5, NULL, 1, 'publisher', 'Publisher', 'An entity responsible for making the resource available.'),
(6, NULL, 1, 'contributor', 'Contributor', 'An entity responsible for making contributions to the resource.'),
(7, NULL, 1, 'date', 'Date', 'A point or period of time associated with an event in the lifecycle of the resource.'),
(8, NULL, 1, 'type', 'Type', 'The nature or genre of the resource.'),
(9, NULL, 1, 'format', 'Format', 'The file format, physical medium, or dimensions of the resource.'),
(10, NULL, 1, 'identifier', 'Identifier', 'An unambiguous reference to the resource within a given context.'),
(11, NULL, 1, 'source', 'Source', 'A related resource from which the described resource is derived.'),
(12, NULL, 1, 'language', 'Language', 'A language of the resource.'),
(13, NULL, 1, 'relation', 'Relation', 'A related resource.'),
(14, NULL, 1, 'coverage', 'Coverage', 'The spatial or temporal topic of the resource, the spatial applicability of the resource, or the jurisdiction under which the resource is relevant.'),
(15, NULL, 1, 'rights', 'Rights', 'Information about rights held in and over the resource.'),
(16, NULL, 1, 'audience', 'Audience', 'A class of entity for whom the resource is intended or useful.'),
(17, NULL, 1, 'alternative', 'Alternative Title', 'An alternative name for the resource.'),
(18, NULL, 1, 'tableOfContents', 'Table Of Contents', 'A list of subunits of the resource.'),
(19, NULL, 1, 'abstract', 'Abstract', 'A summary of the resource.'),
(20, NULL, 1, 'created', 'Date Created', 'Date of creation of the resource.'),
(21, NULL, 1, 'valid', 'Date Valid', 'Date (often a range) of validity of a resource.'),
(22, NULL, 1, 'available', 'Date Available', 'Date (often a range) that the resource became or will become available.'),
(23, NULL, 1, 'issued', 'Date Issued', 'Date of formal issuance (e.g., publication) of the resource.'),
(24, NULL, 1, 'modified', 'Date Modified', 'Date on which the resource was changed.'),
(25, NULL, 1, 'extent', 'Extent', 'The size or duration of the resource.'),
(26, NULL, 1, 'medium', 'Medium', 'The material or physical carrier of the resource.'),
(27, NULL, 1, 'isVersionOf', 'Is Version Of', 'A related resource of which the described resource is a version, edition, or adaptation.'),
(28, NULL, 1, 'hasVersion', 'Has Version', 'A related resource that is a version, edition, or adaptation of the described resource.'),
(29, NULL, 1, 'isReplacedBy', 'Is Replaced By', 'A related resource that supplants, displaces, or supersedes the described resource.'),
(30, NULL, 1, 'replaces', 'Replaces', 'A related resource that is supplanted, displaced, or superseded by the described resource.'),
(31, NULL, 1, 'isRequiredBy', 'Is Required By', 'A related resource that requires the described resource to support its function, delivery, or coherence.'),
(32, NULL, 1, 'requires', 'Requires', 'A related resource that is required by the described resource to support its function, delivery, or coherence.'),
(33, NULL, 1, 'isPartOf', 'Is Part Of', 'A related resource in which the described resource is physically or logically included.'),
(34, NULL, 1, 'hasPart', 'Has Part', 'A related resource that is included either physically or logically in the described resource.'),
(35, NULL, 1, 'isReferencedBy', 'Is Referenced By', 'A related resource that references, cites, or otherwise points to the described resource.'),
(36, NULL, 1, 'references', 'References', 'A related resource that is referenced, cited, or otherwise pointed to by the described resource.'),
(37, NULL, 1, 'isFormatOf', 'Is Format Of', 'A related resource that is substantially the same as the described resource, but in another format.'),
(38, NULL, 1, 'hasFormat', 'Has Format', 'A related resource that is substantially the same as the pre-existing described resource, but in another format.'),
(39, NULL, 1, 'conformsTo', 'Conforms To', 'An established standard to which the described resource conforms.'),
(40, NULL, 1, 'spatial', 'Spatial Coverage', 'Spatial characteristics of the resource.'),
(41, NULL, 1, 'temporal', 'Temporal Coverage', 'Temporal characteristics of the resource.'),
(42, NULL, 1, 'mediator', 'Mediator', 'An entity that mediates access to the resource and for whom the resource is intended or useful.'),
(43, NULL, 1, 'dateAccepted', 'Date Accepted', 'Date of acceptance of the resource.'),
(44, NULL, 1, 'dateCopyrighted', 'Date Copyrighted', 'Date of copyright.'),
(45, NULL, 1, 'dateSubmitted', 'Date Submitted', 'Date of submission of the resource.'),
(46, NULL, 1, 'educationLevel', 'Audience Education Level', 'A class of entity, defined in terms of progression through an educational or training context, for which the described resource is intended.'),
(47, NULL, 1, 'accessRights', 'Access Rights', 'Information about who can access the resource or an indication of its security status.'),
(48, NULL, 1, 'bibliographicCitation', 'Bibliographic Citation', 'A bibliographic reference for the resource.'),
(49, NULL, 1, 'license', 'License', 'A legal document giving official permission to do something with the resource.'),
(50, NULL, 1, 'rightsHolder', 'Rights Holder', 'A person or organization owning or managing rights over the resource.'),
(51, NULL, 1, 'provenance', 'Provenance', 'A statement of any changes in ownership and custody of the resource since its creation that are significant for its authenticity, integrity, and interpretation.'),
(52, NULL, 1, 'instructionalMethod', 'Instructional Method', 'A process, used to engender knowledge, attitudes and skills, that the described resource is designed to support.'),
(53, NULL, 1, 'accrualMethod', 'Accrual Method', 'The method by which items are added to a collection.'),
(54, NULL, 1, 'accrualPeriodicity', 'Accrual Periodicity', 'The frequency with which items are added to a collection.'),
(55, NULL, 1, 'accrualPolicy', 'Accrual Policy', 'The policy governing the addition of items to a collection.'),
(56, NULL, 3, 'affirmedBy', 'affirmedBy', 'A legal decision that affirms a ruling.'),
(57, NULL, 3, 'annotates', 'annotates', 'Critical or explanatory note for a Document.'),
(58, NULL, 3, 'authorList', 'list of authors', 'An ordered list of authors. Normally, this list is seen as a priority list that order authors by importance.'),
(59, NULL, 3, 'citedBy', 'cited by', 'Relates a document to another document that cites the\nfirst document.'),
(60, NULL, 3, 'cites', 'cites', 'Relates a document to another document that is cited\nby the first document as reference, comment, review, quotation or for\nanother purpose.'),
(61, NULL, 3, 'contributorList', 'list of contributors', 'An ordered list of contributors. Normally, this list is seen as a priority list that order contributors by importance.'),
(62, NULL, 3, 'court', 'court', 'A court associated with a legal document; for example, that which issues a decision.'),
(63, NULL, 3, 'degree', 'degree', 'The thesis degree.'),
(64, NULL, 3, 'director', 'director', 'A Film director.'),
(65, NULL, 3, 'distributor', 'distributor', 'Distributor of a document or a collection of documents.'),
(66, NULL, 3, 'editor', 'editor', 'A person having managerial and sometimes policy-making responsibility for the editorial part of a publishing firm or of a newspaper, magazine, or other publication.'),
(67, NULL, 3, 'editorList', 'list of editors', 'An ordered list of editors. Normally, this list is seen as a priority list that order editors by importance.'),
(68, NULL, 3, 'interviewee', 'interviewee', 'An agent that is interviewed by another agent.'),
(69, NULL, 3, 'interviewer', 'interviewer', 'An agent that interview another agent.'),
(70, NULL, 3, 'issuer', 'issuer', 'An entity responsible for issuing often informally published documents such as press releases, reports, etc.'),
(71, NULL, 3, 'organizer', 'organizer', 'The organizer of an event; includes conference organizers, but also government agencies or other bodies that are responsible for conducting hearings.'),
(72, NULL, 3, 'owner', 'owner', 'Owner of a document or a collection of documents.'),
(73, NULL, 3, 'performer', 'performer', NULL),
(74, NULL, 3, 'presentedAt', 'presented at', 'Relates a document to an event; for example, a paper to a conference.'),
(75, NULL, 3, 'presents', 'presents', 'Relates an event to associated documents; for example, conference to a paper.'),
(76, NULL, 3, 'producer', 'producer', 'Producer of a document or a collection of documents.'),
(77, NULL, 3, 'recipient', 'recipient', 'An agent that receives a communication document.'),
(78, NULL, 3, 'reproducedIn', 'reproducedIn', 'The resource in which another resource is reproduced.'),
(79, NULL, 3, 'reversedBy', 'reversedBy', 'A legal decision that reverses a ruling.'),
(80, NULL, 3, 'reviewOf', 'review of', 'Relates a review document to a reviewed thing (resource, item, etc.).'),
(81, NULL, 3, 'status', 'status', 'The publication status of (typically academic) content.'),
(82, NULL, 3, 'subsequentLegalDecision', 'subsequentLegalDecision', 'A legal decision on appeal that takes action on a case (affirming it, reversing it, etc.).'),
(83, NULL, 3, 'transcriptOf', 'transcript of', 'Relates a document to some transcribed original.'),
(84, NULL, 3, 'translationOf', 'translation of', 'Relates a translated document to the original document.'),
(85, NULL, 3, 'translator', 'translator', 'A person who translates written document from one language to another.'),
(86, NULL, 3, 'abstract', 'abstract', 'A summary of the resource.'),
(87, NULL, 3, 'argued', 'date argued', 'The date on which a legal case is argued before a court. Date is of format xsd:date'),
(88, NULL, 3, 'asin', 'asin', NULL),
(89, NULL, 3, 'chapter', 'chapter', 'An chapter number'),
(90, NULL, 3, 'coden', 'coden', NULL),
(91, NULL, 3, 'content', 'content', 'This property is for a plain-text rendering of the content of a Document. While the plain-text content of an entire document could be described by this property.'),
(92, NULL, 3, 'doi', 'doi', NULL),
(93, NULL, 3, 'eanucc13', 'eanucc13', NULL),
(94, NULL, 3, 'edition', 'edition', 'The name defining a special edition of a document. Normally its a literal value composed of a version number and words.'),
(95, NULL, 3, 'eissn', 'eissn', NULL),
(96, NULL, 3, 'gtin14', 'gtin14', NULL),
(97, NULL, 3, 'handle', 'handle', NULL),
(98, NULL, 3, 'identifier', 'identifier', NULL),
(99, NULL, 3, 'isbn', 'isbn', NULL),
(100, NULL, 3, 'isbn10', 'isbn10', NULL),
(101, NULL, 3, 'isbn13', 'isbn13', NULL),
(102, NULL, 3, 'issn', 'issn', NULL),
(103, NULL, 3, 'issue', 'issue', 'An issue number'),
(104, NULL, 3, 'lccn', 'lccn', NULL),
(105, NULL, 3, 'locator', 'locator', 'A description (often numeric) that locates an item within a containing document or collection.'),
(106, NULL, 3, 'numPages', 'number of pages', 'The number of pages contained in a document'),
(107, NULL, 3, 'numVolumes', 'number of volumes', 'The number of volumes contained in a collection of documents (usually a series, periodical, etc.).'),
(108, NULL, 3, 'number', 'number', 'A generic item or document number. Not to be confused with issue number.'),
(109, NULL, 3, 'oclcnum', 'oclcnum', NULL),
(110, NULL, 3, 'pageEnd', 'page end', 'Ending page number within a continuous page range.'),
(111, NULL, 3, 'pageStart', 'page start', 'Starting page number within a continuous page range.'),
(112, NULL, 3, 'pages', 'pages', 'A string of non-contiguous page spans that locate a Document within a Collection. Example: 23-25, 34, 54-56. For continuous page ranges, use the pageStart and pageEnd properties.'),
(113, NULL, 3, 'pmid', 'pmid', NULL),
(114, NULL, 3, 'prefixName', 'prefix name', 'The prefix of a name'),
(115, NULL, 3, 'section', 'section', 'A section number'),
(116, NULL, 3, 'shortDescription', 'shortDescription', NULL),
(117, NULL, 3, 'shortTitle', 'short title', 'The abbreviation of a title.'),
(118, NULL, 3, 'sici', 'sici', NULL),
(119, NULL, 3, 'suffixName', 'suffix name', 'The suffix of a name'),
(120, NULL, 3, 'upc', 'upc', NULL),
(121, NULL, 3, 'uri', 'uri', 'Universal Resource Identifier of a document'),
(122, NULL, 3, 'volume', 'volume', 'A volume number'),
(123, NULL, 4, 'mbox', 'personal mailbox', 'A personal mailbox, ie. an Internet mailbox associated with exactly one owner, the first owner of this mailbox. This is a \'static inverse functional property\', in that there is (across time and change) at most one individual that ever has any particular value for foaf:mbox.'),
(124, NULL, 4, 'mbox_sha1sum', 'sha1sum of a personal mailbox URI name', 'The sha1sum of the URI of an Internet mailbox associated with exactly one owner, the first owner of the mailbox.'),
(125, NULL, 4, 'gender', 'gender', 'The gender of this Agent (typically but not necessarily \'male\' or \'female\').'),
(126, NULL, 4, 'geekcode', 'geekcode', 'A textual geekcode for this person, see http://www.geekcode.com/geek.html'),
(127, NULL, 4, 'dnaChecksum', 'DNA checksum', 'A checksum for the DNA of some thing. Joke.'),
(128, NULL, 4, 'sha1', 'sha1sum (hex)', 'A sha1sum hash, in hex.'),
(129, NULL, 4, 'based_near', 'based near', 'A location that something is based near, for some broadly human notion of near.'),
(130, NULL, 4, 'title', 'title', 'Title (Mr, Mrs, Ms, Dr. etc)'),
(131, NULL, 4, 'nick', 'nickname', 'A short informal nickname characterising an agent (includes login identifiers, IRC and other chat nicknames).'),
(132, NULL, 4, 'jabberID', 'jabber ID', 'A jabber ID for something.'),
(133, NULL, 4, 'aimChatID', 'AIM chat ID', 'An AIM chat ID'),
(134, NULL, 4, 'skypeID', 'Skype ID', 'A Skype ID'),
(135, NULL, 4, 'icqChatID', 'ICQ chat ID', 'An ICQ chat ID'),
(136, NULL, 4, 'yahooChatID', 'Yahoo chat ID', 'A Yahoo chat ID'),
(137, NULL, 4, 'msnChatID', 'MSN chat ID', 'An MSN chat ID'),
(138, NULL, 4, 'name', 'name', 'A name for some thing.'),
(139, NULL, 4, 'firstName', 'firstName', 'The first name of a person.'),
(140, NULL, 4, 'lastName', 'lastName', 'The last name of a person.'),
(141, NULL, 4, 'givenName', 'Given name', 'The given name of some person.'),
(142, NULL, 4, 'givenname', 'Given name', 'The given name of some person.'),
(143, NULL, 4, 'surname', 'Surname', 'The surname of some person.'),
(144, NULL, 4, 'family_name', 'family_name', 'The family name of some person.'),
(145, NULL, 4, 'familyName', 'familyName', 'The family name of some person.'),
(146, NULL, 4, 'phone', 'phone', 'A phone, specified using fully qualified tel: URI scheme (refs: http://www.w3.org/Addressing/schemes.html#tel).'),
(147, NULL, 4, 'homepage', 'homepage', 'A homepage for some thing.'),
(148, NULL, 4, 'weblog', 'weblog', 'A weblog of some thing (whether person, group, company etc.).'),
(149, NULL, 4, 'openid', 'openid', 'An OpenID for an Agent.'),
(150, NULL, 4, 'tipjar', 'tipjar', 'A tipjar document for this agent, describing means for payment and reward.'),
(151, NULL, 4, 'plan', 'plan', 'A .plan comment, in the tradition of finger and \'.plan\' files.'),
(152, NULL, 4, 'made', 'made', 'Something that was made by this agent.'),
(153, NULL, 4, 'maker', 'maker', 'An agent that made this thing.'),
(154, NULL, 4, 'img', 'image', 'An image that can be used to represent some thing (ie. those depictions which are particularly representative of something, eg. one\'s photo on a homepage).'),
(155, NULL, 4, 'depiction', 'depiction', 'A depiction of some thing.'),
(156, NULL, 4, 'depicts', 'depicts', 'A thing depicted in this representation.'),
(157, NULL, 4, 'thumbnail', 'thumbnail', 'A derived thumbnail image.'),
(158, NULL, 4, 'myersBriggs', 'myersBriggs', 'A Myers Briggs (MBTI) personality classification.'),
(159, NULL, 4, 'workplaceHomepage', 'workplace homepage', 'A workplace homepage of some person; the homepage of an organization they work for.'),
(160, NULL, 4, 'workInfoHomepage', 'work info homepage', 'A work info homepage of some person; a page about their work for some organization.'),
(161, NULL, 4, 'schoolHomepage', 'schoolHomepage', 'A homepage of a school attended by the person.'),
(162, NULL, 4, 'knows', 'knows', 'A person known by this person (indicating some level of reciprocated interaction between the parties).'),
(163, NULL, 4, 'interest', 'interest', 'A page about a topic of interest to this person.'),
(164, NULL, 4, 'topic_interest', 'topic_interest', 'A thing of interest to this person.'),
(165, NULL, 4, 'publications', 'publications', 'A link to the publications of this person.'),
(166, NULL, 4, 'currentProject', 'current project', 'A current project this person works on.'),
(167, NULL, 4, 'pastProject', 'past project', 'A project this person has previously worked on.'),
(168, NULL, 4, 'fundedBy', 'funded by', 'An organization funding a project or person.'),
(169, NULL, 4, 'logo', 'logo', 'A logo representing some thing.'),
(170, NULL, 4, 'topic', 'topic', 'A topic of some page or document.'),
(171, NULL, 4, 'primaryTopic', 'primary topic', 'The primary topic of some page or document.'),
(172, NULL, 4, 'focus', 'focus', 'The underlying or \'focal\' entity associated with some SKOS-described concept.'),
(173, NULL, 4, 'isPrimaryTopicOf', 'is primary topic of', 'A document that this thing is the primary topic of.'),
(174, NULL, 4, 'page', 'page', 'A page or document about this thing.'),
(175, NULL, 4, 'theme', 'theme', 'A theme.'),
(176, NULL, 4, 'account', 'account', 'Indicates an account held by this agent.'),
(177, NULL, 4, 'holdsAccount', 'account', 'Indicates an account held by this agent.'),
(178, NULL, 4, 'accountServiceHomepage', 'account service homepage', 'Indicates a homepage of the service provide for this online account.'),
(179, NULL, 4, 'accountName', 'account name', 'Indicates the name (identifier) associated with this online account.'),
(180, NULL, 4, 'member', 'member', 'Indicates a member of a Group'),
(181, NULL, 4, 'membershipClass', 'membershipClass', 'Indicates the class of individuals that are a member of a Group'),
(182, NULL, 4, 'birthday', 'birthday', 'The birthday of this Agent, represented in mm-dd string form, eg. \'12-31\'.'),
(183, NULL, 4, 'age', 'age', 'The age in years of some agent.'),
(184, NULL, 4, 'status', 'status', 'A string expressing what the user is happy for the general public (normally) to know about their current activity.'),
(185, 1, 5, 'datePosted', 'datePosted', 'Publication date of an online listing.'),
(186, 1, 5, 'geoOverlaps', 'geoOverlaps', 'Represents a relationship between two geometries (or the places they represent), relating a geometry to another that geospatially overlaps it, i.e. they have some but not all points in common. As defined in <a href=\"https://en.wikipedia.org/wiki/DE-9IM\">DE-9IM</a>.'),
(187, 1, 5, 'funder', 'funder', 'A person or organization that supports (sponsors) something through some kind of financial contribution.'),
(188, 1, 5, 'character', 'character', 'Fictional person connected with a creative work.'),
(189, 1, 5, 'educationRequirements', 'educationRequirements', 'Educational background needed for the position or Occupation.'),
(190, 1, 5, 'quest', 'quest', 'The task that a player-controlled character, or group of characters may complete in order to gain a reward.'),
(191, 1, 5, 'drug', 'drug', 'Specifying a drug or medicine used in a medication procedure'),
(192, 1, 5, 'yearlyRevenue', 'yearlyRevenue', 'The size of the business in annual revenue.'),
(193, 1, 5, 'storageRequirements', 'storageRequirements', 'Storage requirements (free space required).'),
(194, 1, 5, 'educationalProgramMode', 'educationalProgramMode', 'Similar to courseMode, The medium or means of delivery of the program as a whole. The value may either be a text label (e.g. \"online\", \"onsite\" or \"blended\"; \"synchronous\" or \"asynchronous\"; \"full-time\" or \"part-time\") or a URL reference to a term from a controlled vocabulary (e.g. https://ceds.ed.gov/element/001311#Asynchronous ).'),
(195, 1, 5, 'costPerUnit', 'costPerUnit', 'The cost per unit of the drug.'),
(196, 1, 5, 'priceRange', 'priceRange', 'The price range of the business, for example <code>$$$</code>.'),
(197, 1, 5, 'doseValue', 'doseValue', 'The value of the dose, e.g. 500.'),
(198, 1, 5, 'collectionSize', 'collectionSize', 'The number of items in the <a class=\"localLink\" href=\"http://schema.org/Collection\">Collection</a>.'),
(199, 1, 5, 'option', 'option', 'A sub property of object. The options subject to this action.'),
(200, 1, 5, 'acquiredFrom', 'acquiredFrom', 'The organization or person from which the product was acquired.'),
(201, 1, 5, 'follows', 'follows', 'The most generic uni-directional social relation.'),
(202, 1, 5, 'targetName', 'targetName', 'The name of a node in an established educational framework.'),
(203, 1, 5, 'openingHoursSpecification', 'openingHoursSpecification', 'The opening hours of a certain place.'),
(204, 1, 5, 'geoIntersects', 'geoIntersects', 'Represents spatial relations in which two geometries (or the places they represent) have at least one point in common. As defined in <a href=\"https://en.wikipedia.org/wiki/DE-9IM\">DE-9IM</a>.'),
(205, 1, 5, 'expires', 'expires', 'Date the content expires and is no longer useful or available. For example a <a class=\"localLink\" href=\"http://schema.org/VideoObject\">VideoObject</a> or <a class=\"localLink\" href=\"http://schema.org/NewsArticle\">NewsArticle</a> whose availability or relevance is time-limited, or a <a class=\"localLink\" href=\"http://schema.org/ClaimReview\">ClaimReview</a> fact check whose publisher wants to indicate that it may no longer be relevant (or helpful to highlight) after some date.'),
(206, 1, 5, 'sugarContent', 'sugarContent', 'The number of grams of sugar.'),
(207, 1, 5, 'worstRating', 'worstRating', 'The lowest value allowed in this rating system. If worstRating is omitted, 1 is assumed.'),
(208, 1, 5, 'domiciledMortgage', 'domiciledMortgage', 'Whether borrower is a resident of the jurisdiction where the property is located.'),
(209, 1, 5, 'loanPaymentFrequency', 'loanPaymentFrequency', 'Frequency of payments due, i.e. number of months between payments. This is defined as a frequency, i.e. the reciprocal of a period of time.'),
(210, 1, 5, 'feesAndCommissionsSpecification', 'feesAndCommissionsSpecification', 'Description of fees, commissions, and other terms applied either to a class of financial product, or by a financial service organization.'),
(211, 1, 5, 'isUnlabelledFallback', 'isUnlabelledFallback', 'This can be marked \'true\' to indicate that some published <a class=\"localLink\" href=\"http://schema.org/DeliveryTimeSettings\">DeliveryTimeSettings</a> or <a class=\"localLink\" href=\"http://schema.org/ShippingRateSettings\">ShippingRateSettings</a> are intended to apply to all <a class=\"localLink\" href=\"http://schema.org/OfferShippingDetails\">OfferShippingDetails</a> published by the same merchant, when referenced by a <a class=\"localLink\" href=\"http://schema.org/shippingSettingsLink\">shippingSettingsLink</a> in those settings. It is not meaningful to use a \'true\' value for this property alongside a transitTimeLabel (for <a class=\"localLink\" href=\"http://schema.org/DeliveryTimeSettings\">DeliveryTimeSettings</a>) or shippingLabel (for <a class=\"localLink\" href=\"http://schema.org/ShippingRateSettings\">ShippingRateSettings</a>), since this property is for use with unlabelled settings.'),
(212, 1, 5, 'numberOfDoors', 'numberOfDoors', 'The number of doors.<br/><br/>\n\nTypical unit code(s): C62'),
(213, 1, 5, 'inDefinedTermSet', 'inDefinedTermSet', 'A <a class=\"localLink\" href=\"http://schema.org/DefinedTermSet\">DefinedTermSet</a> that contains this term.'),
(214, 1, 5, 'isAvailableGenerically', 'isAvailableGenerically', 'True if the drug is available in a generic form (regardless of name).'),
(215, 1, 5, 'brand', 'brand', 'The brand(s) associated with a product or service, or the brand(s) maintained by an organization or business person.'),
(216, 1, 5, 'offerCount', 'offerCount', 'The number of offers for the product.'),
(217, 1, 5, 'availableIn', 'availableIn', 'The location in which the strength is available.'),
(218, 1, 5, 'requiresSubscription', 'requiresSubscription', 'Indicates if use of the media require a subscription (either paid or free). Allowed values are <code>true</code> or <code>false</code> (note that an earlier version had \'yes\', \'no\').'),
(219, 1, 5, 'contraindication', 'contraindication', 'A contraindication for this therapy.'),
(220, 1, 5, 'stage', 'stage', 'The stage of the condition, if applicable.'),
(221, 1, 5, 'artworkSurface', 'artworkSurface', 'The supporting materials for the artwork, e.g. Canvas, Paper, Wood, Board, etc.'),
(222, 1, 5, 'checkinTime', 'checkinTime', 'The earliest someone may check into a lodging establishment.'),
(223, 1, 5, 'serialNumber', 'serialNumber', 'The serial number or any alphanumeric identifier of a particular product. When attached to an offer, it is a shortcut for the serial number of the product included in the offer.'),
(224, 1, 5, 'transmissionMethod', 'transmissionMethod', 'How the disease spreads, either as a route or vector, for example \'direct contact\', \'Aedes aegypti\', etc.'),
(225, 1, 5, 'accessibilitySummary', 'accessibilitySummary', 'A human-readable summary of specific accessibility features or deficiencies, consistent with the other accessibility metadata but expressing subtleties such as \"short descriptions are present but long descriptions will be needed for non-visual users\" or \"short descriptions are present and no long descriptions are needed.\"'),
(226, 1, 5, 'performTime', 'performTime', 'The length of time it takes to perform instructions or a direction (not including time to prepare the supplies), in <a href=\"http://en.wikipedia.org/wiki/ISO_8601\">ISO 8601 duration format</a>.'),
(227, 1, 5, 'engineDisplacement', 'engineDisplacement', 'The volume swept by all of the pistons inside the cylinders of an internal combustion engine in a single movement. <br/><br/>\n\nTypical unit code(s): CMQ for cubic centimeter, LTR for liters, INQ for cubic inches\n* Note 1: You can link to information about how the given value has been determined using the <a class=\"localLink\" href=\"http://schema.org/valueReference\">valueReference</a> property.\n* Note 2: You can use <a class=\"localLink\" href=\"http://schema.org/minValue\">minValue</a> and <a class=\"localLink\" href=\"http://schema.org/maxValue\">maxValue</a> to indicate ranges.'),
(228, 1, 5, 'billingIncrement', 'billingIncrement', 'This property specifies the minimal quantity and rounding increment that will be the basis for the billing. The unit of measurement is specified by the unitCode property.'),
(229, 1, 5, 'alternateName', 'alternateName', 'An alias for the item.'),
(230, 1, 5, 'longitude', 'longitude', 'The longitude of a location. For example <code>-122.08585</code> (<a href=\"https://en.wikipedia.org/wiki/World_Geodetic_System\">WGS 84</a>).'),
(231, 1, 5, 'cvdNumC19OverflowPats', 'cvdNumC19OverflowPats', 'numc19overflowpats - ED/OVERFLOW: Patients with suspected or confirmed COVID-19 who are in the ED or any overflow location awaiting an inpatient bed.'),
(232, 1, 5, 'numberedPosition', 'numberedPosition', 'A number associated with a role in an organization, for example, the number on an athlete\'s jersey.'),
(233, 1, 5, 'subTest', 'subTest', 'A component test of the panel.'),
(234, 1, 5, 'textValue', 'textValue', 'Text value being annotated.'),
(235, 1, 5, 'percentile10', 'percentile10', 'The 10th percentile value.'),
(236, 1, 5, 'recordingOf', 'recordingOf', 'The composition this track is a recording of.'),
(237, 1, 5, 'discount', 'discount', 'Any discount applied (to an Order).'),
(238, 1, 5, 'icaoCode', 'icaoCode', 'ICAO identifier for an airport.'),
(239, 1, 5, 'itemCondition', 'itemCondition', 'A predefined value from OfferItemCondition or a textual description of the condition of the product or service, or the products or services included in the offer.'),
(240, 1, 5, 'securityScreening', 'securityScreening', 'The type of security screening the passenger is subject to.'),
(241, 1, 5, 'seatSection', 'seatSection', 'The section location of the reserved seat (e.g. Orchestra).'),
(242, 1, 5, 'width', 'width', 'The width of the item.'),
(243, 1, 5, 'seriousAdverseOutcome', 'seriousAdverseOutcome', 'A possible serious complication and/or serious side effect of this therapy. Serious adverse outcomes include those that are life-threatening; result in death, disability, or permanent damage; require hospitalization or prolong existing hospitalization; cause congenital anomalies or birth defects; or jeopardize the patient and may require medical or surgical intervention to prevent one of the outcomes in this definition.'),
(244, 1, 5, 'diagnosis', 'diagnosis', 'One or more alternative conditions considered in the differential diagnosis process as output of a diagnosis process.'),
(245, 1, 5, 'dietFeatures', 'dietFeatures', 'Nutritional information specific to the dietary plan. May include dietary recommendations on what foods to avoid, what foods to consume, and specific alterations/deviations from the USDA or other regulatory body\'s approved dietary guidelines.'),
(246, 1, 5, 'cookTime', 'cookTime', 'The time it takes to actually cook the dish, in <a href=\"http://en.wikipedia.org/wiki/ISO_8601\">ISO 8601 duration format</a>.'),
(247, 1, 5, 'programName', 'programName', 'The program providing the membership.'),
(248, 1, 5, 'servicePhone', 'servicePhone', 'The phone number to use to access the service.'),
(249, 1, 5, 'gtin8', 'gtin8', 'The <a href=\"http://apps.gs1.org/GDD/glossary/Pages/GTIN-8.aspx\">GTIN-8</a> code of the product, or the product to which the offer refers. This code is also known as EAN/UCC-8 or 8-digit EAN. See <a href=\"http://www.gs1.org/barcodes/technical/idkeys/gtin\">GS1 GTIN Summary</a> for more details.'),
(250, 1, 5, 'issueNumber', 'issueNumber', 'Identifies the issue of publication; for example, \"iii\" or \"2\".'),
(251, 1, 5, 'citation', 'citation', 'A citation or reference to another creative work, such as another publication, web page, scholarly article, etc.'),
(252, 1, 5, 'telephone', 'telephone', 'The telephone number.'),
(253, 1, 5, 'additionalProperty', 'additionalProperty', 'A property-value pair representing an additional characteristics of the entitity, e.g. a product feature or another characteristic for which there is no matching property in schema.org.<br/><br/>\n\nNote: Publishers should be aware that applications designed to use specific schema.org properties (e.g. http://schema.org/width, http://schema.org/color, http://schema.org/gtin13, ...) will typically expect such data to be provided using those properties, rather than using the generic property/value mechanism.'),
(254, 1, 5, 'reviews', 'reviews', 'Review of the item.'),
(255, 1, 5, 'typicalCreditsPerTerm', 'typicalCreditsPerTerm', 'The number of credits or units a full-time student would be expected to take in 1 term however \'term\' is defined by the institution.'),
(256, 1, 5, 'homeLocation', 'homeLocation', 'A contact location for a person\'s residence.'),
(257, 1, 5, 'bloodSupply', 'bloodSupply', 'The blood vessel that carries blood from the heart to the muscle.'),
(258, 1, 5, 'coursePrerequisites', 'coursePrerequisites', 'Requirements for taking the Course. May be completion of another <a class=\"localLink\" href=\"http://schema.org/Course\">Course</a> or a textual description like \"permission of instructor\". Requirements may be a pre-requisite competency, referenced using <a class=\"localLink\" href=\"http://schema.org/AlignmentObject\">AlignmentObject</a>.'),
(259, 1, 5, 'endorsers', 'endorsers', 'People or organizations that endorse the plan.'),
(260, 1, 5, 'trailer', 'trailer', 'The trailer of a movie or tv/radio series, season, episode, etc.'),
(261, 1, 5, 'inBroadcastLineup', 'inBroadcastLineup', 'The CableOrSatelliteService offering the channel.'),
(262, 1, 5, 'acceptedAnswer', 'acceptedAnswer', 'The answer(s) that has been accepted as best, typically on a Question/Answer site. Sites vary in their selection mechanisms, e.g. drawing on community opinion and/or the view of the Question author.'),
(263, 1, 5, 'color', 'color', 'The color of the product.'),
(264, 1, 5, 'yearBuilt', 'yearBuilt', 'The year an <a class=\"localLink\" href=\"http://schema.org/Accommodation\">Accommodation</a> was constructed. This corresponds to the <a href=\"https://ddwiki.reso.org/display/DDW17/YearBuilt+Field\">YearBuilt field in RESO</a>.'),
(265, 1, 5, 'incentives', 'incentives', 'Description of bonus and commission compensation aspects of the job.'),
(266, 1, 5, 'memoryRequirements', 'memoryRequirements', 'Minimum memory requirements.'),
(267, 1, 5, 'result', 'result', 'The result produced in the action. e.g. John wrote <em>a book</em>.'),
(268, 1, 5, 'recordedAs', 'recordedAs', 'An audio recording of the work.'),
(269, 1, 5, 'deliveryMethod', 'deliveryMethod', 'A sub property of instrument. The method of delivery.'),
(270, 1, 5, 'alumni', 'alumni', 'Alumni of an organization.'),
(271, 1, 5, 'possibleTreatment', 'possibleTreatment', 'A possible treatment to address this condition, sign or symptom.'),
(272, 1, 5, 'subEvents', 'subEvents', 'Events that are a part of this event. For example, a conference event includes many presentations, each subEvents of the conference.'),
(273, 1, 5, 'schemaVersion', 'schemaVersion', 'Indicates (by URL or string) a particular version of a schema used in some CreativeWork. For example, a document could declare a schemaVersion using an URL such as http://schema.org/version/2.0/ if precise indication of schema version was required by some application.'),
(274, 1, 5, 'addOn', 'addOn', 'An additional offer that can only be obtained in combination with the first base offer (e.g. supplements and extensions that are available for a surcharge).'),
(275, 1, 5, 'gameServer', 'gameServer', 'The server on which it is possible to play the game.'),
(276, 1, 5, 'birthDate', 'birthDate', 'Date of birth.'),
(277, 1, 5, 'videoFrameSize', 'videoFrameSize', 'The frame size of the video.'),
(278, 1, 5, 'roleName', 'roleName', 'A role played, performed or filled by a person or organization. For example, the team of creators for a comic book might fill the roles named \'inker\', \'penciller\', and \'letterer\'; or an athlete in a SportsTeam might play in the position named \'Quarterback\'.'),
(279, 1, 5, 'servicePostalAddress', 'servicePostalAddress', 'The address for accessing the service by mail.'),
(280, 1, 5, 'priceCurrency', 'priceCurrency', 'The currency of the price, or a price component when attached to <a class=\"localLink\" href=\"http://schema.org/PriceSpecification\">PriceSpecification</a> and its subtypes.<br/><br/>\n\nUse standard formats: <a href=\"http://en.wikipedia.org/wiki/ISO_4217\">ISO 4217 currency format</a> e.g. \"USD\"; <a href=\"https://en.wikipedia.org/wiki/List_of_cryptocurrencies\">Ticker symbol</a> for cryptocurrencies e.g. \"BTC\"; well known names for <a href=\"https://en.wikipedia.org/wiki/Local_exchange_trading_system\">Local Exchange Tradings Systems</a> (LETS) and other currency types e.g. \"Ithaca HOUR\".'),
(281, 1, 5, 'legislationTransposes', 'legislationTransposes', 'Indicates that this legislation (or part of legislation) fulfills the objectives set by another legislation, by passing appropriate implementation measures. Typically, some legislations of European Union\'s member states or regions transpose European Directives. This indicates a legally binding link between the 2 legislations.'),
(282, 1, 5, 'url', 'url', 'URL of the item.'),
(283, 1, 5, 'alignmentType', 'alignmentType', 'A category of alignment between the learning resource and the framework node. Recommended values include: \'requires\', \'textComplexity\', \'readingLevel\', and \'educationalSubject\'.'),
(284, 1, 5, 'maximumVirtualAttendeeCapacity', 'maximumVirtualAttendeeCapacity', 'The maximum physical attendee capacity of an <a class=\"localLink\" href=\"http://schema.org/Event\">Event</a> whose <a class=\"localLink\" href=\"http://schema.org/eventAttendanceMode\">eventAttendanceMode</a> is <a class=\"localLink\" href=\"http://schema.org/OnlineEventAttendanceMode\">OnlineEventAttendanceMode</a> (or the online aspects, in the case of a <a class=\"localLink\" href=\"http://schema.org/MixedEventAttendanceMode\">MixedEventAttendanceMode</a>).'),
(285, 1, 5, 'provider', 'provider', 'The service provider, service operator, or service performer; the goods producer. Another party (a seller) may offer those services or goods on behalf of the provider. A provider may also serve as the seller.'),
(286, 1, 5, 'foundingLocation', 'foundingLocation', 'The place where the Organization was founded.'),
(287, 1, 5, 'requiredMaxAge', 'requiredMaxAge', 'Audiences defined by a person\'s maximum age.'),
(288, 1, 5, 'publicTransportClosuresInfo', 'publicTransportClosuresInfo', 'Information about public transport closures.'),
(289, 1, 5, 'insertion', 'insertion', 'The place of attachment of a muscle, or what the muscle moves.'),
(290, 1, 5, 'countriesNotSupported', 'countriesNotSupported', 'Countries for which the application is not supported. You can also provide the two-letter ISO 3166-1 alpha-2 country code.'),
(291, 1, 5, 'legalStatus', 'legalStatus', 'The drug or supplement\'s legal status, including any controlled substance schedules that apply.'),
(292, 1, 5, 'parentService', 'parentService', 'A broadcast service to which the broadcast service may belong to such as regional variations of a national channel.'),
(293, 1, 5, 'monthlyMinimumRepaymentAmount', 'monthlyMinimumRepaymentAmount', 'The minimum payment is the lowest amount of money that one is required to pay on a credit card statement each month.'),
(294, 1, 5, 'manufacturer', 'manufacturer', 'The manufacturer of the product.'),
(295, 1, 5, 'winner', 'winner', 'A sub property of participant. The winner of the action.'),
(296, 1, 5, 'gtin13', 'gtin13', 'The GTIN-13 code of the product, or the product to which the offer refers. This is equivalent to 13-digit ISBN codes and EAN UCC-13. Former 12-digit UPC codes can be converted into a GTIN-13 code by simply adding a preceeding zero. See <a href=\"http://www.gs1.org/barcodes/technical/idkeys/gtin\">GS1 GTIN Summary</a> for more details.'),
(297, 1, 5, 'partOfOrder', 'partOfOrder', 'The overall order the items in this delivery were included in.'),
(298, 1, 5, 'reservedTicket', 'reservedTicket', 'A ticket associated with the reservation.'),
(299, 1, 5, 'inverseOf', 'inverseOf', 'Relates a property to a property that is its inverse. Inverse properties relate the same pairs of items to each other, but in reversed direction. For example, the \'alumni\' and \'alumniOf\' properties are inverseOf each other. Some properties don\'t have explicit inverses; in these situations RDFa and JSON-LD syntax for reverse properties can be used.'),
(300, 1, 5, 'numTracks', 'numTracks', 'The number of tracks in this album or playlist.'),
(301, 1, 5, 'readonlyValue', 'readonlyValue', 'Whether or not a property is mutable. Default is false. Specifying this for a property that also has a value makes it act similar to a \"hidden\" input in an HTML form.'),
(302, 1, 5, 'runsTo', 'runsTo', 'The vasculature the lymphatic structure runs, or efferents, to.'),
(303, 1, 5, 'subOrganization', 'subOrganization', 'A relationship between two organizations where the first includes the second, e.g., as a subsidiary. See also: the more specific \'department\' property.'),
(304, 1, 5, 'emissionsCO2', 'emissionsCO2', 'The CO2 emissions in g/km. When used in combination with a QuantitativeValue, put \"g/km\" into the unitText property of that value, since there is no UN/CEFACT Common Code for \"g/km\".'),
(305, 1, 5, 'permittedUsage', 'permittedUsage', 'Indications regarding the permitted usage of the accommodation.'),
(306, 1, 5, 'sdLicense', 'sdLicense', 'A license document that applies to this structured data, typically indicated by URL.'),
(307, 1, 5, 'hasCategoryCode', 'hasCategoryCode', 'A Category code contained in this code set.'),
(308, 1, 5, 'employmentType', 'employmentType', 'Type of employment (e.g. full-time, part-time, contract, temporary, seasonal, internship).'),
(309, 1, 5, 'carbohydrateContent', 'carbohydrateContent', 'The number of grams of carbohydrates.'),
(310, 1, 5, 'geoContains', 'geoContains', 'Represents a relationship between two geometries (or the places they represent), relating a containing geometry to a contained geometry. \"a contains b iff no points of b lie in the exterior of a, and at least one point of the interior of b lies in the interior of a\". As defined in <a href=\"https://en.wikipedia.org/wiki/DE-9IM\">DE-9IM</a>.'),
(311, 1, 5, 'nonprofitStatus', 'nonprofitStatus', 'nonprofit Status indicates the legal status of a non-profit organization in its primary place of business.'),
(312, 1, 5, 'reservationFor', 'reservationFor', 'The thing -- flight, event, restaurant,etc. being reserved.'),
(313, 1, 5, 'pageStart', 'pageStart', 'The page on which the work starts; for example \"135\" or \"xiii\".'),
(314, 1, 5, 'bed', 'bed', 'The type of bed or beds included in the accommodation. For the single case of just one bed of a certain type, you use bed directly with a text.\n If you want to indicate the quantity of a certain kind of bed, use an instance of BedDetails. For more detailed information, use the amenityFeature property.'),
(315, 1, 5, 'engineType', 'engineType', 'The type of engine or engines powering the vehicle.'),
(316, 1, 5, 'isbn', 'isbn', 'The ISBN of the book.'),
(317, 1, 5, 'hospitalAffiliation', 'hospitalAffiliation', 'A hospital with which the physician or office is affiliated.'),
(318, 1, 5, 'productionDate', 'productionDate', 'The date of production of the item, e.g. vehicle.'),
(319, 1, 5, 'albumReleaseType', 'albumReleaseType', 'The kind of release which this album is: single, EP or album.'),
(320, 1, 5, 'includedComposition', 'includedComposition', 'Smaller compositions included in this work (e.g. a movement in a symphony).'),
(321, 1, 5, 'valueMaxLength', 'valueMaxLength', 'Specifies the allowed range for number of characters in a literal value.'),
(322, 1, 5, 'costCurrency', 'costCurrency', 'The currency (in 3-letter of the drug cost. See: http://en.wikipedia.org/wiki/ISO_4217'),
(323, 1, 5, 'partOfTrip', 'partOfTrip', 'Identifies that this <a class=\"localLink\" href=\"http://schema.org/Trip\">Trip</a> is a subTrip of another Trip. For example Day 1, Day 2, etc. of a multi-day trip.'),
(324, 1, 5, 'safetyConsideration', 'safetyConsideration', 'Any potential safety concern associated with the supplement. May include interactions with other drugs and foods, pregnancy, breastfeeding, known adverse reactions, and documented efficacy of the supplement.'),
(325, 1, 5, 'structuralClass', 'structuralClass', 'The name given to how bone physically connects to each other.'),
(326, 1, 5, 'priceComponent', 'priceComponent', 'This property links to all <a class=\"localLink\" href=\"http://schema.org/UnitPriceSpecification\">UnitPriceSpecification</a> nodes that apply in parallel for the <a class=\"localLink\" href=\"http://schema.org/CompoundPriceSpecification\">CompoundPriceSpecification</a> node.'),
(327, 1, 5, 'numberOfBathroomsTotal', 'numberOfBathroomsTotal', 'The total integer number of bathrooms in a some <a class=\"localLink\" href=\"http://schema.org/Accommodation\">Accommodation</a>, following real estate conventions as <a href=\"https://ddwiki.reso.org/display/DDW17/BathroomsTotalInteger+Field\">documented in RESO</a>: \"The simple sum of the number of bathrooms. For example for a property with two Full Bathrooms and one Half Bathroom, the Bathrooms Total Integer will be 3.\". See also <a class=\"localLink\" href=\"http://schema.org/numberOfRooms\">numberOfRooms</a>.'),
(328, 1, 5, 'numberOfPlayers', 'numberOfPlayers', 'Indicate how many people can play this game (minimum, maximum, or range).'),
(329, 1, 5, 'educationalUse', 'educationalUse', 'The purpose of a work in the context of education; for example, \'assignment\', \'group work\'.'),
(330, 1, 5, 'interestRate', 'interestRate', 'The interest rate, charged or paid, applicable to the financial product. Note: This is different from the calculated annualPercentageRate.'),
(331, 1, 5, 'requiredQuantity', 'requiredQuantity', 'The required quantity of the item(s).'),
(332, 1, 5, 'cvdNumC19OFMechVentPats', 'cvdNumC19OFMechVentPats', 'numc19ofmechventpats - ED/OVERFLOW and VENTILATED: Patients with suspected or confirmed COVID-19 who are in the ED or any overflow location awaiting an inpatient bed and on a mechanical ventilator.'),
(333, 1, 5, 'events', 'events', 'Upcoming or past events associated with this place or organization.'),
(334, 1, 5, 'realEstateAgent', 'realEstateAgent', 'A sub property of participant. The real estate agent involved in the action.'),
(335, 1, 5, 'torque', 'torque', 'The torque (turning force) of the vehicle\'s engine.<br/><br/>\n\nTypical unit code(s): NU for newton metre (N m), F17 for pound-force per foot, or F48 for pound-force per inch<br/><br/>\n\n<ul>\n<li>Note 1: You can link to information about how the given value has been determined (e.g. reference RPM) using the <a class=\"localLink\" href=\"http://schema.org/valueReference\">valueReference</a> property.</li>\n<li>Note 2: You can use <a class=\"localLink\" href=\"http://schema.org/minValue\">minValue</a> and <a class=\"localLink\" href=\"http://schema.org/maxValue\">maxValue</a> to indicate ranges.</li>\n</ul>\n'),
(336, 1, 5, 'dateReceived', 'dateReceived', 'The date/time the message was received if a single recipient exists.'),
(337, 1, 5, 'alternativeHeadline', 'alternativeHeadline', 'A secondary title of the CreativeWork.'),
(338, 1, 5, 'significance', 'significance', 'The significance associated with the superficial anatomy; as an example, how characteristics of the superficial anatomy can suggest underlying medical conditions or courses of treatment.'),
(339, 1, 5, 'supplyTo', 'supplyTo', 'The area to which the artery supplies blood.'),
(340, 1, 5, 'affectedBy', 'affectedBy', 'Drugs that affect the test\'s results.'),
(341, 1, 5, 'arrivalBusStop', 'arrivalBusStop', 'The stop or station from which the bus arrives.'),
(342, 1, 5, 'quarantineGuidelines', 'quarantineGuidelines', 'Guidelines about quarantine rules, e.g. in the context of a pandemic.'),
(343, 1, 5, 'maxPrice', 'maxPrice', 'The highest price if the price is a range.'),
(344, 1, 5, 'clincalPharmacology', 'clincalPharmacology', 'Description of the absorption and elimination of drugs, including their concentration (pharmacokinetics, pK) and biological effects (pharmacodynamics, pD).'),
(345, 1, 5, 'albumProductionType', 'albumProductionType', 'Classification of the album by it\'s type of content: soundtrack, live album, studio album, etc.'),
(346, 1, 5, 'episodeNumber', 'episodeNumber', 'Position of the episode within an ordered group of episodes.'),
(347, 1, 5, 'exchangeRateSpread', 'exchangeRateSpread', 'The difference between the price at which a broker or other intermediary buys and sells foreign currency.'),
(348, 1, 5, 'hasPart', 'hasPart', 'Indicates an item or CreativeWork that is part of this item, or CreativeWork (in some sense).'),
(349, 1, 5, 'busNumber', 'busNumber', 'The unique identifier for the bus.'),
(350, 1, 5, 'inAlbum', 'inAlbum', 'The album to which this recording belongs.'),
(351, 1, 5, 'availableStrength', 'availableStrength', 'An available dosage strength for the drug.'),
(352, 1, 5, 'candidate', 'candidate', 'A sub property of object. The candidate subject of this action.'),
(353, 1, 5, 'permissions', 'permissions', 'Permission(s) required to run the app (for example, a mobile app may require full internet access or may run only on wifi).'),
(354, 1, 5, 'stageAsNumber', 'stageAsNumber', 'The stage represented as a number, e.g. 3.'),
(355, 1, 5, 'transitTime', 'transitTime', 'The typical delay the order has been sent for delivery and the goods reach the final customer. Typical properties: minValue, maxValue, unitCode (d for DAY).'),
(356, 1, 5, 'referenceQuantity', 'referenceQuantity', 'The reference quantity for which a certain price applies, e.g. 1 EUR per 4 kWh of electricity. This property is a replacement for unitOfMeasurement for the advanced cases where the price does not relate to a standard unit.'),
(357, 1, 5, 'returnFees', 'returnFees', 'Indicates (via enumerated options) the return fees policy for a MerchantReturnPolicy'),
(358, 1, 5, 'subEvent', 'subEvent', 'An Event that is part of this event. For example, a conference event includes many presentations, each of which is a subEvent of the conference.'),
(359, 1, 5, 'exampleOfWork', 'exampleOfWork', 'A creative work that this work is an example/instance/realization/derivation of.'),
(360, 1, 5, 'vehicleSpecialUsage', 'vehicleSpecialUsage', 'Indicates whether the vehicle has been used for special purposes, like commercial rental, driving school, or as a taxi. The legislation in many countries requires this information to be revealed when offering a car for sale.'),
(361, 1, 5, 'sport', 'sport', 'A type of sport (e.g. Baseball).'),
(362, 1, 5, 'upvoteCount', 'upvoteCount', 'The number of upvotes this question, answer or comment has received from the community.'),
(363, 1, 5, 'hasMap', 'hasMap', 'A URL to a map of the place.'),
(364, 1, 5, 'sodiumContent', 'sodiumContent', 'The number of milligrams of sodium.'),
(365, 1, 5, 'audienceType', 'audienceType', 'The target group associated with a given audience (e.g. veterans, car owners, musicians, etc.).'),
(366, 1, 5, 'activityDuration', 'activityDuration', 'Length of time to engage in the activity.'),
(367, 1, 5, 'serviceOperator', 'serviceOperator', 'The operating organization, if different from the provider. This enables the representation of services that are provided by an organization, but operated by another organization like a subcontractor.'),
(368, 1, 5, 'geoWithin', 'geoWithin', 'Represents a relationship between two geometries (or the places they represent), relating a geometry to one that contains it, i.e. it is inside (i.e. within) its interior. As defined in <a href=\"https://en.wikipedia.org/wiki/DE-9IM\">DE-9IM</a>.');
INSERT INTO `property` (`id`, `owner_id`, `vocabulary_id`, `local_name`, `label`, `comment`) VALUES
(369, 1, 5, 'rsvpResponse', 'rsvpResponse', 'The response (yes, no, maybe) to the RSVP.'),
(370, 1, 5, 'knowsAbout', 'knowsAbout', 'Of a <a class=\"localLink\" href=\"http://schema.org/Person\">Person</a>, and less typically of an <a class=\"localLink\" href=\"http://schema.org/Organization\">Organization</a>, to indicate a topic that is known about - suggesting possible expertise but not implying it. We do not distinguish skill levels here, or relate this to educational content, events, objectives or <a class=\"localLink\" href=\"http://schema.org/JobPosting\">JobPosting</a> descriptions.'),
(371, 1, 5, 'estimatesRiskOf', 'estimatesRiskOf', 'The condition, complication, or symptom whose risk is being estimated.'),
(372, 1, 5, 'deathPlace', 'deathPlace', 'The place where the person died.'),
(373, 1, 5, 'includesAttraction', 'includesAttraction', 'Attraction located at destination.'),
(374, 1, 5, 'typeOfBed', 'typeOfBed', 'The type of bed to which the BedDetail refers, i.e. the type of bed available in the quantity indicated by quantity.'),
(375, 1, 5, 'arrivalStation', 'arrivalStation', 'The station where the train trip ends.'),
(376, 1, 5, 'webFeed', 'webFeed', 'The URL for a feed, e.g. associated with a podcast series, blog, or series of date-stamped updates. This is usually RSS or Atom.'),
(377, 1, 5, 'itemListOrder', 'itemListOrder', 'Type of ordering (e.g. Ascending, Descending, Unordered).'),
(378, 1, 5, 'installUrl', 'installUrl', 'URL at which the app may be installed, if different from the URL of the item.'),
(379, 1, 5, 'sensoryRequirement', 'sensoryRequirement', 'A description of any sensory requirements and levels necessary to function on the job, including hearing and vision. Defined terms such as those in O*net may be used, but note that there is no way to specify the level of ability as well as its nature when using a defined term.'),
(380, 1, 5, 'amount', 'amount', 'The amount of money.'),
(381, 1, 5, 'accessibilityFeature', 'accessibilityFeature', 'Content features of the resource, such as accessible media, alternatives and supported enhancements for accessibility (<a href=\"http://www.w3.org/wiki/WebSchemas/Accessibility\">WebSchemas wiki lists possible values</a>).'),
(382, 1, 5, 'validUntil', 'validUntil', 'The date when the item is no longer valid.'),
(383, 1, 5, 'broadcastOfEvent', 'broadcastOfEvent', 'The event being broadcast such as a sporting event or awards ceremony.'),
(384, 1, 5, 'datasetTimeInterval', 'datasetTimeInterval', 'The range of temporal applicability of a dataset, e.g. for a 2011 census dataset, the year 2011 (in ISO 8601 time interval format).'),
(385, 1, 5, 'subtitleLanguage', 'subtitleLanguage', 'Languages in which subtitles/captions are available, in <a href=\"http://tools.ietf.org/html/bcp47\">IETF BCP 47 standard format</a>.'),
(386, 1, 5, 'serviceType', 'serviceType', 'The type of service being offered, e.g. veterans\' benefits, emergency relief, etc.'),
(387, 1, 5, 'activityFrequency', 'activityFrequency', 'How often one should engage in the activity.'),
(388, 1, 5, 'ratingExplanation', 'ratingExplanation', 'A short explanation (e.g. one to two sentences) providing background context and other information that led to the conclusion expressed in the rating. This is particularly applicable to ratings associated with \"fact check\" markup using <a class=\"localLink\" href=\"http://schema.org/ClaimReview\">ClaimReview</a>.'),
(389, 1, 5, 'subStructure', 'subStructure', 'Component (sub-)structure(s) that comprise this anatomical structure.'),
(390, 1, 5, 'map', 'map', 'A URL to a map of the place.'),
(391, 1, 5, 'smokingAllowed', 'smokingAllowed', 'Indicates whether it is allowed to smoke in the place, e.g. in the restaurant, hotel or hotel room.'),
(392, 1, 5, 'driveWheelConfiguration', 'driveWheelConfiguration', 'The drive wheel configuration, i.e. which roadwheels will receive torque from the vehicle\'s engine via the drivetrain.'),
(393, 1, 5, 'multipleValues', 'multipleValues', 'Whether multiple values are allowed for the property. Default is false.'),
(394, 1, 5, 'addressRegion', 'addressRegion', 'The region in which the locality is, and which is in the country. For example, California or another appropriate first-level <a href=\"https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country\">Administrative division</a>'),
(395, 1, 5, 'drugClass', 'drugClass', 'The class of drug this belongs to (e.g., statins).'),
(396, 1, 5, 'additionalName', 'additionalName', 'An additional name for a Person, can be used for a middle name.'),
(397, 1, 5, 'executableLibraryName', 'executableLibraryName', 'Library file name e.g., mscorlib.dll, system.web.dll.'),
(398, 1, 5, 'numberOfFullBathrooms', 'numberOfFullBathrooms', 'Number of full bathrooms - The total number of full and ¾ bathrooms in an <a class=\"localLink\" href=\"http://schema.org/Accommodation\">Accommodation</a>. This corresponds to the <a href=\"https://ddwiki.reso.org/display/DDW17/BathroomsFull+Field\">BathroomsFull field in RESO</a>.'),
(399, 1, 5, 'legislationLegalValue', 'legislationLegalValue', 'The legal value of this legislation file. The same legislation can be written in multiple files with different legal values. Typically a digitally signed PDF have a \"stronger\" legal value than the HTML file of the same act.'),
(400, 1, 5, 'contentUrl', 'contentUrl', 'Actual bytes of the media object, for example the image file or video file.'),
(401, 1, 5, 'sourcedFrom', 'sourcedFrom', 'The neurological pathway that originates the neurons.'),
(402, 1, 5, 'passengerSequenceNumber', 'passengerSequenceNumber', 'The passenger\'s sequence number as assigned by the airline.'),
(403, 1, 5, 'shippingRate', 'shippingRate', 'The shipping rate is the cost of shipping to the specified destination. Typically, the maxValue and currency values (of the <a class=\"localLink\" href=\"http://schema.org/MonetaryAmount\">MonetaryAmount</a>) are most appropriate.'),
(404, 1, 5, 'isBasedOnUrl', 'isBasedOnUrl', 'A resource that was used in the creation of this resource. This term can be repeated for multiple sources. For example, http://example.com/great-multiplication-intro.html.'),
(405, 1, 5, 'appearance', 'appearance', 'Indicates an occurence of a <a class=\"localLink\" href=\"http://schema.org/Claim\">Claim</a> in some <a class=\"localLink\" href=\"http://schema.org/CreativeWork\">CreativeWork</a>.'),
(406, 1, 5, 'specialty', 'specialty', 'One of the domain specialities to which this web page\'s content applies.'),
(407, 1, 5, 'transcript', 'transcript', 'If this MediaObject is an AudioObject or VideoObject, the transcript of that object.'),
(408, 1, 5, 'increasesRiskOf', 'increasesRiskOf', 'The condition, complication, etc. influenced by this factor.'),
(409, 1, 5, 'expertConsiderations', 'expertConsiderations', 'Medical expert advice related to the plan.'),
(410, 1, 5, 'titleEIDR', 'titleEIDR', 'An <a href=\"https://eidr.org/\">EIDR</a> (Entertainment Identifier Registry) <a class=\"localLink\" href=\"http://schema.org/identifier\">identifier</a> representing at the most general/abstract level, a work of film or television.<br/><br/>\n\nFor example, the motion picture known as \"Ghostbusters\" has a titleEIDR of \"10.5240/7EC7-228A-510A-053E-CBB8-J\". This title (or work) may have several variants, which EIDR calls \"edits\". See <a class=\"localLink\" href=\"http://schema.org/editEIDR\">editEIDR</a>.<br/><br/>\n\nSince schema.org types like <a class=\"localLink\" href=\"http://schema.org/Movie\">Movie</a> and <a class=\"localLink\" href=\"http://schema.org/TVEpisode\">TVEpisode</a> can be used for both works and their multiple expressions, it is possible to use <a class=\"localLink\" href=\"http://schema.org/titleEIDR\">titleEIDR</a> alone (for a general description), or alongside <a class=\"localLink\" href=\"http://schema.org/editEIDR\">editEIDR</a> for a more edit-specific description.'),
(411, 1, 5, 'resultComment', 'resultComment', 'A sub property of result. The Comment created or sent as a result of this action.'),
(412, 1, 5, 'hasMerchantReturnPolicy', 'hasMerchantReturnPolicy', 'Indicates a MerchantReturnPolicy that may be applicable.'),
(413, 1, 5, 'dateSent', 'dateSent', 'The date/time at which the message was sent.'),
(414, 1, 5, 'numberOfAirbags', 'numberOfAirbags', 'The number or type of airbags in the vehicle.'),
(415, 1, 5, 'spatialCoverage', 'spatialCoverage', 'The spatialCoverage of a CreativeWork indicates the place(s) which are the focus of the content. It is a subproperty of\n contentLocation intended primarily for more technical and detailed materials. For example with a Dataset, it indicates\n areas that the dataset describes: a dataset of New York weather would have spatialCoverage which was the place: the state of New York.'),
(416, 1, 5, 'orderDate', 'orderDate', 'Date order was placed.'),
(417, 1, 5, 'fromLocation', 'fromLocation', 'A sub property of location. The original location of the object or the agent before the action.'),
(418, 1, 5, 'borrower', 'borrower', 'A sub property of participant. The person that borrows the object being lent.'),
(419, 1, 5, 'associatedPathophysiology', 'associatedPathophysiology', 'If applicable, a description of the pathophysiology associated with the anatomical system, including potential abnormal changes in the mechanical, physical, and biochemical functions of the system.'),
(420, 1, 5, 'cvdNumVent', 'cvdNumVent', 'numvent - MECHANICAL VENTILATORS: Total number of ventilators available.'),
(421, 1, 5, 'geo', 'geo', 'The geo coordinates of the place.'),
(422, 1, 5, 'guideline', 'guideline', 'A medical guideline related to this entity.'),
(423, 1, 5, 'prepTime', 'prepTime', 'The length of time it takes to prepare the items to be used in instructions or a direction, in <a href=\"http://en.wikipedia.org/wiki/ISO_8601\">ISO 8601 duration format</a>.'),
(424, 1, 5, 'suggestedMaxAge', 'suggestedMaxAge', 'Maximal age recommended for viewing content.'),
(425, 1, 5, 'nerveMotor', 'nerveMotor', 'The neurological pathway extension that involves muscle control.'),
(426, 1, 5, 'usesDevice', 'usesDevice', 'Device used to perform the test.'),
(427, 1, 5, 'educationalAlignment', 'educationalAlignment', 'An alignment to an established educational framework.<br/><br/>\n\nThis property should not be used where the nature of the alignment can be described using a simple property, for example to express that a resource <a class=\"localLink\" href=\"http://schema.org/teaches\">teaches</a> or <a class=\"localLink\" href=\"http://schema.org/assesses\">assesses</a> a competency.'),
(428, 1, 5, 'operatingSystem', 'operatingSystem', 'Operating systems supported (Windows 7, OSX 10.6, Android 1.6).'),
(429, 1, 5, 'publisherImprint', 'publisherImprint', 'The publishing division which published the comic.'),
(430, 1, 5, 'billingAddress', 'billingAddress', 'The billing address for the order.'),
(431, 1, 5, 'riskFactor', 'riskFactor', 'A modifiable or non-modifiable factor that increases the risk of a patient contracting this condition, e.g. age, coexisting condition.'),
(432, 1, 5, 'pageEnd', 'pageEnd', 'The page on which the work ends; for example \"138\" or \"xvi\".'),
(433, 1, 5, 'trailerWeight', 'trailerWeight', 'The permitted weight of a trailer attached to the vehicle.<br/><br/>\n\nTypical unit code(s): KGM for kilogram, LBR for pound\n* Note 1: You can indicate additional information in the <a class=\"localLink\" href=\"http://schema.org/name\">name</a> of the <a class=\"localLink\" href=\"http://schema.org/QuantitativeValue\">QuantitativeValue</a> node.\n* Note 2: You may also link to a <a class=\"localLink\" href=\"http://schema.org/QualitativeValue\">QualitativeValue</a> node that provides additional information using <a class=\"localLink\" href=\"http://schema.org/valueReference\">valueReference</a>.\n* Note 3: Note that you can use <a class=\"localLink\" href=\"http://schema.org/minValue\">minValue</a> and <a class=\"localLink\" href=\"http://schema.org/maxValue\">maxValue</a> to indicate ranges.'),
(434, 1, 5, 'includesHealthPlanNetwork', 'includesHealthPlanNetwork', 'Networks covered by this plan.'),
(435, 1, 5, 'affiliation', 'affiliation', 'An organization that this person is affiliated with. For example, a school/university, a club, or a team.'),
(436, 1, 5, 'articleSection', 'articleSection', 'Articles may belong to one or more \'sections\' in a magazine or newspaper, such as Sports, Lifestyle, etc.'),
(437, 1, 5, 'costOrigin', 'costOrigin', 'Additional details to capture the origin of the cost data. For example, \'Medicare Part B\'.'),
(438, 1, 5, 'relatedStructure', 'relatedStructure', 'Related anatomical structure(s) that are not part of the system but relate or connect to it, such as vascular bundles associated with an organ system.'),
(439, 1, 5, 'gettingTestedInfo', 'gettingTestedInfo', 'Information about getting tested (for a <a class=\"localLink\" href=\"http://schema.org/MedicalCondition\">MedicalCondition</a>), e.g. in the context of a pandemic.'),
(440, 1, 5, 'actionOption', 'actionOption', 'A sub property of object. The options subject to this action.'),
(441, 1, 5, 'regionDrained', 'regionDrained', 'The anatomical or organ system drained by this vessel; generally refers to a specific part of an organ.'),
(442, 1, 5, 'familyName', 'familyName', 'Family name. In the U.S., the last name of an Person. This can be used along with givenName instead of the name property.'),
(443, 1, 5, 'review', 'review', 'A review of the item.'),
(444, 1, 5, 'includesObject', 'includesObject', 'This links to a node or nodes indicating the exact quantity of the products included in an <a class=\"localLink\" href=\"http://schema.org/Offer\">Offer</a> or <a class=\"localLink\" href=\"http://schema.org/ProductCollection\">ProductCollection</a>.'),
(445, 1, 5, 'accessibilityHazard', 'accessibilityHazard', 'A characteristic of the described resource that is physiologically dangerous to some users. Related to WCAG 2.0 guideline 2.3 (<a href=\"http://www.w3.org/wiki/WebSchemas/Accessibility\">WebSchemas wiki lists possible values</a>).'),
(446, 1, 5, 'mediaAuthenticityCategory', 'mediaAuthenticityCategory', 'Indicates a MediaManipulationRatingEnumeration classification of a media object (in the context of how it was published or shared).'),
(447, 1, 5, 'scheduleTimezone', 'scheduleTimezone', 'Indicates the timezone for which the time(s) indicated in the <a class=\"localLink\" href=\"http://schema.org/Schedule\">Schedule</a> are given. The value provided should be among those listed in the IANA Time Zone Database.'),
(448, 1, 5, 'status', 'status', 'The status of the study (enumerated).'),
(449, 1, 5, 'acceptsReservations', 'acceptsReservations', 'Indicates whether a FoodEstablishment accepts reservations. Values can be Boolean, an URL at which reservations can be made or (for backwards compatibility) the strings <code>Yes</code> or <code>No</code>.'),
(450, 1, 5, 'parentOrganization', 'parentOrganization', 'The larger organization that this organization is a <a class=\"localLink\" href=\"http://schema.org/subOrganization\">subOrganization</a> of, if any.'),
(451, 1, 5, 'address', 'address', 'Physical address of the item.'),
(452, 1, 5, 'timeRequired', 'timeRequired', 'Approximate or typical time it takes to work with or through this learning resource for the typical intended target audience, e.g. \'PT30M\', \'PT1H25M\'.'),
(453, 1, 5, 'seasonNumber', 'seasonNumber', 'Position of the season within an ordered group of seasons.'),
(454, 1, 5, 'numAdults', 'numAdults', 'The number of adults staying in the unit.'),
(455, 1, 5, 'possibleComplication', 'possibleComplication', 'A possible unexpected and unfavorable evolution of a medical condition. Complications may include worsening of the signs or symptoms of the disease, extension of the condition to other organ systems, etc.'),
(456, 1, 5, 'publication', 'publication', 'A publication event associated with the item.'),
(457, 1, 5, 'makesOffer', 'makesOffer', 'A pointer to products or services offered by the organization or person.'),
(458, 1, 5, 'infectiousAgentClass', 'infectiousAgentClass', 'The class of infectious agent (bacteria, prion, etc.) that causes the disease.'),
(459, 1, 5, 'specialOpeningHoursSpecification', 'specialOpeningHoursSpecification', 'The special opening hours of a certain place.<br/><br/>\n\nUse this to explicitly override general opening hours brought in scope by <a class=\"localLink\" href=\"http://schema.org/openingHoursSpecification\">openingHoursSpecification</a> or <a class=\"localLink\" href=\"http://schema.org/openingHours\">openingHours</a>.'),
(460, 1, 5, 'yearsInOperation', 'yearsInOperation', 'The age of the business.'),
(461, 1, 5, 'additionalNumberOfGuests', 'additionalNumberOfGuests', 'If responding yes, the number of guests who will attend in addition to the invitee.'),
(462, 1, 5, 'infectiousAgent', 'infectiousAgent', 'The actual infectious agent, such as a specific bacterium.'),
(463, 1, 5, 'cashBack', 'cashBack', 'A cardholder benefit that pays the cardholder a small percentage of their net expenditures.'),
(464, 1, 5, 'isAcceptingNewPatients', 'isAcceptingNewPatients', 'Whether the provider is accepting new patients.'),
(465, 1, 5, 'comment', 'comment', 'Comments, typically from users.'),
(466, 1, 5, 'termsPerYear', 'termsPerYear', 'The number of times terms of study are offered per year. Semesters and quarters are common units for term. For example, if the student can only take 2 semesters for the program in one year, then termsPerYear should be 2.'),
(467, 1, 5, 'parent', 'parent', 'A parent of this person.'),
(468, 1, 5, 'recipeYield', 'recipeYield', 'The quantity produced by the recipe (for example, number of people served, number of servings, etc).'),
(469, 1, 5, 'callSign', 'callSign', 'A <a href=\"https://en.wikipedia.org/wiki/Call_sign\">callsign</a>, as used in broadcasting and radio communications to identify people, radio and TV stations, or vehicles.'),
(470, 1, 5, 'eligibleRegion', 'eligibleRegion', 'The ISO 3166-1 (ISO 3166-1 alpha-2) or ISO 3166-2 code, the place, or the GeoShape for the geo-political region(s) for which the offer or delivery charge specification is valid.<br/><br/>\n\nSee also <a class=\"localLink\" href=\"http://schema.org/ineligibleRegion\">ineligibleRegion</a>.'),
(471, 1, 5, 'procedure', 'procedure', 'A description of the procedure involved in setting up, using, and/or installing the device.'),
(472, 1, 5, 'member', 'member', 'A member of an Organization or a ProgramMembership. Organizations can be members of organizations; ProgramMembership is typically for individuals.'),
(473, 1, 5, 'broadcastDisplayName', 'broadcastDisplayName', 'The name displayed in the channel guide. For many US affiliates, it is the network name.'),
(474, 1, 5, 'howPerformed', 'howPerformed', 'How the procedure is performed.'),
(475, 1, 5, 'item', 'item', 'An entity represented by an entry in a list or data feed (e.g. an \'artist\' in a list of \'artists\')’.'),
(476, 1, 5, 'recipeIngredient', 'recipeIngredient', 'A single ingredient used in the recipe, e.g. sugar, flour or garlic.'),
(477, 1, 5, 'performerIn', 'performerIn', 'Event that this person is a performer or participant in.'),
(478, 1, 5, 'lyrics', 'lyrics', 'The words in the song.'),
(479, 1, 5, 'steeringPosition', 'steeringPosition', 'The position of the steering wheel or similar device (mostly for cars).'),
(480, 1, 5, 'advanceBookingRequirement', 'advanceBookingRequirement', 'The amount of time that is required between accepting the offer and the actual usage of the resource or service.'),
(481, 1, 5, 'branchOf', 'branchOf', 'The larger organization that this local business is a branch of, if any. Not to be confused with (anatomical)<a class=\"localLink\" href=\"http://schema.org/branch\">branch</a>.'),
(482, 1, 5, 'beneficiaryBank', 'beneficiaryBank', 'A bank or bank’s branch, financial institution or international financial institution operating the beneficiary’s bank account or releasing funds for the beneficiary'),
(483, 1, 5, 'knowsLanguage', 'knowsLanguage', 'Of a <a class=\"localLink\" href=\"http://schema.org/Person\">Person</a>, and less typically of an <a class=\"localLink\" href=\"http://schema.org/Organization\">Organization</a>, to indicate a known language. We do not distinguish skill levels or reading/writing/speaking/signing here. Use language codes from the <a href=\"http://tools.ietf.org/html/bcp47\">IETF BCP 47 standard</a>.'),
(484, 1, 5, 'applicableLocation', 'applicableLocation', 'The location in which the status applies.'),
(485, 1, 5, 'repeatFrequency', 'repeatFrequency', 'Defines the frequency at which <a class=\"localLink\" href=\"http://schema.org/Events\">Events</a> will occur according to a schedule <a class=\"localLink\" href=\"http://schema.org/Schedule\">Schedule</a>. The intervals between\n events should be defined as a <a class=\"localLink\" href=\"http://schema.org/Duration\">Duration</a> of time.'),
(486, 1, 5, 'containedIn', 'containedIn', 'The basic containment relation between a place and one that contains it.'),
(487, 1, 5, 'inLanguage', 'inLanguage', 'The language of the content or performance or used in an action. Please use one of the language codes from the <a href=\"http://tools.ietf.org/html/bcp47\">IETF BCP 47 standard</a>. See also <a class=\"localLink\" href=\"http://schema.org/availableLanguage\">availableLanguage</a>.'),
(488, 1, 5, 'menuAddOn', 'menuAddOn', 'Additional menu item(s) such as a side dish of salad or side order of fries that can be added to this menu item. Additionally it can be a menu section containing allowed add-on menu items for this menu item.'),
(489, 1, 5, 'healthPlanCoinsuranceRate', 'healthPlanCoinsuranceRate', 'Whether The rate of coinsurance expressed as a number between 0.0 and 1.0.'),
(490, 1, 5, 'broadcastServiceTier', 'broadcastServiceTier', 'The type of service required to have access to the channel (e.g. Standard or Premium).'),
(491, 1, 5, 'isConsumableFor', 'isConsumableFor', 'A pointer to another product (or multiple products) for which this product is a consumable.'),
(492, 1, 5, 'softwareRequirements', 'softwareRequirements', 'Component dependency requirements for application. This includes runtime environments and shared libraries that are not included in the application distribution package, but required to run the application (Examples: DirectX, Java or .NET runtime).'),
(493, 1, 5, 'postalCodeBegin', 'postalCodeBegin', 'First postal code in a range (included).'),
(494, 1, 5, 'deliveryStatus', 'deliveryStatus', 'New entry added as the package passes through each leg of its journey (from shipment to final delivery).'),
(495, 1, 5, 'legislationType', 'legislationType', 'The type of the legislation. Examples of values are \"law\", \"act\", \"directive\", \"decree\", \"regulation\", \"statutory instrument\", \"loi organique\", \"règlement grand-ducal\", etc., depending on the country.'),