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