e7K1xfRe

1 CREATE TABLE IF NOT EXISTS public."TransactionDetails"
2(
3    id SERIAL,
4    idx uuid DEFAULT uuid_generate_v1(),
5    first_name text COLLATE pg_catalog."default" NOT NULL,
6    transaction_date date not null,
7    from_date date not null,
8    is_active boolean not null,
9    borrowed_amount float 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 "TransactionDetails_pkey" PRIMARY KEY (id)
14)
15WITH (
16        OIDS = FALSE
17    )
18    TABLESPACE pg_default;