--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = bbrk, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: loan_payment_detail_cashbook; Type: TABLE; Schema: bbrk; Owner: mysqltest; Tablespace: 
--

CREATE TABLE loan_payment_detail_cashbook (
    loan_payment_id integer NOT NULL,
    source_account_reference character varying(80) NOT NULL,
    source_contract_id integer NOT NULL
);


ALTER TABLE bbrk.loan_payment_detail_cashbook OWNER TO mysqltest;

--
-- Name: loan_payment_detail_cashbook_pkey; Type: CONSTRAINT; Schema: bbrk; Owner: mysqltest; Tablespace: 
--

ALTER TABLE ONLY loan_payment_detail_cashbook
    ADD CONSTRAINT loan_payment_detail_cashbook_pkey PRIMARY KEY (loan_payment_id);


--
-- Name: fk_lpdcb_srccontract; Type: INDEX; Schema: bbrk; Owner: mysqltest; Tablespace: 
--

CREATE INDEX fk_lpdcb_srccontract ON loan_payment_detail_cashbook USING btree (source_contract_id);


--
-- Name: fk_lpdcb_srccontract; Type: FK CONSTRAINT; Schema: bbrk; Owner: mysqltest
--

ALTER TABLE ONLY loan_payment_detail_cashbook
    ADD CONSTRAINT fk_lpdcb_srccontract FOREIGN KEY (source_contract_id) REFERENCES loan_contractn(loankey);


--
-- Name: fk_lpdcb_transaction; Type: FK CONSTRAINT; Schema: bbrk; Owner: mysqltest
--

ALTER TABLE ONLY loan_payment_detail_cashbook
    ADD CONSTRAINT fk_lpdcb_transaction FOREIGN KEY (loan_payment_id) REFERENCES loan_payments(dkey);


--
-- PostgreSQL database dump complete
--

