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