SelfRelationship

Tables (4)

Untitled (직원)

  • Key (id) — char(4) — Primary key — NOT NULL
  • Field (이름) — nvarchar(30)
  • Field (연락처) — char(20)
  • Key (부하직원id) — char(4) — Foreign key → Untitled.Key — NOT NULL

Untitled (Employee)

  • Key (id) — char(4) — Primary key — NOT NULL
  • Field (이름) — nvarchar(30)
  • Field (연락처) — char(20)

Untitled (상하관계)

  • Key (상사id) — char(4) — Primary key — NOT NULL
  • Key2 (부하id) — char(4) — Primary key — NOT NULL

Untitled

  • Key (id) — char(4) — Foreign key → Untitled.Key — NOT NULL