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 (등급유의사항)