| cgn_id | int(11) | NO | | PRI | auto_increment | |
| cgn_cus_id | int(11) | NO | 0 | | | Customer ID# |
| cgn_cli_id | int(11) | NO | 0 | | | Client ID# |
| cgn_cg_id | int(11) | NO | 0 | MUL | | Coding Guide ID# |
| cgn_cgna_id | int(11) | YES | 0 | MUL | | Coding Guide Selected Answer ID# |
| cgn_cs_id | int(11) | NO | 0 | | | Coding System ID# |
| cgn_question | varchar(256) | NO | | | | Question |
| cgn_concept | int(5) | YES | 0 | | | Medical Concept |
| cgn_duplicate_allowed | tinyint(1) | NO | 0 | | | Allows Duplicate |
| cgn_code | varchar(15) | NO | | | | Medical Concept Code |
| cgn_desc | varchar(40) | NO | | | | Medical Concept Code Description |
| cgn_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| cgn_created | timestamp | YES | CURRENT_TIMESTAMP | | | |