What does I1, I2, U1, means in Visio database relationship diagram?

database uml visio
anh picture anh · Apr 12, 2011 · Viewed 9.3k times · Source

I am reverse engineering an database to create an database ER diagram in Visio. When I display the table in Visio, on the left hand side of the entity diagram, I see symbols next to the column names that I do not know what they mean. Symbols such as, U1, U2, l1, l2, l5...etc. Others symbols such as PK (primary key) and FK (foreign key) are also shown in the same area, but those obviously make sense to me.

Answer

JStead picture JStead · Apr 12, 2011

These are other types of indexes.

U1 = Unique Index 1..... I1 = Index 1......

Here are examples in SQL Server http://msdn.microsoft.com/en-us/library/ms188783.aspx

Related questions

Display primary : foreign key relationships in Visio database diagram

I've created a Database Model relationship diagram in Visio with tables and relationships. However, I can't find any way to automatically display the Primary Key :: Foreign Key relationship in the diagram. The only workaround I can find is to insert …

Read More
Multiplicity vs Cardinality

When talking about data models and databases, the term Cardinality is often used to describe the number of allowed elements in a given set. UML often refers to the same property as Multiplicity. Is there any differences between these two …

Read More
How to decide whether to use ER or UML for modelling?

A UML diagram can be used both to model database designs and class designs, but an ER diagram should be used exclusively in database problems. How do you pick one graphical representation over the other?

Read More