Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

table structure.

our company has some basic table column list, and I would like to share from you guys, by this, any suggestion/improvement can be seen from modelling and UML point of view.


User generated image
table name are :
1) tr_po_header
2)tr_po_misc
3)tr_po_detail
4) tr_po_detail_misc
5) tr_po_detail_ctc_archive

all the row below that table is the column name.
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

You'll want to provide some details as to what these tables are, and the FK's involved, as experts here cannot connect to your data source, look at data, and run queries, so we are limited in answering 'Here's my design, please improve it' style questions.
Avatar of marrowyung
marrowyung

ASKER

the color field is the one we use to join ,and the first 2 x column of each table is the primary key field.
It will be very hard to give you any good advice base on the figure.
Do you have a data model that you can share with us?
at this moment, this is the only piece of record I have and will have more in 2 weeks.

all color field is the column we used to join.

any suggestion like:
1) a table has too much column, normalize it?
I am sorry, I don't have much in data modeling information as this is a development task and I am not the developer.

any tools I can use to see the existing ER modeling or data modeling ? preferably with lines between them to show relationship ?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I can't figure it out . any step by step guide on it ?
There's no much to learn about Database Diagrams. It's really very direct and easy to work with. Here's the MSDN article about it.
I am sorry Vitor, so the data model you all are referring is about the database diagram, right?

but the link you show me is about creating a new database diagram.

tks anyway.
I think at the beginning, no diagram is normal even table structure is here, right?

so we need to create a new one and it will check all table structure and generate a diagram for us ?
"Any existing relationship will be show. "

for me I don't see relationship shown.
I am sorry, if we change anything in the diagram which related to the table design, will it reflect on the table schema level too ?

I am talking about data modeling design.