• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter II-3. Development > Database Design

Database Design

Often, in sophisticated applications the database design is one of the most crucial steps to a successful implementation. Vshift's ColdFusion team has been dealing with database-intensive web applications for a while now, so the team was prepared to design the database with growth in mind. That being said, the database for this application does not need to be very complicated. The team decided to create only two tables for this database (Figure II-3.1). The two tables are the Users table and the Reports table. The Users table will hold the user's user name, password, and access level, plus a unique ID assigned to the user (Figure II-3.2). The Reports table will hold the report unique identifier, submit date, total, title, status, return reason, actual report data, and unique identifier of the user who has submitted the report (Figure II-3.3). The status field will be a text field describing the status of the order; possible values are pending, returned, approved, and deleted. The report data will be a large chunk of serialized text describing the report objects.

Figure II-3.1. This database diagram shows the tables and fields of the expense application database.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint