Quiz

Instruction

That's right! Now, let's see if you can make the database generate numbers for you.

Exercise

Our small healthcare unit needs another table: medicine. It should have the following columns:

  • id which is the primary key generated automatically and has the following values: 10, 20, 30, 40, ... (Do not use sequences.)
  • market_name - up to 64 characters,
  • active_substance - up to 128 characters,
  • volume a float number,
  • quantity - an integer number,
  • on_prescription - a yes/no field.

Stuck? Here's a hint!

It might be worth taking a look at Part 5 if you can't remember how to generate numbers automatically.

Console

Code editor

Result

TableConsole