Create a Window SQL Script

create table HT_SALARYCOMPONENT
(
    HT_SALARYCOMPONENT_ID   CHARACTER VARYING(32)           NOT NULL,
    AD_CLIENT_ID            CHARACTER VARYING(32)           NOT NULL,
    AD_ORG_ID               CHARACTER VARYING(32)           NOT NULL,
    ISACTIVE                CHARACTER(1)                    NOT null        DEFAULT 'Y',
    CREATED                 TIMESTAMP WITHOUT TIME zone     NOT null        DEFAULT now(),
    CREATEDBY               CHARACTER VARYING(32)           NOT NULL,
    UPDATED                 TIMESTAMP WITHOUT TIME zone     NOT null        DEFAULT now(),
    UPDATEDBY               CHARACTER VARYING(32)           NOT NULL,
    NAME                    varchar(60)                     not null,
    DESCRIPTION             varchar(2000),
    ISEARNING               CHARACTER(1)                    not null        default 'Y',

    CONSTRAINT HT_SALARYCOMPONENT_ISACTIVE_CHECK CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])),
    constraint HT_SALARYCOMPONENT_ISEARNING_CHECK check (isactive = any (array['Y'::bpchar, 'N'::bpchar])),
    CONSTRAINT HT_SALARYCOMPONENT_KEY PRIMARY KEY (HT_SALARYCOMPONENT_ID),
    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)
);