Hi ,
Looks like the FKEY on data_source_id in relation sales_opportunity
to data_source is missing.
Am i missing something obvious ?
regds
mallah.
Table "ofbiz.sales_opportunity"
Column | Type | Modifiers
-----------------------+--------------------------+-----------
sales_opportunity_id | character varying(20) | not null
opportunity_name | character varying(100) |
description | text |
next_step | text |
next_step_date | timestamp with time zone |
estimated_amount | numeric(18,2) |
estimated_probability | numeric(18,6) |
currency_uom_id | character varying(20) |
marketing_campaign_id | character varying(20) |
*data_source_id | character varying(20) | *
estimated_close_date | timestamp with time zone |
opportunity_stage_id | character varying(20) |
type_enum_id | character varying(20) |
created_by_user_login | character varying(255) |
last_updated_stamp | timestamp with time zone |
last_updated_tx_stamp | timestamp with time zone |
created_stamp | timestamp with time zone |
created_tx_stamp | timestamp with time zone |
Indexes:
"pk_sales_opportunity" PRIMARY KEY, btree (sales_opportunity_id)
"sls_opprtnt_txcrts" btree (created_tx_stamp)
"sls_opprtnt_txstmp" btree (last_updated_tx_stamp)
"slsopp_crncy_uom" btree (currency_uom_id)
"slsopp_mktgcmpg" btree (marketing_campaign_id)
"slsopp_stage" btree (opportunity_stage_id)
"slsopp_typ_enum" btree (type_enum_id)
"slsopp_usrlgn" btree (created_by_user_login)
Foreign-key constraints:
"slsopp_crncy_uom" FOREIGN KEY (currency_uom_id) REFERENCES
ofbiz.uom(uom_id)
"slsopp_mktgcmpg" FOREIGN KEY (marketing_campaign_id) REFERENCES
ofbiz.marketing_campaign(marketing_campaign_id)
"slsopp_stage" FOREIGN KEY (opportunity_stage_id) REFERENCES
ofbiz.sales_opportunity_stage(opportunity_stage_id)
"slsopp_typ_enum" FOREIGN KEY (type_enum_id) REFERENCES
ofbiz.enumeration(enum_id)
"slsopp_usrlgn" FOREIGN KEY (created_by_user_login) REFERENCES
ofbiz.user_login(user_login_id)
