Bank database
The bank model is based on an underlying relational database. The EJBBANK database consists of the tables shown in Figure 10-2.
Figure 10-2. Bank database and tables
Tables
All the tables have a primary key. Some tables have a foreign key that relates the table to another table. The data types used in the tables are for illustration and do not represent a real banking system.
Customer table
The CUSTOMER table includes all the information recorded for a bank customer (Table 10-1).
| Column name | Type | Length | Key | Nulls | Description |
|---|---|---|---|---|---|
| CUSTOMERID | INTEGER | PK | No | Customer ID | |
| TITLE | CHAR | 3 | No | No | Title |
| FIRSTNAME | VARCHAR | 30 | No | No | First ... |
Get EJB 2.0 Development with WebSphere Studio Application Developer now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
