erd team

Tables (13)

Account (CopyOfCopyOfCopyOfUntitled3)

  • account_# (Postoffice_number) — Primary key — NOT NULL
  • holder (Post office_location) — Primary key — NOT NULL
  • bank (Post office_number of employee) — Primary key — NOT NULL
  • status (Key) — Primary key — NOT NULL
  • payment_# (Postoffice_number2) — Foreign key → Payment.payment_# — NOT NULL
  • Customer_id (Key22) — Foreign key → Payment.Customer_id — NOT NULL
  • operator code (Postoffice_number22) — Foreign key → Payment.operator code — NOT NULL
  • Employee_id (Key222) — Foreign key → Payment.Employee_id — NOT NULL
  • bank_# (Postoffice_number3) — Foreign key → Bank.bank_# — NOT NULL
  • correction_# (Postoffice_number23) — Foreign key → Bank.correction_# — NOT NULL
  • Department_# (Postoffice_number222) — Foreign key → Bank.Department_# — NOT NULL
  • complaint_# (Postoffice_number223) — Foreign key → Payment.complaint_# — NOT NULL
  • Department_# (Postoffice_number2222) — Foreign key → Payment.Department_# — NOT NULL

Bank (CopyOfCopyOfCopyOfCopyOfUntitled3)

  • bank_# (Postoffice_number) — Primary key — NOT NULL
  • location (Post office_location) — Primary key — NOT NULL
  • correction_# (Postoffice_number2) — Foreign key → Correction.correction_# — NOT NULL
  • Department_# (Postoffice_number22) — Foreign key → Correction.Department_# — NOT NULL

Complaint (CopyOfCopyOfCopyOfUntitled5)

  • complaint_# (Postoffice_number) — Primary key — NOT NULL
  • reason (Post office_location) — Primary key — NOT NULL
  • Department_# (Postoffice_number2) — Foreign key → Department.Department_# — NOT NULL

Correction (CopyOfCopyOfCopyOfUntitled4)

  • correction_# (Postoffice_number) — Primary key — NOT NULL
  • current balance (Post office_location) — Primary key — NOT NULL
  • adjustment amount (Post office_number of employee) — Primary key — NOT NULL
  • new balance (Key) — Primary key — NOT NULL
  • Department_# (Postoffice_number2) — Foreign key → Department.Department_# — NOT NULL

Correspondence (CopyOfCopyOfCopyOfUntitled)

  • operator code (Postoffice_number) — Primary key — NOT NULL
  • date received (Post office_location) — Primary key — NOT NULL
  • amount (Post office_number of employee) — Primary key — NOT NULL
  • cash (Key) — Primary key — NOT NULL
  • Employee_id (Key2) — Foreign key → Employee.Employee_id — NOT NULL

Customer (CopyOfUntitled2)

  • Customer_id (Key) — Primary key — NOT NULL
  • address (Key2) — Primary key — NOT NULL
  • h.p (Key3) — Primary key — NOT NULL
  • operator code (Postoffice_number) — Foreign key → Correspondence.operator code — NOT NULL
  • Employee_id (Key22) — Foreign key → Correspondence.Employee_id — NOT NULL
  • complaint_# (Postoffice_number2) — Foreign key → Complaint.complaint_# — NOT NULL
  • Department_# (Postoffice_number22) — Foreign key → Complaint.Department_# — NOT NULL

Default (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • default_# (Postoffice_number) — Primary key — NOT NULL
  • Customer_id (Key) — Foreign key → Customer.Customer_id — NOT NULL
  • operator code (Postoffice_number2) — Foreign key → Customer.operator code — NOT NULL
  • Employee_id (Key22) — Foreign key → Customer.Employee_id — NOT NULL
  • Department_# (Postoffice_number3) — Foreign key → Department.Department_# — NOT NULL
  • complaint_# (Postoffice_number22) — Foreign key → Customer.complaint_# — NOT NULL
  • Department_# (Postoffice_number222) — Foreign key → Customer.Department_# — NOT NULL

Department (CopyOfCopyOfCopyOfUntitled2)

  • Department_# (Postoffice_number) — Primary key — NOT NULL
  • office_# (Post office_location) — Primary key — NOT NULL
  • name (Post office_number of employee) — Primary key — NOT NULL

Employee (Untitled)

  • Employee_id (Key) — Primary key — NOT NULL
  • address (Key2) — Primary key — NOT NULL
  • h.p (Key3) — Primary key — NOT NULL
  • department (Key4) — Primary key — NOT NULL
  • department manager (Key5) — Foreign key → Employee.Employee_id — NOT NULL

Mail (CopyOfCopyOfUntitled)

  • Mail_# (Postoffice_number) — Primary key — NOT NULL
  • sender (Post office_location) — Primary key — NOT NULL
  • address (Post office_number of employee) — Primary key — NOT NULL
  • zipcode (Key) — Primary key — NOT NULL
  • Postoffice_# (Postoffice_number2) — Foreign key → Post office.Postoffice_# — NOT NULL
  • Employee_id (Key2) — Foreign key → Employee.Employee_id — NOT NULL
  • Customer_id (Key3) — Foreign key → Customer.Customer_id — NOT NULL
  • operator code (Postoffice_number3) — Foreign key → Customer.operator code — NOT NULL
  • Employee_id (Key22) — Foreign key → Customer.Employee_id — NOT NULL
  • complaint_# (Postoffice_number22) — Foreign key → Customer.complaint_# — NOT NULL
  • Department_# (Postoffice_number222) — Foreign key → Customer.Department_# — NOT NULL

Payment (CopyOfCopyOfCopyOfCopyOfUntitled22)

  • payment_# (Postoffice_number) — Primary key — NOT NULL
  • payment form (Post office_location) — Primary key — NOT NULL
  • amount (Post office_number of employee) — Primary key — NOT NULL
  • due date (Key) — Primary key — NOT NULL
  • Customer_id (Key2) — Foreign key → Customer.Customer_id — NOT NULL
  • operator code (Postoffice_number2) — Foreign key → Customer.operator code — NOT NULL
  • Employee_id (Key222) — Foreign key → Customer.Employee_id — NOT NULL
  • complaint_# (Postoffice_number22) — Foreign key → Customer.complaint_# — NOT NULL
  • Department_# (Postoffice_number222) — Foreign key → Customer.Department_# — NOT NULL

Post office (CopyOfUntitled)

  • Postoffice_# (Postoffice_number) — Primary key — NOT NULL
  • location (Post office_location) — Primary key — NOT NULL
  • number of employee (Post office_number of employee) — Primary key — NOT NULL
  • branch number (Key) — Primary key — NOT NULL

Report (CopyOfCopyOfUntitled2)

  • report_# (Postoffice_number) — Primary key — NOT NULL
  • operator (Post office_location) — Primary key — NOT NULL
  • received manager (Post office_number of employee) — Primary key — NOT NULL
  • Employee_id (Key) — Foreign key → Employee.Employee_id — NOT NULL