2024_04_02-exercise 1

Tables (4)

Product (Product-완제품)

  • Key (protid) — char(10) — Primary key — NOT NULL
  • Field (protdescription) — char(20)
  • Field (sales) — char(30)
  • Key (ptid) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (prodcid) — char(4) — Foreign key → Untitled.Key — NOT NULL

Untitled (Producer-생산자)

  • Key (prodcid) — char(4) — Primary key — NOT NULL
  • Field (prodname) — char(10)
  • Field (address) — char(40)
  • Field (phone) — char(11)

Untitled (Part-부품)

  • Key (ptid) — char(10) — Primary key — NOT NULL
  • Field (ptdescription) — char(20)
  • Key (ptcount) — char(10) — NOT NULL

Untitled (Product_납품회사)

  • Key (ptid) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (prodcid) — char(4) — Foreign key → Untitled.Key — NOT NULL