_1.coding_guide_node
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| cgn_id | int(11) | NO | PRI | auto_increment | ||
| 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_cus_id | int(11) | NO | 0 | Customer ID# | ||
| cgn_cli_id | int(11) | NO | 0 | Client ID# | ||
| cgn_cs_id | int(11) | NO | 0 | Coding System ID# | ||
| cgn_question | varchar(256) | NO | Question | |||
| cgn_concept | int(11) | 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 | datetime | YES | CURRENT_TIMESTAMP | |||
| cgn_created | datetime | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cgn_id |
|