erd팀플

테이블 (14)

Account (Untitled7)

  • account_# (Key) — 기본 키 — NOT NULL
  • bank_# (Key2) — 외래 키 → Bank.bank_# — NOT NULL
  • correction_# (Key22) — 외래 키 → Bank.correction_# — NOT NULL
  • Department_# (Key222) — 외래 키 → Bank.Department_# — NOT NULL
  • Department_# (Key3) — 외래 키 → Bank.Department_# — NOT NULL

Bank (Untitled12)

  • bank_# (Key) — 기본 키 — NOT NULL
  • correction_# (Key2) — 외래 키 → Correction.correction_# — NOT NULL
  • Department_# (Key22) — 외래 키 → Correction.Department_# — NOT NULL
  • Department_# (Key3) — 외래 키 → Department.Department_# — NOT NULL

Complain (Untitled3)

  • complain_# (Key) — 기본 키 — NOT NULL
  • customer_id (Key2) — 외래 키 → Customer.customer_id — NOT NULL
  • Department_# (Key3) — 외래 키 → Department.Department_# — NOT NULL
  • report_# (Key4) — 외래 키 → Report.report_# — NOT NULL
  • employ_id (Key22) — 외래 키 → Report.employ_id — NOT NULL

Correction (Untitled8)

  • correction_# (Key) — 기본 키 — NOT NULL
  • Department_# (Key2) — 외래 키 → Department.Department_# — NOT NULL

Correspondence (Untitled2)

  • correspondence_number (Key) — 기본 키 — NOT NULL
  • employ_id (Key2) — 외래 키 → Employee.employ_id — NOT NULL
  • Department_# (Key3) — 외래 키 → Department.Department_# — NOT NULL
  • customer_id (Key4) — 외래 키 → Customer.customer_id — NOT NULL
  • Department_# (Key5) — 외래 키 → Department.Department_# — NOT NULL

Customer (Untitled)

  • customer_id (Key) — 기본 키 — NOT NULL

Default (Untitled11)

  • default_# (Key) — 기본 키 — NOT NULL
  • customer_id (Key2) — 외래 키 → Customer.customer_id — NOT NULL
  • Department_# (Key3) — 외래 키 → Department.Department_# — NOT NULL

Department (Untitled5)

  • Department_# (Key) — 기본 키 — NOT NULL

Employee (Untitled4)

  • employ_id (Key) — 기본 키 — NOT NULL
  • department manager (Key2) — 외래 키 → Employee.employ_id — NOT NULL

Mail (Untitled13)

  • mail_# (Key) — 기본 키 — NOT NULL
  • employ_id (Key2) — 외래 키 → Employee.employ_id — NOT NULL
  • customer_id (Key3) — 외래 키 → Customer.customer_id — NOT NULL
  • postoffice_# (Key4) — 외래 키 → Post office.postoffice_# — NOT NULL

Management (Untitled10)

    Payment (Untitled6)

    • payment_# (Key) — 기본 키 — NOT NULL
    • customer_id (Key2) — 외래 키 → Customer.customer_id — NOT NULL
    • Key (Key3) — 외래 키 → Account.account_# — NOT NULL
    • bank_# (Key22) — 외래 키 → Account.bank_# — NOT NULL
    • correction_# (Key222) — 외래 키 → Account.correction_# — NOT NULL
    • Department_# (Key2222) — 외래 키 → Account.Department_# — NOT NULL
    • Department_# (Key32) — 외래 키 → Account.Department_# — NOT NULL
    • Department_# (Key4) — 외래 키 → Department.Department_# — NOT NULL

    Post office (Untitled14)

    • postoffice_# (Key) — 기본 키 — NOT NULL

    Report (Untitled9)

    • report_# (Key) — 기본 키 — NOT NULL
    • employ_id (Key2) — 외래 키 → Employee.employ_id — NOT NULL