Conflicting table columns when using Component in other Components

Conflicting table columns when using Component App in other Components in the same database.
Component Dependencies

*Customers *

Analysis

Melting depends on Customer, Analysis

Sales depends on Customer, Analysis, Melting

Testing depends on Sales, Analysis, Melting, Customer

This is how I have structured the Components. Testing, Sales and Melding is depending on other Components When I have created Testing and added Sales to this Component I can run create database as normal, but there is generated an update SQL Script which wants to


alter table SALES_SALE_ORDER drop column ANALYSIS_ID cascade ;

Am I doing it wrong related to building Components.
Is it not possible to use one Component i multible other Components.

The structure of Components is as follow:
Component

  1. Customers

  2. Analysis

  3. Melting depends on

    • Customer
    • Analysis
  4. Sales depends on

    • Customer
    • Analysis
    • Melting
  5. Testing depends on

    • Sales
    • Analysis
    • Melting
    • Customer

This is how I have structured the Components. Testing, Sales and Melding is depending on other Components When I have created Testing and added Sales to this Component I can run create database as normal, but there is generated an update SQL Script which wants to


alter table SALES_SALE_ORDER drop column ANALYSIS_ID cascade ;

HI.

I tried to reproduce the problem but my attempts were unsuccessful. Could you please give more details:

In which project the Analysis entity is?
Which cardinality has the relation?
Does the Analysis or SaleOrder entity have relations with other entities?

I will look at it a bit later and see if there is some problems causing this.

Hello.

Please see the topic. Maybe, the described problem has a similar reason.