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
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