| Layer | Purpose | Objects | |-------|---------|---------| | | Business entities, no datatypes | Entity, Attribute, Primary/Alternate Key, Relationship (non-identifying/identifying) | | Physical | Database-specific implementation | Table, Column (with datatype), Physical FK, Index, Storage clause, Partitioning |
Compare production DB (reverse engineered) with development model. Toad Data Modeler 6.4.4.42
View → Logical Model / Physical Model