Data Models‎ > ‎


Sybase PowerDesigner, Sql Server 2005

The original PhishGuard data model was prepared using Sybase PowerDesigner. As the database evolved, it was easier to model using the visual modeling tools in SQL*Server.

The database made extensive use of primary keys, foreign keys, constraints and stored procedures. In fact, most of the C# web services and admin web pages had a database stored procedure counterpart for Create, Update and Delete, along with utility functions to reset, delete/purge, as necessary.