Column settings allow for options to be set for individual columns of data from the database.
Physical Name
The name of the column used by the database.
Label
The display name to be used in Jira.
Type
The data type (such as number, string, date, etc.) is used for data validations on INSERT and, more importantly, indexing. A text column can be indexed as a string and a number column as number so you can use the correct operators when searching with JQL.
Default Value
The value that should be selected before the user inputs a new value.
PK
The column is the primary key in the connected database.
Searchable
The column data should be searchable. This setting makes the column appear or not appear in the search window. The search script should also be updated in order to make sure the results for this column are being returned.
Required
The column should be required and must be filled in prior to the user updating the values.
Constraints
Settings that require the input data to match certain conditions prior to the user saving the values. See Constrains for more information about using constraints.