code
Identifiers for documents, devices, languages and code: DOIs for articles and datasets, IMEI numbers for mobile devices, language and locale tags such as en-US, and dotted, reverse-DNS names of code packages and classes.
4 code types: none a sibling also accepts, 3 that decompose into parts.
The 4 code types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
DOI doi · VARCHAR | 10.1038/nature12373 | — |
IMEI imei · VARCHAR | 490154203237518 | — |
Locale Code locale_code · VARCHAR | en | — |
Qualified Name qualified_name · VARCHAR | com.google.javascript.jscomp.Compiler | — |
Which code type is it?
1 of 4 code types accepts it.
| Type | Reads it as |
|---|---|
DOI doi | 10.1038/nature12373 |
Use it
Shell
printf '%s\n' '10.1038/nature12373' '10.1000/xyz123' > column.txt
finetype infer -f column.txt --mode columnDuckDB
SELECT ft_profile(v) FROM (VALUES ('10.1038/nature12373'), ('10.1000/xyz123')) t(v);After 10.1000/xyz123, one type remains: doi.