Oracle Data Modeler - Diagram notation
data-modeling, database-design, datamodel, oracle
Solution
P symbol before a Column name: the column is the "Primary key" ("P" for Primary) of the EntityType; Note that you can have two or more columns with a P symbol as a Primary key can be made of several columns
F symbol before a Column name: the column is a "Foreign key" ("F" for Foreign) which mean this column is referencing the Primary Key of another entity; Not that you can have several Foreign keys
PF symbol together: the column is both a Primary key and a Foreign key
"*" symbol (red asterisk): the column has a NOT NULL constraint; in other words, you can't insert a row (also called an "instance" of the Entity Type) in this table without a value for this column)
Diamond shape symbol (at the bottom of a Table): show the INDEXES on that table (in general the Primary Key is automatically an Index
Problem
Is there a detailed notational guide for the Relational model diagrams generated by the Oracle Data Modeler? I'm using Oracle Data Modeler to generate Relational Models for an existing database. It generated a diagram, but I'm not able to decode all the notations in the diagram. Some of the notations are: - arrows - asterisks (red) - Aphabetical notations (like P, F) - Symbols (like diamond, key) - Abbreviations (like IX) By mere inference, the above correspond to: - foreign key references - ?? - P - Private key; F - Foreign key - key - Private key - ?? However, I'm wondering if there is a detailed notational guide for the Oracle Data Modeler? I searched for it online, but could find none.