Hi,
How can I add COALESCE constraint for a table? I’m using YAML to declaring DB structure.
Eg. below is my table
CREATE TABLE AuditParameters
(
Id STRING(64) NOT NULL,
PartialMinimalAmount INT64,
PartialMaximalAmount INT64,
PartialMinimalCount INT64,
PartialMaximalCount INT64,
PartialPercentageAmount INT64,
PartialPercentageCount INT64,
CONSTRAINT CHK_AuditParameters_PartialRequirements CHECK (
COALESCE(PartialMinimalAmount, PartialMaximalAmount, PartialMinimalCount, PartialMaximalCount, PartialPercentageAmount, PartialPercentageCount) IS NOT NULL
)
) PRIMARY KEY (Id);