add new constraint

CREATE TABLE ht_salarycomponent
(
    ht_salarycomponent_id varchar(32) PRIMARY KEY NOT NULL,
    ad_client_id varchar(32) NOT NULL,
    ad_org_id varchar(32) NOT NULL,
    isactive CHARACTER(1) NOT NULL DEFAULT 'Y',
    created timestamp WITHOUT time ZONE NOT NULL DEFAULT now(),
    createdby varchar(32) NOT NULL,
    updated timestamp WITHOUT time ZONE NOT NULL DEFAULT now(),
    updatedby varchar(32) NOT NULL,
    name varchar(60) NOT NULL,
    description varchar(2000),
    isearning CHARACTER(1) NOT NULL DEFAULT 'Y',
    CONSTRAINT ht_salarycomponent_ad_org FOREIGN KEY (ad_org_id)
    REFERENCES ad_org (ad_org_id),
    CONSTRAINT ht_salarycomponent_ad_client FOREIGN KEY (ad_client_id)
    REFERENCES ad_client(ad_client_id),
    CONSTRAINT ht_salarycomponent_check CHECK (isactive = ANY (ARRAY ['Y'::bpchar, 'N'::bpchar])),
    CONSTRAINT ht_salarycomponent_chek CHECK (isearning = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
);

ALTER TABLE ht_salarycomponent ADD COLUMN age NUMERIC ;
ALTER TABLE ht_salarycomponent ADD COLUMN address varchar(100) ;
ALTER TABLE ht_salarycomponent ADD COLUMN man CHARACTER (1) NULL DEFAULT 'Y';
ALTER TABLE ht_salarycomponent ADD COLUMN woman CHARACTER (1) NULL DEFAULT 'Y';


ALTER TABLE ht_salarycomponent ADD CONSTRAINT ht_salarycomponent_woman CHECK ((woman = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])));
ALTER TABLE ht_salarycomponent ADD CONSTRAINT ht_salarycomponent_man CHECK ((man = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])));

SELECT * FROM ht_salarycomponent