2024_2_db_ex1

Tables (4)

Untitled (제품)

  • Key (제품번호) — char(30) — Primary key — NOT NULL
  • Field (제품명) — char(30)
  • Field (설명) — text
  • Field (가격) — int(10)

Untitled (부품)

  • Key (부품번호) — char(20) — Primary key — NOT NULL
  • Field (부품모델명) — char(30)
  • Field (부품명) — char(20)
  • Field (설명) — text
  • Key (고유먼호) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (제품_부품)

  • Key (제품번호) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (부품번호) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (수량) — int(3)

Untitled (생산자)

  • Key (고유먼호) — char(10) — Primary key — NOT NULL
  • Field (생산자명) — char(20)
  • Field (전화번호) — char(15)
  • Field (주소) — char(30)
  • Field (이메일) — email