스프링배치예시
테이블 (7)
ACCOUNT (3)
- ACCOUNT_ID (Key) — INT — 기본 키 — NOT NULL
- BALANCE (Field) — FLOAT
- LAST_STATEMENT_DATE (Field2) — TIMESTAMP
CUSTOMER (1)
- CUSTOMER_ID (Key) — INT — 기본 키 — NOT NULL
- FIRST_NAME (Field) — VARCHAR(45)
- MIDDLE_NAME (Field2) — VARCHAR(45)
- LAST_NAME (Field3) — VARCHAR(45)
- SSN (Field4) — VARCHAR(45)
- EMAIL_ADDRESS (Field5) — VARCHAR(255)
- HOME_PHONE (Field6) — CHAR(10)
- CELL_PHONE (Field7) — CHAR(10)
- WORK_PHONE (Field8) — CHAR(10)
- NOTIFICATION_PREF (Field9) — CHAR(1)
CUSTOMER_ACCOUNT (2)
- CUSTOMER_CUSTOMER_ID (Key) — INT — 기본 키 — NOT NULL
- ACCOUNT_ACCOUNT_ID (Field) — INT
- CUSTOMER_ID (Key2) — INT — 외래 키 → CUSTOMER.CUSTOMER_ID — NOT NULL
- ACCOUNT_ID (Key3) — INT — 외래 키 → ACCOUNT.ACCOUNT_ID — NOT NULL
TRANSACTION (4)
- TRANSACTION_ID (Key) — INT — 기본 키 — NOT NULL
- ACCOUNT_ACCOUNT_ID (Field) — INT
- CREDIT (Field2) — FLOAT
- DEBIT (Field3) — FLOAT
- TIMESTAMP (Field4) — TIMESTAMP
- ACCOUNT_ID (Key2) — INT — 외래 키 → ACCOUNT.ACCOUNT_ID — NOT NULL