Quiz

Instruction

Very well. Let's get back to something more challenging.

Exercise

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. The price is not greater than 9999.99.
The columns: name, disease_chapter, disease_block form the primary key. If no price is provided, the default value should be 0.00.

Stuck? Here's a hint!

We discussed constraints in Part 5. Take a look back to refresh your memory.

Console

Code editor

Result

TableConsole