fee_schedule

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	BIGINT	19		√	null

|

| | | insurance_company_id | INT | 10 | | | 0 |

|

| | | plan | VARCHAR | 20 | √ | | '' |

|

| | | code | VARCHAR | 10 | √ | | '' |

|

| | | modifier | VARCHAR | 2 | √ | | '' |

|

| | | type | VARCHAR | 20 | √ | | '' |

|

| | | fee | DECIMAL | 12,2 | √ | | NULL |

|

| | | effective_date | DATE | 10 | √ | | NULL |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
ins_plan_code_mod_type_date	Must be unique	Asc/Asc/Asc/Asc/Asc/Asc	insurance_company_id + plan + code + modifier + type + effective_date

Relationships

Close relationships within degrees of separation