Which columns should not be nullable? I think only columns

Question

Which columns should not be nullable? I think only columns

which store relations between tables should not be nullable, because if they be filled with null in a row, that row only uses some space in the database and would never be accessed or used. All other cols can be null. is this true?

0

17.07.2019

1 ответов

10 просмотров

Alexeyer Er · Accepted Answer

Alexeyer Er

That depends on your project logic. If you store, e.g., billing data, then event timestamp and amount of money shouldn't be null even if they has no foreign references.

0

17.07.2019

Похожие чаты

Which columns should not be nullable? I think only columns

1 ответов

Похожие вопросы