1. Vertabelo
  2. Идеи
0
Отклонен

Column Defaults

Raymond Gigliotti 10 лет назад • обновлен 10 лет назад • 2
Have configuration options to set default values for new columns.

- Default data type and length
- Not Null/Nullable
- Default column name pattern

ie with table name users:
%TABLE_NAME%_id         - users_id
%SINGULAR_TABLE_NAME%_id     - user_id

This only applies to new columns created with the add column button and not foreign key columns.



ХОРОШО, МНЕ ПОНРАВИЛОСЬ
Рейтинг удовлетворенности
Оценка удовлетворенности от Raymond Gigliotti 10 лет назад
Отклонен
Jarosław Błąd (CEO) 10 лет назад
It is hard to imagine that you can set reasonable default values for data type/length/null of column for the whole model where you usually have hundreds or thousands columns with different types/length etc. So we don't plan to implement such feature.

Regarding column name patter it duplicates the following issue:
http://support.vertabelo.com/topic/565476-pattern-for-naming-objects/
You can vote up.
Raymond Gigliotti 10 лет назад
The default "NOT NULL" is becoming a real pain as 80% of the fields I enter are Nullable. So many times I create my tables and then when using them get a ton of "not null" errors.

Would it be possible to only make the following fields NOT NULL
- foreign keys created by the tool
- primary key fields

Сервис поддержки клиентов работает на платформе UserEcho