Exe7-006

Tables (5)

Untitled (전문분야)

  • Key (전문분야ID) — char(10) — Primary key — NOT NULL
  • Field (이름) — char(10)
  • Field

Untitled (대출)

  • Key (대출ID) — char(10) — Primary key — NOT NULL
  • Field (금액)
  • Field (대출일)
  • Field (상환일)
  • Field (수량)
  • Field (대출조건) — txt
  • Key (proID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Key (사원ID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Field

Untitled2 (PROJECT)

  • Key (proID) — char(10) — Primary key — NOT NULL
  • Key (사원ID) — char(10) — Foreign key → Untitled3.Key — NOT NULL
  • Field
  • Key (하도급ID) — char(10) — Foreign key → Untitled4.Key — NOT NULL

Untitled3 (관리자)

  • Key (사원ID) — char(10) — Primary key — NOT NULL
  • Field (이름) — char(10)
  • Field (전화) — char(11)
  • Field

Untitled4 (하도급업자)

  • Key (하도급ID) — char(10) — Primary key — NOT NULL
  • Field (이름)
  • Field (주소)
  • Field2 (전화)
  • Key (전문분야ID) — char(10) — Foreign key → Untitled.Key — NOT NULL