jihoon

Tables (7)

Bee_Discount (할인)

  • 할인번호 (discount_no) — NUMBER — Primary key — NOT NULL
  • 상품번호 (product_no) — NUMBER — Primary key — NOT NULL
  • 할인비율 (discount_rate) — NUMBER — NOT NULL
  • 할인시작일 (discount_begindate) — Date — NOT NULL
  • 할인마감일 (discount_enddate) — NUMBER

Bee_ProductImage (상품이미지)

  • 상품이미지번호 (productimage_no) — NUMBER — Primary key — NOT NULL
  • 상품번호 (product_no) — NUMBER — NOT NULL
  • 상품이미지위치 (productimage_location) — ? — NOT NULL
  • 상품기존파일이름 (productimage_orifilename) — VARCHAR2

Bee_customer

  • customer_no — NUMBER
  • customergrade_no — NUMBER
  • customer_id — VARCHAR2(20)
  • customer_pw — VARCHAR2(40)
  • customer_name — VARCHAR2(30)
  • customer_birth — DATE
  • customer_gender — VARCHAR2(2)
  • customer_address — VARCHAR2(40)
  • customer_email — VARCHAR2(40)
  • customer_phone — VARCHAR2(40)
  • customer_point — VARCHAR2(20)
  • customer_signup — DATE

Copy Of Bee_ProductImage (CopyOf상품이미지)

  • 상품이미지번호 (productimage_no) — NUMBER — Primary key — NOT NULL
  • 상품번호 (product_no) — NUMBER — NOT NULL
  • 상품이미지위치 (productimage_location) — ? — NOT NULL
  • 상품기존파일이름 (productimage_orifilename) — VARCHAR2

Copy Of Bee_ProductImage2 (CopyOf상품이미지2)

  • 상품이미지번호 (productimage_no) — NUMBER — Primary key — NOT NULL
  • 상품번호 (product_no) — NUMBER — NOT NULL
  • 상품이미지위치 (productimage_location) — ? — NOT NULL
  • 상품기존파일이름 (productimage_orifilename) — VARCHAR2

Untitled

  • 장바구니번호 (cart_no) — NUMBER — Primary key — NOT NULL
  • Field
  • Field2

Untitled2