| name |
string |
Column name |
| datatype |
string |
The data type for the column |
| nullable |
boolean |
Specifies that the column does allow NULL values or not |
| default |
string |
Specifies whether a default value is automatically inserted in the column if a value is not explicitly specified via an INSERT or CREATE TABLE AS SELECT statement |
| primary_key |
boolean |
A primary key is the column or columns that contain values that uniquely identify each row in a table |
| unique_key |
boolean |
Unique keys are columns in a table that uniquely identify items in the rows. This sounds a lot like a primary key, but the main difference is that unique keys can have NULL values. |
| check |
string |
|
| expression |
string |
|
| comment |
string |
Specifies a comment for the column |