test1

Tables (9)

Untitled (사원)

  • Key (사원번호) — Primary key — NOT NULL
  • Field (이름)
  • Field2 (직책)
  • Field3 (급여)
  • Field (시)
  • Field2 (구)
  • Field (동)
  • Key (부서번호) — Foreign key → Untitled.Key — NOT NULL

Untitled (프로젝트)

  • Key (프로젝트번호) — Primary key — NOT NULL
  • Field (프로젝트명)
  • Field2 (예산)
  • Key (사원번호) — Foreign key → Untitled.Key — NOT NULL
  • Field (시작일)

Untitled (참여)

  • Key (사원번호) — Foreign key → Untitled.Key — NOT NULL
  • Key (프로젝트번호) — Foreign key → Untitled.Key — NOT NULL
  • Field (역할)
  • Field (기간)

Untitled (공급자)

  • Key (공급자번호) — Primary key — NOT NULL
  • Field (공급자명)
  • Field (신용도)

Untitled (부품)

  • Key (부품번호) — Primary key — NOT NULL
  • Field (가격)
  • Field (부품명)

Untitled (공급)

  • Field (수량)
  • Key (공급자번호) — Foreign key → Untitled.Key — NOT NULL
  • Key (부품번호) — Foreign key → Untitled.Key — NOT NULL
  • Key (프로젝트번호) — Foreign key → Untitled.Key — NOT NULL

Untitled (부양)

  • Key (이름) — Primary key — NOT NULL
  • Key — Foreign key → Untitled.Key — NOT NULL
  • Key (사원번호) — Foreign key → Untitled.Key — NOT NULL
  • Field (성별)

Untitled (부양가족)

  • Key — Primary key — NOT NULL
  • Key (사원번호) — Foreign key → Untitled.Key — NOT NULL

Untitled (부서)

  • Key (부서번호) — Primary key — NOT NULL
  • Field (층)
  • Field (부서명)