okay this is the issue
When you generate the PDM from the CDM, PowerDesigner generates, using
its own naming convention, the foreign key column that is placed in the
physical model table - we want to have control over this column name ie:
we want this foreign key column to be called f_key in our physical
table. Please note we are not talking about FK/PKconstraints names etc,
we are talking about the actual column name of the foreign key.
We have searched through the definition file and cannot find where its
Or is this not possible to control in PowerDesigner and you have ...PowerDesigner Conceptual modeling/Physical modeling...when to do it
We're trying to understand when in the development life cycle conceptual
modeling should take place. I'm hoping someone on this list can give me some
advice or point me to a good source for this sort of information.
The development process for us appears it should be...
1. Gather business requirements
2. Write a Functional Spec
3. Write a Technical Spec
But where in the above 4 steps do we do the DB modeling? Is conceptual in
1&2 and physical in 2&3?
We do conceptual modeling (CDM) during the Business
Requirements Gathering and Func...Speciying foregin key attribute name in Conceptual Model (CM)
From my understanding, foreign key columns are not specified in the CM (they
are implicitly defined in the relationship). This is fine if one wants the
PM column name of the foreign key to be the same name as the Primary Key in
the parent table.
But suppose I want two tables to eventually look like this in the PM:
Dept_No CHAR(3) Primary Key
Department_Manager INTEGER Foreign Key to Employee table
Employee_Id INTEGER Primary Key
Dept_No CHAR(3) Foreign Key to Department table
In the CM, I do not explicitly define t...How to create Logical model with powerdesigner 11.1. ( Not Conceptual model)
We bought powerdesigner 11.1 and using oracle Db 10g rel 2.
I would like create Logical model ( LDM) file and then
convert this LDM to PDM. But with this PD only can create
CDM(conceptual) and then convert to PDM. There is not option
given to convert from CDM to LDM adn then LDM to PDM.
I would like create non-identifying type relationship and
also use rolename column in my child table instead same
column of parent table.
please let me know if someone have answer for this .
thank you very much.
The way PowerDesigner implements the LDM is with a spec...Name Of Foreign Key
I'm using SQL Any50, ORACLE, and SQL Server 6.5 with a PB 6.0 Application.
I'm looking for a solution to get the name of the Foreign Key, for some
of my application.
Is there someone who know where i can find it in the system table ?
In Oracle, you need to look at either the ALL_CONSTRAINTS or the
In SQL Server 6.5, you would look at the SYSREFERENCES table.
I'm not sure where you'd look in SQL Anywhere.
Ron Gallagher, CPDP
Steph w...Foreign key name
I am using PD 11 . The scenario is:
when I create two relations between 2 tables (one with role name and the
other without role name) then generate the physical model, and use the
%PROLE% as FK column name .
when the model generates , one FK gest the role name and the others that
gest the table name as FK. I want to change the default of tabel name to
is there any one that knows the solotion?
The default behavior is for the parent table column name to be used as
the FK column. The columns from the first reference should be the
...Name of foreign key
I am working on a program we bought. The previous developpers used PowerAMC
and I can't find where they precised the way to name foreign keys.
Exemple : if the table "Bill" has a reference to the table "Supplier", when
I generate the MPD, the reference is converted this way in the table BILL :
I want to know where "ID_%TABLE%" is defined ?
Otherwise, is it possible for certain foreign keys to define in the MCD the
name they will have in the MPD ? Exemple : I have an other table where I
want one foreign_key to have a special n...Foreign Key Names
I can't seem to figure out where to set the Foreign Key Naming convention.
As I generate from a CDM to PDM how do I take control of how relationships
are migrated and named. and, what documentation should I read to get a
better handle on this?
OK, you do not have any control over the default foreign key names in the
initial CDM -> PDM generation. However, after you change it in the PDM, the
next time you generate PD will abide by your names.
Michael F. Nicewarner [TeamSybase]
"Coy Lay" <firstname.lastname@example.org...Table design question (to foreign key or not to foreign key)
Our application is a message board and is full of messages, threads, and
forums. A message is an individual entry (like the one I'm typing now ;)).
Our software gives the user the ability to upload a single file attachment
to each message.
I can think of a couple different ways to design the two tables:
message( messageid numeric identity, attachmentid numeric null, messagetext
text, other, message, stuff... )
attachment( attachmentid numeric identity, title varchar, other, stuff )
message( messageid, messagetext text, other, stuff )
attachment( messageid numeric foreig...Assigning foreign keys in code.
I am quite new, and though I have purchased and viewed several videos, I cannot figure out the answer to this embarrasingly simple data problem. I have changed the names of the 2 tables and fields for ease. This is all for a button click event:
SqlDataSource1.InsertCommand = "INSERT INTO [orders] ([o_detail1], [o_detail2]) VALUES (@o_detail1, @o_detail2)";SqlDataSource1.InsertParameters.Add("o_detail1", textbox1.text);SqlDataSource1.InsertParameters.Add("o_detail2", textbox2.text);
// The above code works fine. ...Naming of foreign keys in the PDM
When I have relationships between two tables, I cannot
influence the name of the foreign key field which is generated.
I have two tables: customer, user
I have two user references in the customer table, the user who manages the
and the user who created the customer record. When I generate the PDM I
get the field names "id_user" and "id_user2" which are not really useful. I
"managing_user" and "creation_user".
Is there a way to influence these names?
Neudorfstr...Assign a foreign key as a parameter
I have the following asp.net2.0 codeSelectCommand = "Select IDEmp, FirstName,MiddleName,LastName, Date,HoursNumber, Description
From Employee, WorkOnCategory , CatDesignItemReference
where IDEmp =IDEmplWork AND FirstName = @FirstName AND Category = @AnyCategory AND ">
<asp:ControlParameter ControlID="txtEmployeeName" DefaultValue="" Name="FirstName" PropertyName="Text" Type="String" /> <asp:ControlParameter ControlID="DropDownList1" DefaultValue="" N...RoleId/Name as Foreign Key
I'm trying to create a relational SQL data table where one of the foreign keys relates to the aspnet_Roles table.At first, I was linking to the RoleId field because it was the primary key, but that's no good because I can't retrieve the RoleId of a RoleName from my code.
I then read this post:http://forums.asp.net/p/1077364/1585594.aspx#1585594
How do I reference the RoleName field as a foreign key? I tried doing it but because RoleName isn't a Primary Key or 'Unique', it won't let me do it.I get the following message:'The columns in table 'aspnet_R...DA and foreign key names
When generating the physical data model, DA will rename a column which has
a foreign key (so that the column name is the same as the foreign key
column name). Is there a way to disable this ?
Scott Cunningham wrote:
> When generating the physical data model, DA will rename a column which has
> a foreign key (so that the column name is the same as the foreign key
> column name). Is there a way to disable this ?
I would sure like to know how as well!!! We've been renaming the FK
columns to an appropriate name on the first ge...