Data Structure and Management
Database Structure
The database is organized into multiple related tables that store different types of legal information:
Main Data Tables
- Answers
- HCCH Answers
- Domestic Instruments
- Domestic Legal Provisions
- Regional Instruments
- Regional Legal Provisions
- International Instruments
- International Legal Provisions
- Court Decisions
- Arbitral Institutions
- Arbitral Rules
- Arbitral Awards
- Literature
Metadata Tables
- Themes
- Questions
- Jurisdictions
- Topics
- Glossary
- Abbreviations
- Specialists
Airtable Configuration
Components
- Base: Collection of all data tables
- Table: Individual data tables within the base
- Field: Columns within tables (various data types)
- Record: Individual rows within tables
- Views: Saved configurations of filtered, sorted, or grouped data
Naming Conventions
- Table and Field names follow title case capitalization per APA guidelines
- “Linked” columns are named
<TABLE NAME> "Link" - Lookup columns are named
<TABLE NAME> <COLUMN NAME>
Data Entry Rules
For Answers/Questions/Jurisdictions Tables
- Use search/filter/group functions to locate records
- Edit existing fields as needed
- Do not add new entries to these tables
- For answers, select from predefined dropdown options
For Legal Provisions/Court Decisions/Arbitral Awards Tables
- Add new records as needed
- Edit existing information directly in the relevant fields
For Concepts
- Edit existing fields
- Use “Assignee” column to define responsibilities
File Storage
In addition to structured data in NocoDB:
- Original PDF files are stored in an Azure storage account named with their respective CoLD ID
- File naming convention: follows the CoLD ID logic, i.e. “CD-CHE-1020”
Data Volume
- Structured data: Less than 100MB
- PDF attachments: Additional 5-10GB