Compare production DB (reverse engineered) with development model.
| 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 | Toad Data Modeler 6.4.4.42
1. Introduction & Version Context Version: 6.4.4.42 (Build 6.4.4.42) Era: Late 2010s stable release. No longer supported by Quest, but still widely used for offline modeling, reverse engineering, and legacy database support (Oracle, SQL Server, MySQL, PostgreSQL, Sybase, DB2). no datatypes | Entity
View → Logical Model / Physical Model