ERD

Tables (6)

Buyer (거래처정보)

  • BUYER_ID (거래처코드) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Buyprod (입고상품정보)

  • Key — Primary key — NOT NULL
  • Key (Key22) — Foreign key → Prod.PROD_BUYER — NOT NULL
  • BUY_PROD (상품코드) — varchar2(10) — Foreign key → Prod.PROD_ID — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Cart (장바구니(주문내역))

  • CART_MEMBER (회원 ID) — varchar2(15) — Foreign key → Member.MEM_ID
  • CART_NO (주문번호) — char(13) — Foreign key → Prod.PROD_BUYER — NOT NULL
  • CART_PROD (상품코드) — varchar2(10) — Foreign key → Prod.PROD_ID — NOT NULL
  • CART_QTY (Field4)

Lprod (상품분류정보)

  • LPROD_GU (상품분류코드) — char(4) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Member (회원정보)

  • MEM_ID (회원 ID) — varchar2(15) — Primary key
  • MEM_PASS (비밀번호) — varchar2(15)
  • MEM_NAME (성명) — varchar2(20)
  • MEM_REGNO1 (주민등록번호 앞 6자리) — char(6)
  • MEM_REGNO2 (주민등록번호 뒤 7자리) — char(7)
  • MEM_BIR (생일) — date
  • MEM_ZIP (우편번호) — char(7)
  • MEM_ADD1 (주소1) — varchar2(100)
  • MEM_ADD2 (주소2) — varchar2(80)
  • MEM_HOMETEL (집전화번호) — varchar2(14)
  • MEM_COMTEL (회사전화번호) — varchar2(14)
  • MEM_HP (이동전화) — varchar2(15)
  • MEM_MAIL (E-Mail주소) — varchar2(60)
  • MEM_JOB (직업) — varchar2(40)
  • MEM_LIKE (취미) — varchar2(40)
  • MEM_MEMORIAL (기념일명) — varchar2(40)
  • MEM_MEMORIALDAY (기념일날짜) — date
  • MEM_MILEAGE (마일리지) — number(10)
  • MEM_DELETE (삭제여부) — varchar2(1)

Prod (상품정보)

  • PROD_BUYER (공급업체(코드)) — char(6) — Foreign key → Buyer.BUYER_ID — NOT NULL
  • PROD_ID (상품코드) — varchar2(10) — Foreign key → Lprod.LPROD_GU — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4