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