shoppingmall_minyoung

Tables (13)

Cart (장바구니)

  • cart_number (장바구니번호) — int — Primary key — NOT NULL
  • product_numver (상품번호) — int — Foreign key → Product.product_numver — NOT NULL
  • cart_value (아이디 또는 비회원의 식별값) — varchar(30)
  • product_count (수량(개수)) — int

Deliver_address (배달직원이 지니고 있는 정보)

  • member_id (회원아이디) — varchar(30) — Foreign key → Member.member_id — NOT NULL
  • user_address1 (우편번호) — varchar(20)
  • user_address2 (주소) — varchar(50)
  • user_address3 (상세주소) — varchar(50)

Member (회원)

  • member_id (회원아이디) — varchar(30) — Primary key — NOT NULL
  • member_email (이메일) — varchar(30)
  • member_pw (비밀번호) — varchar(50)
  • member_name (이름) — varchar(20)
  • member_phone (전화번호) — varchar(50)
  • member_profile (프로필 사진) — varchar(100)
  • member_joindate (가입날짜) — DATETIME
  • admin (관리자권한)

MemberOrder_detail (회원 주문 상세)

  • morder_detail_number (주문상세번호) — int — Primary key — NOT NULL
  • morder_number (회원주문번호) — int — Foreign key → Member_Order.morder_number — NOT NULL
  • product_numver (상품번호) — int — Foreign key → Product.product_numver — NOT NULL
  • product_count (수량(개수)) — int
  • product_price (가격) — int
  • order_detail_status (처리상태) — varchar(10)
  • refund_check (환불가능여부) — varchar(1)

MemberOrder_refund (회원 주문 환불)

  • refund_number (환불번호) — int — Primary key — NOT NULL
  • morder_detail_number (주문상세번호) — int — Foreign key → MemberOrder_detail.morder_detail_number — NOT NULL
  • refund_reason (환불사유) — varchar(300)
  • refund_img (환불사유 사진) — varchar(300)
  • user_email (이메일) — varchar(50)

Member_Order (회원 주문)

  • morder_number (회원주문번호) — int — Primary key — NOT NULL
  • member_id (회원아이디) — varchar(30) — Foreign key → Member.member_id — NOT NULL
  • order_date (주문날짜) — DATETIME
  • address1 (배송지주소1(우편번호)) — varchar(20)
  • address2 (배송지주소2(주소)) — varchar(50)
  • address3 (배송지주소3(상세주소)) — varchar(50)
  • receiver_name (수령자 이름) — varchar(20)
  • receiver_phone (수령자 전화번호) — varchar(20)

Nonmember_order (비회원 주문)

  • order_number (주문번호) — int — Primary key — NOT NULL
  • order_date (주문날짜) — DATETIME
  • address1 (배송지주소1(우편번호)) — varchar(20)
  • address2 (배송지주소2(주소)) — varchar(50)
  • address3 (배송지주소3(상세주소)) — varchar(50)
  • receiver_name (수령자이름) — varchar(20)
  • receiver_phone (수령자전화번호) — varchar(20)

Product (상품)

  • product_numver (상품번호) — int — Primary key — NOT NULL
  • category_code (카테고리 코드) — varchar(30) — Foreign key → Product_category.category_code — NOT NULL
  • product_name (상품명) — varchar(50)
  • product_price (가격) — int
  • product_stock (수량) — int
  • product_desc (설명) — TEXT
  • product_date (등록날짜) — DATETIME
  • product_click (조회수) — int

Product_category (상품_카테고리)

  • category_code (카테고리 코드) — varchar(30) — Primary key — NOT NULL
  • category_name (이름) — varchar(50)
  • category_link_code (참조코드) — varchar(30)

Product_imageFile (상품 사진)

  • file_number (상품사진파일번호) — int — Primary key — NOT NULL
  • product_numver (상품번호) — int — Foreign key → Product.product_numver — NOT NULL
  • origin_file_name (원본파일이름) — varchar(300)
  • stored_file_name (서버에저장된파일이름) — varchar(300)
  • stored_thumbNail (썸네일 이미지) — varchar(300)
  • first_thumbNail (대표 썸네일 여부) — varchar(1)
  • file_size (파일 크기) — int
  • create_date (파일생성날짜) — DATETIME
  • delete_check (파일삭제여부) — varchar(1)

Product_review (상품리뷰)

  • Key (리뷰번호) — int — Primary key — NOT NULL
  • product_numver (상품번호) — int — Foreign key → Product.product_numver — NOT NULL
  • review_img (리뷰사진)

nonmember_refund (비회원 주문 환불)

  • refund_number (환불번호) — int — Primary key — NOT NULL
  • order_detail_number (주문상세번호) — int — Foreign key → nonmemberorder_detail.order_detail_number — NOT NULL
  • refund_reason (환불이유) — varchar(300)
  • refund_img (환불사유 사진) — varchar(300)
  • refund_email (이메일) — varchar(50)

nonmemberorder_detail (비회원 상세주문)

  • order_detail_number (주문상세번호) — int — Primary key — NOT NULL
  • order_number (주문번호) — int — Foreign key → Nonmember_order.order_number — NOT NULL
  • product_numver (상품번호) — int — Foreign key → Product.product_numver — NOT NULL
  • product_count (상품수량(개수)) — int
  • product_price (가격) — int
  • order_detail_status (처리상태) — varchar(10)
  • refund_check (환불가능여부) — varchar(1)