· 6 years ago · Nov 29, 2019, 02:10 AM
1 CREATE TABLE IF NOT EXISTS public."CreditBalanceDetails"
2(
3 id SERIAL,
4 idx uuid DEFAULT uuid_generate_v1(),
5 first_name text COLLATE pg_catalog."default" NOT NULL,
6 credit_balance float not null,
7 is_payable boolean not null,
8 is_active boolean not null,
9 created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
10 is_obsolete boolean NOT NULL DEFAULT false,
11 modified_on timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
12 CONSTRAINT CreditBalanceDetails_pkey PRIMARY KEY (id)
13)
14WITH (
15 OIDS = FALSE
16 )
17 TABLESPACE pg_default;