table

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_isearning_check CHECK (isearning = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
);