So I am making a relational schema for health insurance plans but I do not know how to store them in MySQL. My problem is a health plan, which is the drug coverage shown by the tire. A certain medication is below one level and then there is information about pricing of arrows. Problems are different levels of different plans.
Example
Tier 1: 25 $ copies; Tier 2: 50 $ CopaTable tire after deduction 1: 25 $ Copa; Tier 2: 50 $ copy after deduction; Tier 3: 25% of the syllabus.
How can I handle a scheme in MySQL which will give meaning? I can not make each line a unique plan because I do not know how many levels will be present. Should I create another table that stores this information and links back to a plan?
From my description, I understand that there are several levels of a plan and one of the many plans Can be related. So, if you select plan & lt; If you create many for many relationships between -> category , will not it serve your purpose?
Logical data model, it will be decomposed into an association table (or gerund entity). Here's an example:
In this case, you can create a Plan_Tiers table, which is planId and tierId . You can have the required attributes like co-payment , copay after copay in category .
Hope it helps.
Comments
Post a Comment