transportation
5 transportation types: none a sibling also accepts, 1 that decompose into parts.
The 5 transportation types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
HS Tariff Code hs_code · VARCHAR | 8471.30 | — |
IATA Airport Code iata_code · VARCHAR | JFK | — |
ICAO Airport Code icao_code · VARCHAR | KJFK | — |
Shipping Container Code (ISO 6346) iso6346 · VARCHAR | MSCU1234566 | — |
UN/LOCODE unlocode · VARCHAR | USLAX | — |
Which transportation type is it?
1 of 5 transportation types accepts it.
| Type | Reads it as |
|---|---|
HS Tariff Code hs_code | 8471.30 |
Use it
CLI · DuckDB
$ printf '%s\n' '8471.30' '6110.20.20' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('8471.30'), ('6110.20.20')) t(v);After 6110.20.20, one type remains: hs_code.