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