egUBatkQ

1-- ----------------------------
2-- Table structure for financial_balances
3-- ----------------------------
4DROP TABLE IF EXISTS "public"."financial_balances";
5CREATE TABLE "public"."financial_balances" (
6"financial_balances_id" int4 DEFAULT nextval('financial_balances_seq'::regclass) NOT NULL,
7"account_number" varchar(10) COLLATE "default" DEFAULT NULL::character varying,
8"total" numeric(11,2) DEFAULT 0,
9"current_balance" numeric(11,2) DEFAULT 0,
10"p30" numeric(11,2) DEFAULT 0,
11"p60" numeric(11,2) DEFAULT 0,
12"p90" numeric(11,2) DEFAULT 0,
13"p120" numeric(11,2) DEFAULT 0,
14"p150" numeric(11,2) DEFAULT 0,
15"total_spent" numeric(11,2) DEFAULT 0,
16"next_contact_time" timestamp(6),
17"current_contact_level" numeric(1),
18"credit_limit" numeric(11,2),
19"original_credit_limit" numeric(11,2),
20"purchase_amount" numeric(11,2) DEFAULT 0,
21"interest_amount" numeric(11,2) DEFAULT 0
22)
23WITH (OIDS=FALSE)
24
25;
26
27-- ----------------------------
28-- Alter Sequences Owned By 
29-- ----------------------------
30
31-- ----------------------------
32-- Indexes structure for table financial_balances
33-- ----------------------------
34CREATE INDEX "financial_balances_id_account_number_idx" ON "public"."financial_balances" USING btree ("account_number");
35CREATE INDEX "fb_idx_total" ON "public"."financial_balances" USING btree ("total");
36CREATE INDEX "fb_idx_current_balance" ON "public"."financial_balances" USING btree ("current_balance");
37CREATE INDEX "idx_fb_p30" ON "public"."financial_balances" USING btree ("p30");
38CREATE INDEX "idx_fb_p60" ON "public"."financial_balances" USING btree ("p60");
39CREATE INDEX "idx_fb_p900" ON "public"."financial_balances" USING btree ("p90");
40CREATE INDEX "idx_fb_p120" ON "public"."financial_balances" USING btree ("p120");
41CREATE INDEX "idx_fb_p150" ON "public"."financial_balances" USING btree ("p150");
42CREATE INDEX "idx_fb_timestamp" ON "public"."financial_balances" USING btree ("next_contact_time");
43
44-- ----------------------------
45-- Uniques structure for table financial_balances
46-- ----------------------------
47ALTER TABLE "public"."financial_balances" ADD UNIQUE ("account_number");
48
49-- ----------------------------
50-- Primary Key structure for table financial_balances
51-- ----------------------------
52ALTER TABLE "public"."financial_balances" ADD PRIMARY KEY ("financial_balances_id");
53
54-- ----------------------------
55-- Foreign Key structure for table "public"."financial_balances"
56-- ----------------------------
57ALTER TABLE "public"."financial_balances" ADD FOREIGN KEY ("account_number") REFERENCES "public"."debtor_personal" ("account_number") ON DELETE NO ACTION ON UPDATE NO ACTION;