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