Celestial Bodies Project instructions

Backend Development
1

Hello,
In the instructions, some are specific to particular tables, but are these instructions for every table in the database or for the database as a whole?

• You should use the INT data type for at least two columns that are not a primary or foreign key
• You should use the NUMERIC data type at least once
• You should use the TEXT data type at least once
• You should use the BOOLEAN data type on at least two columns

Regarding the following instruction, I have a join table that has IDs from two other tables, so that one will only have two columns. Furthermore, it only has the INT data type, which may breach the rules above.

  • Each table should have at least three columns
2

Hi @leebut

If the instructions do not specify a table, then they apply to the whole database.

So if one column must be …, then at least one table must have that column property.

Happy coding

1 Like
3

Thank you very much, Teller.

Happy coding to you, too.

1 Like