dbTable: GEAR_CODES - GMaynard1/emolt_serverside GitHub Wiki

PURPOSE

TABLE DEFINITIONS

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

MYSQL CODE