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