Internationalization Tables¶
Countries (countries)¶
Purpose: ISO country codes for internationalization with regional settings
Use Case Example: Store production locations and crew nationalities using standard ISO codes like "US" for United States, "GB" for United Kingdom, with default timezone, currency, and language settings.
| Column | Type | Description |
|---|---|---|
| code | TEXT | ISO 3166-1 alpha-2 code (e.g., US, GB) |
| name | TEXT | Full country name |
| timezone | TEXT | Default timezone for the country (e.g., America/New_York) |
| currency_code | TEXT | Default currency code (FK to currencies table) |
| language_code | TEXT | Default language code (FK to languages table) |
| consumption_tax_name | TEXT | Common name or acronym for the country's main consumption tax (e.g., VAT, GST, IVA) |
| flag | TEXT | Unicode emoji flag for the country (e.g. 🇬🇧). Added by the forms migration |
| nationality | TEXT | Demonym for citizens of this country (e.g. British, Indian, American). Added by the forms migration |
Key Features:
- Foreign key relationships to currencies and languages tables
- Helps auto-populate user preferences based on country selection
- Provides regional defaults for new projects
- Consumption tax names used for validation and user-friendly error messages
Currencies (currencies)¶
Purpose: ISO currency codes for financial transactions
Use Case Example: Track project budgets in multiple currencies - main budget in USD, European expenses in EUR, UK expenses in GBP.
| Column | Type | Description |
|---|---|---|
| code | TEXT | ISO 4217 code (e.g., USD, EUR) |
| name | TEXT | Full currency name |
| symbol | TEXT | Currency symbol (e.g., $, €) |
Languages (languages)¶
Purpose: ISO language codes for UI localization
Use Case Example: Users can set their UI language preference to "es" for Spanish or "en" for English interface.
| Column | Type | Description |
|---|---|---|
| code | TEXT | ISO 639-1 code (e.g., en, es) |
| name | TEXT | Full language name |