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