A small healthcare unit wants to have a table with treatment options. The treatment offers are based on the International Statistical Classification of Diseases and Related Health Problems.
Create a table called
treatment with the following columns:
name - a text of up to 100 characters,
disease_chapter - a text of up to 4 characters,
disease_block - a three-letter code,
price - a decimal number with up to 6 digits, two of which are after the decimal point.
form the primary key. If no price is provided, the default value should be 0.00.