[-] Alternative_Object_IDs

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (11 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDText Text tickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Object_IDAlpha Alpha 255Cluster B-treetickticktick
8. Alternative_IDText Text tickticktick
9. Alternative_ID_CategoryText Text tickticktick
10. Record_Owner_IDLongint Longint tickticktick
11. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Alternative_Object_IDs]Object_ID[Object_Management]Object_ID

[-] Authority

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (18 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDAlpha Alpha 255B-treetickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Authority_IDAlpha Alpha 255B-treetickticktick
8. Authority_Standard_NameText Text B-treetickticktick
9. Authority_Alt_NamesText Text tickticktick
10. Authority_DescriptionText Text tickticktick
11. Authority_DatesText Text tickticktick
12. Authority_CoordsText Text tickticktick
13. Authority_LinkText Text tickticktick
14. Digital_Object_NameText Text tickticktick
15. Resource_IDAlpha Alpha 255tickticktick
16. Authority_TypeAlpha Alpha 255tickticktick
17. Record_Owner_IDLongint Longint tickticktick
18. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Authority_Link]Authority_Standard_Name[Authority]Authority_Standard_Name

[-] Authority_Link

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (14 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDText Text B-treetickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Authority_IDAlpha Alpha 255Cluster B-treetickticktick
8. Object_IDAlpha Alpha 255Cluster B-treetickticktick
9. Authority_Name_As_AppearsText Text tickticktick
10. Authority_Name_RefText Text tickticktick
11. Authority_RoleText Text tickticktick
12. Authority_Standard_NameText Text Cluster B-treetickticktick
13. Record_Owner_IDLongint Longint tickticktick
14. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Authority_Link]Authority_Standard_Name[Authority]Authority_Standard_Name
[Authority_Link]Object_ID[Object_Management]Object_ID

[-] Collection_Management

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (16 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDText Text tickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Collection_IDAlpha Alpha 255B-treeticktickticktick
8. Institution_IDAlpha Alpha 255Cluster B-treetickticktick
9. Collection_TitleText Text tickticktick
10. Collection_DescriptionText Text tickticktick
11. Collection_Copyright_ShortText Text tickticktick
12. Collection_Copyright_LongText Text tickticktick
13. Collection_AccessText Text tickticktick
14. Resource_IDText Text tickticktick
15. Record_Owner_IDLongint Longint tickticktick
16. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Collection_Management]Institution_ID[Institutional_Management]Institution_ID
[Object_Management]Collection_ID[Collection_Management]Collection_ID

[-] Digital_Object_Management

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (37 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDAlpha Alpha 255B-treetickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Digital_Object_NameAlpha Alpha 255Cluster B-treetickticktick
8. Digital_Object_PathText Text tickticktick
9. Digital_Object_TypeText Text tickticktick
10. Object_IDAlpha Alpha 255Cluster B-treetickticktick
11. Digital_Source_TypeAlpha Alpha 255tickticktick
12. ExtentText Text tickticktick
13. ProcessText Text tickticktick
14. DetailBoolean Boolean tickticktick
15. RulerBoolean Boolean tickticktick
16. Colour_BarBoolean Boolean tickticktick
17. GreyscaleBoolean Boolean tickticktick
18. DigitiserAlpha Alpha 255tickticktick
19. Digitised_DateDate Date tickticktick
20. Digitised_CommentsText Text tickticktick
21. Ready_For_Post_ProcessingBoolean Boolean tickticktick
22. Post_ProcessedBoolean Boolean tickticktick
23. Post_ProcessorAlpha Alpha 255tickticktick
24. Post_Process_DateDate Date tickticktick
25. Post_Process_CommentsAlpha Alpha 255tickticktick
26. QABoolean Boolean tickticktick
27. QA_PersonAlpha Alpha 255tickticktick
28. QA_DateDate Date tickticktick
29. QA_CommentsText Text tickticktick
30. Digitised_ProjectText Text tickticktick
31. SponsoredBoolean Boolean tickticktick
32. Sponsor_TextText Text tickticktick
33. CaptionText Text tickticktick
34. CopyrightText Text tickticktick
35. KeywordsText Text Cluster B-treetickticktick
36. Record_Owner_IDLongint Longint tickticktick
37. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Digital_Object_Management]Object_ID[Object_Management]Object_ID
[Digital_Object_Management]Digital_Object_Name[Relationship_Link]Digital_Object_Name

[-] Institutional_Management

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (21 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDText Text B-treetickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Institution_IDAlpha Alpha 255B-treeticktickticktick
8. Institution_TitleText Text tickticktick
9. Institution_Short_DescriptionText Text tickticktick
10. Institution_HistoryText Text tickticktick
11. Institution_RoleText Text tickticktick
12. Institution_Copyright_ShortText Text tickticktick
13. Institution_Copyright_LongText Text tickticktick
14. Institution_AddressText Text tickticktick
15. Institution_URLText Text tickticktick
16. Institution_Contact_EmailText Text tickticktick
17. Institution_Map_LinkText Text tickticktick
18. Institution_CoordsText Text tickticktick
19. Resource_IDText Text tickticktick
20. Record_Owner_IDLongint Longint tickticktick
21. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Collection_Management]Institution_ID[Institutional_Management]Institution_ID
[People_Management]Institution_ID[Institutional_Management]Institution_ID

