Transaction processing tables
This appendix shows the transaction processing tables that are used in our use case in Chapter 6, “Use case model” on page 35. For more information about these tables, see 6.3, “Database design” on page 37.
Table B-1 shows the customer table.
Table B-1 Customer table
|
Column name
|
Data type
|
Length
|
|
CUST_ID
|
VARCHAR
|
10
|
|
CUST_TYPE
|
CHAR
|
1
|
|
NAME
|
VARCHAR
|
20
|
|
ADDRESS
|
VARCHAR
|
50
|
|
CITY
|
VARCHAR
|
30
|
|
POST_CODE
|
VARCHAR
|
10
|
|
START_DATE
|
DATE
|
4
|
|
NATIONALITY
|
VARCHAR
|
20
|
|
ETHNIC
|
VARCHAR
|
10
|
|
GENDER
|
SMALLINT
|
2
|
|
DOB
|
DATE
|
4
|
|
EDU_LEV
|
CHAR
|
1
|
|
MAR_STAT ... |
Get Real-time Fraud Detection Analytics on IBM System z 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.
