icd9_sg_code

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
sg_id	BIGINT UNSIGNED	20		√	null

|

| | | sg_code | VARCHAR | 5 | √ | | NULL |

|

| | | formatted_sg_code | VARCHAR | 6 | √ | | NULL |

|

| | | short_desc | VARCHAR | 60 | √ | | NULL |

|

| | | long_desc | VARCHAR | 300 | √ | | NULL |

|

| | | active | TINYINT | 3 | √ | | 0 |

|

| | | revision | INT | 10 | √ | | 0 |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
active	Performance	Asc	active
formatted_sg_code	Performance	Asc	formatted_sg_code
sg_code	Performance	Asc	sg_code
sg_id	Must be unique	Asc	sg_id

Relationships

Close relationships within degrees of separation