test
Tables (5)
Untitled (회원)
- Key (화원아이디) — Primary key — NOT NULL
- Field (비밀번호)
- Field (이름)
- Field (직업)
- Field (나이)
- Field (정립급)
- Field (등급)
Untitled (상품)
- Key (상품번호) — Primary key — NOT NULL
- Field (상품명)
- Field2 (재고량)
- Field (단가)
Untitled (주문)
- Field (주문번호)
- Field (주문수량)
- Field (배송지)
- Field (주문일자)
- Key (화원아이디) — Foreign key → Untitled.Key — NOT NULL
- Key (상품번호) — Foreign key → Untitled.Key — NOT NULL
Untitled (제조업체)
- Key (제조업체명) — Primary key — NOT NULL
- Field (전화번호)
- Field (위치)
- Field (담당자 정보)
Untitled (공급)
- Field (공급일자)
- Field (공급량)
- Key (제조업체명) — Foreign key → Untitled.Key — NOT NULL
- Key (상품번호) — Foreign key → Untitled.Key — NOT NULL