ERD Exercise1-2111150송찬혁
테이블 (5)
CATEGORY (Untitled3)
- cateName (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(100)
- description (Field2) — text
PART (Untitled2)
- partID (Key) — integer — 기본 키 — NOT NULL
- name (Field) — char(20)
- modelNumber (Field2) — char(30)
- description (Field3) — text
- price (Field4) — integer
- Field5
- suplierID (Key2) — integer(10) — 외래 키 → SUPPLIER.suplierID — NOT NULL
- cateName (Key3) — char(30) — 외래 키 → CATEGORY.cateName — NOT NULL
PRODUCT (Untitled5)
- modelNumber (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
- price (Field3) — integer
PRODUCT_PART (Untitled4)
- partID (Key) — integer — 외래 키 → PART.partID — NOT NULL
- modelNumber (Key2) — char(30) — 외래 키 → PRODUCT.modelNumber — NOT NULL
- quantity (Field) — integer(10)
SUPPLIER (Untitled)
- suplierID (Key) — integer(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- phone (Field2) — char(30)
- email (Field3) — char(40)
- address (Field4) — char(50)
- description (Field5) — text
- grade (Field6) — integer(1)