Toy1

테이블 (18)

Cancellation(취소) (Untitled8)

  • cancellation_receipt_number (취소접수번호) — 기본 키 — NOT NULL
  • cancellation_id (취소아이디)
  • cancellation_date (취소날짜)
  • cancellation_status (취소처리상태)
  • cancellation_request_date (취소신청일시)
  • cancellation_completion_date (취소완료일시)
  • cancellation_reason (취소사유)
  • order_number (주문번호)

Category(카테고리) (Untitled18)

  • category_name (카테고리이름) — 기본 키 — NOT NULL
  • category_gender (카테고리성별)
  • category_type (카테고리타입)

Customer(고객) (Untitled)

  • user_id (고객아이디) — 기본 키 — NOT NULL
  • user_name (고객이름)
  • user_password (고객비밀번호)
  • user_phone_number (고객전화번호)
  • user_address (고객주소)
  • payment_method (결제수단)
  • birth_name (생년월일)

Customer_page(고객페이지) (Untitled16)

  • nickname (닉네임) — 기본 키 — NOT NULL
  • membership_level (회원등급)
  • coupon (쿠폰)
  • reward_points (적립금)
  • favorite_brand (즐겨찾기브랜드)
  • recently_viewed_product (최근본상품)
  • payment_method (결제수단)
  • written_reviews (작성후기)
  • order_history (주문내역)
  • history (이력)
  • user_id (고객아이디)

Customer_support(고객센터) (Untitled7)

  • post_number (게시글번호) — 기본 키 — NOT NULL
  • author (작성자)
  • post (게시글)
  • inquiry_type (문의유형)
  • inquiry_content (문의내용)
  • inquiry_photo (문의사진)
  • processed_inquiries (처리완료건)
  • unprocessed_inquiries (미처리건)
  • employee_code (담당자코드)

Delivery(배송) (Untitled2)

  • tracking_number (송장번호) — 기본 키 — NOT NULL
  • order_id (주문고객아이디)
  • order_name (주문고객이름)
  • order_number (주문번호)
  • order_date (주문일자)
  • product_name (상품명)
  • shipping_company (택배사)
  • delivery_status (배송상태)
  • Fielddelivery_status_detail (배송현황)
  • delivery_agent (담당기사)

Employee(담당자) (Untitled17)

  • employee_code (담당자코드) — 기본 키 — NOT NULL
  • employee_id (담당자아이디)
  • employee_name (담당자이름)
  • employee_phone_number (담당자전화번호)
  • employee_position (담당자직책)
  • employee_department_id (담당자부서)

Exchange(교환) (Untitled9)

  • exchange_receipt_number (교환접수번호) — 기본 키 — NOT NULL
  • exchange_id (교환아이디)
  • exchange_date (교환날짜)
  • exchange_status (교환처리상태)
  • exchange_request_date (교환신청일시)
  • exchange_completion_date (교환완료일시)
  • exchange_reason (교환사유)
  • order_number (주문번호)

History(이력) (Untitled15)

  • history_number (이력번호) — 기본 키 — NOT NULL
  • order_history (주문이력)
  • shipment_history (배송이력)
  • payment_history (결제이력)
  • customer_registration_history (회원가입이력)
  • return_history (반품이력)
  • exchange_history (교환이력)
  • cancellation_history (취소이력)

Notice(공지사항) (Untitled11)

  • notice_number (공지사항번호) — 기본 키 — NOT NULL
  • notice_title (공지사항제목)
  • notice_date (공지사항날짜)
  • notice_content (공지사항내용)
  • notice_emplpy_code (공지사항담당자코드)
  • view_count (조회수)

Order(주문) (Untitled3)

  • order_number (주문번호) — 기본 키 — NOT NULL
  • user_id (고객아이디)
  • customer_name (주문자이름)
  • customer_address (주문고객주소)
  • order_date (주문일자)
  • product_name (주문상품명)
  • payment_details (결제정보)
  • payment_method (결제수단)
  • payment_status (결제상태)
  • order_discount_rate (주문할인율)
  • total_payment_amount (총결제금액)
  • actual_payment_amount (실결제금액)

Payment(결제) (Untitled13)

  • payment_amount (결제금액) — 기본 키 — NOT NULL
  • payment_id (결제아이디)
  • payer_name (결제자이름)
  • payment_method (결제수단)
  • payment_date (결제날짜)
  • payment_product (결제상품)

Product(상품) (Untitled4)

  • product_number (상품번호) — 기본 키 — NOT NULL
  • product_namet (상품이름)
  • product_image (상품사진)
  • product_quantity (상품수량)
  • product_price (상품가격)
  • product_amount (상품총금액)
  • product_description (상품설명)
  • product_category (상품카테고리)
  • product_type (상품종류)
  • product_post_date (상품게시일)
  • product_discount_rate (상품할인율)
  • discount_start_date (상품할인시작일)
  • discount_end_date (상품할인종료일)

Product_Review(상품후기) (Untitled10)

  • review_number (후기번호) — 기본 키 — NOT NULL
  • review_user_id (후기작성아이디)
  • product_review (상품후기내용)
  • review_date (후기작성날짜)
  • review_image (후기사진)

Refund(환불) (Untitled5)

  • refund_receipt_number (환불접수번호) — 기본 키 — NOT NULL
  • refund_id (환불아이디)
  • refund_date (환불날짜)
  • refund_status (환불처리상태)
  • refund_request_date (환불신청일시)
  • refund_completion_date (환불완료일시)
  • refund_reason (환불사유)
  • order_number (주문번호)

Registration(회원가입) (Untitled6)

  • birth_number (생년월일) — 기본 키 — NOT NULL
  • name (이름)
  • phone_number (전화번호)
  • gender (성별)
  • verification_code (인증번호)
  • user_id (사용자아이디)
  • user_password (사용자비밀번호)
  • user_address (사용자주소)

Status(상태) (Untitled14)

  • status_number (상태번호) — 기본 키 — NOT NULL
  • status_name (상태이름)
  • status_description (상태설명)
  • status_type (상태유형)

Tier(등급) (Untitled12)

  • tier_level (등급단계) — 기본 키 — NOT NULL
  • tier_criteria (등급기준)
  • tier_period (등급산정기간)
  • tier_criteria_amount (등급기준금액)
  • tier_benefits (등급혜택)
  • tier_conditions (등급유의사항)