outlier

Tables (5)

BUY

  • 주문번호 (buyId) — INT — Primary key — NOT NULL
  • 주문날짜 (buy_date) — DATE
  • 주문상태 (buy_state) — SET(BUY,READY,DEPART,ARRIVE)
  • 고객번호 (empno) — INT — Foreign key → employee.고객번호 — NOT NULL

BUY_GOODS

  • 주문번호 (buyId) — INT — Foreign key → BUY.주문번호 — NOT NULL
  • 상품ID (goodId) — INT — Foreign key → Goods.상품ID — NOT NULL
  • 주문개수 (buynum) — INT

CART

  • 장바구니ID (cartId) — INT — Primary key — NOT NULL
  • 담은날짜 (cart_date) — SET
  • 고객번호 (empno) — INT — Foreign key → employee.고객번호 — NOT NULL
  • 상품ID (goodId) — INT — Foreign key → Goods.상품ID — NOT NULL

Goods

  • 상품ID (goodId) — INT — Primary key — NOT NULL
  • 상품이름 (good_name) — VARCHAR(100) — NOT NULL
  • 상품설명 (good_desc) — VARCHAR(300) — NOT NULL
  • 상품가격 (good_price) — INT
  • 상품상태 (good_state) — SET

employee

  • 고객번호 (empno) — INT — Primary key — NOT NULL
  • 권한 (deptno) — SET(CLIENT,MANAGER) — NOT NULL
  • 고객이름 (empname) — VARCHAR(100)
  • 상세주소 (address_detail) — VARCHAR(100)
  • 일반주소 (address) — VARCHAR(255)
  • 생년원일 (birthdate) — DATE