[-] Lookup_Fields

Triggers

On LoadOn Save New RecordOn DeleteOn Save

Table (5 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Table_NumberLongint Longint tickticktick
2. Field_NumberLongint Longint tickticktick
3. Lookup_Value_TypeAlpha Alpha 255tickticktick
4. Associated_Value_Field_NumberLongint Longint tickticktick
5. Filtered_by_Field_NumberLongint Longint tickticktick

Relations

FromTo

[-] Lookup_Values

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (28 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDText Text Autotickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Lookup_IDAlpha Alpha 255Autotickticktick
8. Lookup_Value_TypeAlpha Alpha 255tickticktick
9. Lookup_Standard_ValueAlpha Alpha 255Autotickticktick
10. Lookup_Value_DescriptionText Text Autotickticktick
11. Lookup_Value_EnglishAlpha Alpha 255tickticktick
12. Lookup_Value_FrenchAlpha Alpha 255tickticktick
13. Lookup_Value_GermanAlpha Alpha 255tickticktick
14. Lookup_Value_SpanishAlpha Alpha 255tickticktick
15. Lookup_Value_SwedishAlpha Alpha 255tickticktick
16. Lookup_Value_RussianAlpha Alpha 255tickticktick
17. Lookup_Value_TurkishAlpha Alpha 255tickticktick
18. Lookup_Value_ArabicAlpha Alpha 255tickticktick
19. Lookup_Value_Arabic_SortAlpha Alpha 255tickticktick
20. Lookup_Value_ChineseAlpha Alpha 255tickticktick
21. Lookup_Value_Chinese_PyAlpha Alpha 255tickticktick
22. Lookup_Value_JapaneseAlpha Alpha 255tickticktick
23. Lookup_Value_Japanese_SortAlpha Alpha 255tickticktick
24. Lookup_Value_KoreanAlpha Alpha 255tickticktick
25. Lookup_Value_Korean_SortAlpha Alpha 255tickticktick
26. Lookup_Value_ConcatenatedText Text Cluster B-tree, Keywordstickticktick
27. Record_Owner_IDLongint Longint tickticktick
28. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Lookup_Values_Filters]Lookup_ID[Lookup_Values]Lookup_ID

[-] Lookup_Values_Filters

Triggers

On LoadOn Save New RecordOn DeleteOn Save
ticktick

Table (6 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDAlpha Alpha 255ticktickticktick
2. Lookup_IDAlpha Alpha 255tickticktick
3. Filter_Lookup_IDAlpha Alpha 255Autotickticktick
4. Filter_Lookup_ValueAlpha Alpha 255tickticktick
5. Record_Owner_IDLongint Longint tickticktick
6. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Lookup_Values_Filters]Lookup_ID[Lookup_Values]Lookup_ID

[-] Object_Management

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (41 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDAlpha Alpha 9B-treetickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Ready_For_PublicationBoolean Boolean tickticktick
8. Published_DateDate Date tickticktick
9. Published_PersonAlpha Alpha 255tickticktick
10. Object_IDAlpha Alpha 255B-treetickticktick
11. Archival_LevelAlpha Alpha 255Cluster B-treetickticktick
12. ProvenanceText Text tickticktick
13. Institute_And_CollectionAlpha Alpha 255tickticktick
14. Collection_IDAlpha Alpha 255Cluster B-treetickticktick
15. LocationText Text Cluster B-treetickticktick
16. Location_CheckedBoolean Boolean tickticktick
17. Checked_DateDate Date tickticktick
18. Checked_PersonAlpha Alpha 255tickticktick
19. Location_CommentsText Text tickticktick
20. AccessAlpha Alpha 255Cluster B-treetickticktick
21. ConditionAlpha Alpha 255Cluster B-treetickticktick
22. Condition_CommentText Text tickticktick
23. Title_DescriptiveText Text tickticktick
24. DescriptionText Text tickticktick
25. ExtentText Text tickticktick
26. DateText Text tickticktick
27. CoordinatesAlpha Alpha 255tickticktick
28. Coordinates_CommentsAlpha Alpha 255tickticktick
29. TypeAlpha Alpha 255Cluster B-treetickticktick
30. FormAlpha Alpha 255Cluster B-treetickticktick
31. Materials_TechiniqueAlpha Alpha 255Cluster B-treetickticktick
32. Languages_And_ScriptsText Text Cluster B-treetickticktick
33. KeywordsText Text Cluster B-treetickticktick
34. Ready_For_DigitisationBoolean Boolean tickticktick
35. DigitisedBoolean Boolean tickticktick
36. Type_ValueAlpha Alpha 255tickticktick
37. Form_ValueAlpha Alpha 255tickticktick
38. Materials_Technique_ValueAlpha Alpha 255tickticktick
39. Languages_And_Scripts_ValueAlpha Alpha 255tickticktick
40. Record_Owner_IDLongint Longint tickticktick
41. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Alternative_Object_IDs]Object_ID[Object_Management]Object_ID
[Authority_Link]Object_ID[Object_Management]Object_ID
[Digital_Object_Management]Object_ID[Object_Management]Object_ID
[Relationship_Management]Object_ID[Object_Management]Object_ID
[Object_Management]Collection_ID[Collection_Management]Collection_ID

[-] People_Management

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (22 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDAlpha Alpha 255tickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Person_IDAlpha Alpha 255ticktickticktick
8. Institution_IDAlpha Alpha 255Cluster B-treetickticktick
9. Person_TitleText Text tickticktick
10. Person_DescriptionText Text tickticktick
11. Person_SurnameAlpha Alpha 255tickticktick
12. Person_FirstnameAlpha Alpha 255tickticktick
13. Person_RoleText Text tickticktick
14. Person_DepartmentText Text tickticktick
15. Mailing_AddressText Text tickticktick
16. Mail_RegionAlpha Alpha 255tickticktick
17. Mail_LanguagesAlpha Alpha 255tickticktick
18. Mail_CodeAlpha Alpha 255tickticktick
19. Mail_CopiesInteger Integer tickticktick
20. Resource_IDText Text tickticktick
21. Record_Owner_IDLongint Longint tickticktick
22. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[People_Management]Institution_ID[Institutional_Management]Institution_ID

[-] Preferences

Triggers

On LoadOn Save New RecordOn DeleteOn Save

Table (2 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Database_LanguageAlpha Alpha 255tickticktick
2. Database_SiteIDLongint Longint tickticktick

Relations

FromTo

[-] Relationship_Link

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (12 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDText Text tickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Relationship_IDAlpha Alpha 255Cluster B-treetickticktick
8. Digital_Object_NameText Text Autotickticktick
9. OrderReal Real tickticktick
10. RotationInteger Integer tickticktick
11. Record_Owner_IDLongint Longint tickticktick
12. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Relationship_Link]Relationship_ID[Relationship_Management]Relationship_ID
[Digital_Object_Management]Digital_Object_Name[Relationship_Link]Digital_Object_Name

[-] Relationship_Management

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (13 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDAlpha Alpha 255tickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Object_IDAlpha Alpha 255Cluster B-treetickticktick
8. Relationship_IDAlpha Alpha 255Autotickticktick
9. Relationship_TitleText Text tickticktick
10. Relationship_DescriptionText Text tickticktick
11. Resource_IDAlpha Alpha 255tickticktick
12. Record_Owner_IDLongint Longint tickticktick
13. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Relationship_Management]Object_ID[Object_Management]Object_ID
[Relationship_Link]Relationship_ID[Relationship_Management]Relationship_ID
[Relationship_Management]Resource_ID[Resource_Management]Resource_ID

[-] Resource_Management

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (24 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDText Text tickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Ready_For_PublicationBoolean Boolean tickticktick
8. Published_DateDate Date tickticktick
9. Published_PersonAlpha Alpha 255tickticktick
10. Resource_IDAlpha Alpha 255B-treetickticktick
11. Resource_Standard_IDAlpha Alpha 255tickticktick
12. Resource_TypeText Text tickticktick
13. Resource_AuthorsText Text tickticktick
14. Resource_DateText Text tickticktick
15. Resource_TitleText Text tickticktick
16. Resource_CitationText Text tickticktick
17. Resource_DescriptionText Text tickticktick
18. Resource_FormatsText Text tickticktick
19. Resource_LanguagesText Text tickticktick
20. Resource_Image_PathText Text tickticktick
21. Resource_Statement_Of_UseText Text tickticktick
22. KeywordsText Text Cluster B-tree, Keywordstickticktick
23. Record_Owner_IDLongint Longint tickticktick
24. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Resources_Link]Resource_ID[Resource_Management]Resource_ID
[Relationship_Management]Resource_ID[Resource_Management]Resource_ID

[-] Resources_Link

Triggers

On LoadOn Save New RecordOn DeleteOn Save
tickticktick

Table (12 fields)

Field nameTypeIndexedUniqueNot NullNever NullInvisibleEnterableModifiableMandatoryMultilineCompressedUTF-8 EncodingUUID
1. Record_IDText Text tickticktickticktick
2. CommentsText Text tickticktick
3. Input_DateDate Date ticktick
4. Input_PersonAlpha Alpha 255ticktick
5. Last_Edit_DateDate Date ticktick
6. Last_Edit_PersonAlpha Alpha 255ticktick
7. Resource_IDAlpha Alpha 255Cluster B-treetickticktick
8. Resource_FormatText Text tickticktick
9. Resource_PathText Text tickticktick
10. Resource_ExtentText Text tickticktick
11. Record_Owner_IDLongint Longint tickticktick
12. Database_Site_IDLong 64 Long 64 tickticktick

Relations

FromTo
[Resources_Link]Resource_ID[Resource_Management]Resource_ID