Home » questions » Database Table diagram (E-R diagram)?

Database Table diagram (E-R diagram)?

2
2006-08-15 02:22:18, Category: Programming & Design
I've got an E-R diagram showing the relationship between several tables and plus I have the table definition, containing the name of the columns for every table. Some columns have # or a * before their names... Does anyone know the exact meaning of theses symbols? This is just my personal guess, but I think * means the field is required for evey entry, and # refers to fields that comprise the primary key.... However, it's just a guess and I'd like to know whether this is a well-known notation or just someone's particular notation...

Answers

  1. jmfc

    On 2006-08-15 09:11:15


    * is usually used to signify a required (ie not null) field. The # character would be for an autonumber, unique field. This should be the primary key in most cases. I don't believe this is a standard way to represent this though.

  2. thomasalanshearer

    On 2006-08-15 02:41:50


    It could be the symbols for Foreign Key and Primary Key.. The "#" symbol could be identifying an integer or number field.. or it could juts be the short form for number