CREATE TABLE IF NOT EXISTS vehicle_types (
    id SERIAL,
    name varchar(100) NOT NULL,
    tenant_id INTEGER DEFAULT NULL,
    branch_id INTEGER DEFAULT NULL,
    isDeleted BOOLEAN NOT NULL DEFAULT FALSE,
    updatedAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id)
);
CREATE INDEX IF NOT EXISTS vehicle_types_tenant_idx ON vehicle_types(tenant_id);
CREATE INDEX IF NOT EXISTS vehicle_types_branch_idx ON vehicle_types(branch_id);
