generated from NEFSC/NEFSC-Template
-
Notifications
You must be signed in to change notification settings - Fork 1
dbTable: GEAR_CODES
George Maynard edited this page Aug 2, 2022
·
1 revision
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| GEAR_CODE | varchar(6) | utf8mb4_0900_ai_ci | NO | PRI | NULL | select,insert,update,references | Concatenation of ACCSP and VTR gear codes used to map gears between the two data sets | |
| COMMON | varchar(80) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | How gears are referred to in the Northeastern United States | ||
| ACCSP_GEAR_CODE | varchar(3) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | ACCSP gear code | ||
| VTR_GEAR_CODE | varchar(3) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | VTR gear code | ||
| VTR_GEAR_NAME | varchar(80) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | VTR gear code description | ||
| ACCSP_GEAR_NAME | varchar(40) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | ACCSP gear code description | ||
| NEGEAR | varchar(3) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Gear coding equivalent for CFDBS an OBDBS | ||
| FMCODE | varchar(1) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | Gear category type indicator; F=fixed, M=mobile, O=other | ||
| ISSCFG_CODE_EN | varchar(80) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | English language ISSCFG gear description | ||
| CODE | varchar(5) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | ISSCFG gear code | ||
| GEAR_L1_NAME | varchar(40) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | General ISSCFG category | ||
| GEAR_L1_CODE | varchar(5) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | General ISSCFG category gear code |