Advertisement

The DAO/Repository

  • Dave Wolf
  • A. J. Henley
Chapter

Abstract

Bullhorn requires two tables, for users and posts. We’ll create these tables in Oracle and call them Bhuser and Bhpost, respectively. The user table will need the following fields: user name, user email, password, motto, and join date. The posts table will contain fields for post text, post date, and the ID of the user who created the post. Each table will also contain an ID field to uniquely identify each record. We can instruct SQL Developer to construct the tables by running scripts. Simply enter the text seen in Listing 7-1 in SQL Developer inside a new SQL worksheet.

Copyright information

© Dave Wolf, A.J. Henley 2017

Authors and Affiliations

  • Dave Wolf
    • 1
  • A. J. Henley
    • 2
  1. 1.New YorkUSA
  2. 2.Washington, D.C.USA

Personalised recommendations