OptionaltypeColumn type (required for stored/generated columns) Example: 'varchar(255)', 'integer', 'decimal(10,2)'
OptionalasSQL expression for the generated column Example: 'CONCAT(first_name, " ", last_name)', 'price * quantity'
OptionalstoredWhether the column is stored or virtual
OptionalidentityEnable identity/auto-increment for the column PostgreSQL: IDENTITY, MySQL: AUTO_INCREMENT
OptionalstartStarting value for identity sequence PostgreSQL: START WITH, MySQL: auto_increment
OptionalincrementIncrement value for identity sequence PostgreSQL: INCREMENT BY, MySQL: auto_increment_increment
OptionalcacheNumber of sequence values to cache PostgreSQL: CACHE, MySQL: auto_increment_cache_size
OptionalminMinimum value for the sequence
OptionalmaxMaximum value for the sequence
OptionalcycleWhether the sequence cycles when exhausted
OptionalsequenceCustom sequence name (PostgreSQL specific)
Options for
Generated
decorator