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)