The Collection Agency Problem for ABC Organization

Tables (11)

ACCOUNTING (Untitled7)

  • ACCOUNT_NUM (Key) — Primary key — NOT NULL
  • PAYMENT_FORM_2 (Field)
  • PAYMENT (Field2)
  • Field3
  • ACCOUNT_NO (Key2) — Foreign key → RESEARCH.ACCOUNT_NO — NOT NULL
  • FORM_TYPE (Key22) — Foreign key → RESEARCH.FORM_TYPE — NOT NULL
  • NAME (Key3) — Foreign key → RESEARCH.NAME — NOT NULL
  • ADDRESS (Key222) — Foreign key → RESEARCH.ADDRESS — NOT NULL

BANK (Untitled8)

  • ACCOUNT_NUM (Key) — Primary key — NOT NULL
  • 미확인 계좌 지불 (Field)
  • Field2
  • Field3
  • Field4

CUSTOMER (Untitled2)

  • NAME (Key) — Primary key — NOT NULL
  • ADDRESS (Key2) — Primary key — NOT NULL
  • ACCOUNT_NO (Field)
  • COMPLAIN (Field2)
  • Field3
  • Field4

ENVELOPE (Untitled)

  • NAME (Key) — Foreign key → CUSTOMER.NAME — NOT NULL
  • ADDRESS (Key22) — Foreign key → CUSTOMER.ADDRESS — NOT NULL
  • (Field)
  • CORRESPONDENCE (Field2) — Y/N
  • Field3
  • Field4

FORM&CORRESPONDENCE (Untitled5)

  • NAME (Key) — Foreign key → ENVELOPE.NAME — NOT NULL
  • ADDRESS (Key22) — Foreign key → ENVELOPE.ADDRESS — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

MANAGER (Untitled6)

  • DEPT_NAME (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

PAYMENT&FORM (Untitled3)

  • NAME (Key) — Foreign key → ENVELOPE.NAME — NOT NULL
  • ADDRESS (Key22) — Foreign key → ENVELOPE.ADDRESS — NOT NULL
  • Field
  • Field2
  • Field3

PAYMENT_ONLY (Untitled4)

  • NAME (Key) — Foreign key → ENVELOPE.NAME — NOT NULL
  • ADDRESS (Key22) — Foreign key → ENVELOPE.ADDRESS — NOT NULL
  • PAYMENT (Field2)
  • Field3
  • Field4

RESEARCH (Untitled10)

  • ACCOUNT_NO (Key) — Primary key — NOT NULL
  • FORM_TYPE (Key2) — Primary key — NOT NULL
  • PAYMENT (Field)
  • Field2
  • Field3
  • NAME (Key3) — Foreign key → SUPPORT.NAME — NOT NULL
  • ADDRESS (Key222) — Foreign key → SUPPORT.ADDRESS — NOT NULL

SUPPORT (Untitled11)

  • NAME (Key) — Foreign key → FORM&CORRESPONDENCE.NAME — NOT NULL
  • ADDRESS (Key22) — Foreign key → FORM&CORRESPONDENCE.ADDRESS — NOT NULL
  • FORM_TYPE (Field)
  • (Field2)
  • CORRESPONDENCE_TYPE (Field3)

WEEKLY_REPORT (Untitled12)

  • ACCOUNT_NUM (Key2) — Foreign key → ACCOUNTING.ACCOUNT_NUM — NOT NULL
  • NAME (Key3) — Foreign key → ACCOUNTING.NAME — NOT NULL
  • ADDRESS (Key222) — Foreign key → ACCOUNTING.ADDRESS — NOT NULL
  • WEEK (Field)
  • Field2
  • Field3