스프링배치예시

테이블 (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

Job (a)

    JobExcecution (c)

      JobInstance (b)

        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