PowerDesigner (Database design) - add PK to cross-reference table
i would like to know how to add PK to cross - reference table which is created from converting Conceptual Model to Physical Model and associate it with other table as FK.
Conceptual Model
Physical Model
Expected Result
Physical Model
- Job Applications Table : PK ja_id(int)
- Applications Table : FK ja_id(int)
I think i've described my problem clear enough :)
Thanks for help !
Solution
Workaround for my question is shown in attached pics.
Conceptual Model
** Physical Model**
- Does the order of columns in a Postgres table impact performance?
- How to prove that two data models are logically equivalent?
- How to create materialized views in SQL Server?
- When is it better for normalization to put data of these tables into a single one and use another to differentiate what group the values belong to?
- What is the best practice in naming your "user" table?
- Database Structure for Tree Data Structure
- Automatically remove a row without foreign references
- Display / Logic issue, Many-to-many, how to display?
- What is the formal difference between relational and multidimensional databases?
- Where are all the native revisioned databases?
- A separate database for every customer or store them all in a single database?
- Relational Data Model for Double-Entry Accounting
- What business folks have to understand about database design
- Tool for EER Modeling
- PostgreSQL - One-To-One - which approach is "better"?
- Is it sensible to create a different table for the same data for each date?
- Is there ever a time where using a database 1:1 relationship makes sense?
- How does Citadel structure it's data using only the BerkeleyDB key/value store?
- DB Structure : Multiple tables with common ID
- Does not using NULL in PostgreSQL still use a NULL bitmap in the header?
- How do I enforce uniqueness across parent and child tables without denormalizing my data?
- How to avoid duplicate data in one-to-many relationship
- Should I avoid duplicate entries in a database?
- Postgres gist constraint difference between tsrange datatype and function
- Why choose a relational DB over a NoSQL one?
- Schema for a multilanguage database
- How do I preserve data integrity with a linking table in PostgreSQL?
- Why would someone set primary_key=True on an One to one reationship (OneToOneField)?
- Facebook wall's database structure
- Exist and Not Exists Query Misunderstanding?