erd1

Tables (5)

Untitled (Producer(생산자))

  • Key (Pro_No) — int — Primary key — NOT NULL
  • Field (Pro_Name) — char(20)
  • Field (Pro_Adress) — char(30)
  • Field (Pro_PN) — char(30)
  • Field (실명) — lolgtext
  • Field (이메일) — char(30)

Untitled (product(생산품))

  • Key (제공ID) — char(20) — Primary key — NOT NULL
  • Field (부품ID) — char(20)
  • Field (부품수량) — int
  • Key (부품ID2) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (PartProducer(부품생산자))

  • Key (PP_No) — int — Primary key — NOT NULL
  • Field (PP_name) — char(20)
  • Field (PP_Adress) — char(30)
  • Field (PP_PN) — text

Untitled (Part(부품))

  • Key (부품ID) — int — Primary key — NOT NULL
  • Field (모델명) — cahr(20)
  • Field (부품명) — char(80)
  • Field (실명) — lolgtext
  • Key (Pro_No) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (PP_No) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (제공)

  • Key (제품ID) — int(20) — Primary key — NOT NULL
  • Field (모델명) — char(20)
  • Field (제품명) — char(20)
  • Field (설명) — text
  • Field (가격) — int(20)
  • Field (생산일자) — date