PLh2SZbk

1   CREATE TABLE IF NOT EXISTS public."InterestRateRangeDetails"
2(
3    id SERIAL,
4    idx uuid DEFAULT uuid_generate_v1(),
5    interest_rate_id  bigint,
6    attribute_type text COLLATE pg_catalog."default" NOT NULL,
7    from_amount bigint NULL,
8    to_amount bigint NULl,
9    range_value bigint NULL,
10    created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
11    is_obsolete boolean NOT NULL DEFAULT false,
12    modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
13    CONSTRAINT InterestRateRangeDetails_pkey PRIMARY KEY (id),
14    CONSTRAINT "fk_interest_rate_id" FOREIGN KEY (interest_rate_idx)
15        REFERENCES public."InterestRateDetails" (id) MATCH SIMPLE
16        ON UPDATE NO ACTION
17)
18WITH (
19        OIDS = FALSE
20    )
21    TABLESPACE pg_default;