TEST

Tables (4)

Table01 (Untitled)

  • 고객ID (Key) — Primary key — NOT NULL
  • 담당팀ID (Key2) — Foreign key → Table02.담당팀ID — NOT NULL
  • 담당팀명 (Key22) — Foreign key → Table02.담당팀명 — NOT NULL
  • 고객명 (Field)

Table02 (Untitled2)

  • 담당팀ID (Key) — Primary key — NOT NULL
  • 담당팀명 (Key2) — Primary key — NOT NULL

Table03 (Untitled3)

  • 담당자 ID (Key) — Primary key — NOT NULL
  • 담당자명 (Key2) — Primary key — NOT NULL

Table04 (Untitled4)

  • 고객대응ID (Key) — Primary key — NOT NULL
  • 담당자 ID (Key2) — Foreign key → Table03.담당자 ID — NOT NULL
  • 담당자명 (Key22) — Foreign key → Table03.담당자명 — NOT NULL
  • 고객ID (Key3) — Foreign key → Table01.고객ID — NOT NULL
  • 담당팀ID (Key23) — Foreign key → Table01.담당팀ID — NOT NULL
  • 담당팀명 (Key222) — Foreign key → Table01.담당팀명 — NOT NULL