怎样才能有一个条件必须为空的字段？

CREATE TABLE example_table (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    optional_field VARCHAR(100) NULL
);

CREATE TABLE example_table (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    status VARCHAR(50),
    optional_field VARCHAR(100),
    CONSTRAINT chk_optional_field CHECK ((status = 'inactive') THEN optional_field IS NULL)
);

from sqlalchemy import create_engine, Column, Integer, String, CheckConstraint
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class ExampleTable(Base):
    __tablename__ = 'example_table'
    id = Column(Integer, primary_key=True)
    name = Column(String(100))
    status = Column(String(50))
    optional_field = Column(String(100), nullable=True)
    __table_args__ = (
        CheckConstraint('status = "inactive" AND optional_field IS NULL', name='chk_optional_field'),
    )

engine = create_engine('sqlite:///example.db')
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()

# 示例插入数据
new_record = ExampleTable(name='John Doe', status='inactive', optional_field=None)
session.add(new_record)
session.commit()

const { Sequelize, DataTypes, Model } = require('sequelize');
const sequelize = new Sequelize('sqlite::memory:');

class ExampleTable extends Model {}

ExampleTable.init({
    id: {
        type: DataTypes.INTEGER,
        primaryKey: true
    },
    name: {
        type: DataTypes.STRING
    },
    status: {
        type: DataTypes.STRING
    },
    optional_field: {
        type: DataTypes.STRING,
        allowNull: true
    }
}, {
    sequelize,
    modelName: 'ExampleTable',
    tableName: 'example_table',
    timestamps: false,
    constraints: [
        {
            where: {
                status: 'inactive'
            },
            type: 'check',
            msg: 'optional_field must be null when status is inactive'
        }
    ]
});

(async () => {
    await sequelize.sync({ force: true });
    const newRecord = await ExampleTable.create({
        name: 'John Doe',
        status: 'inactive',
        optional_field: null
    });
    console.log(newRecord.toJSON());
})();