ecommerce

Tables (6)

Address (Untitled3)

  • user_key (Key) — Foreign key → User.user_key — NOT NULL
  • address_number (우편번호) — VARCHAR(20)
  • address (주소) — VARCHAR(50)
  • address_detail (상세주소) — VARCHAR(50)

Cart (Untitled6)

  • Key — Primary key — NOT NULL

Order (Untitled4)

  • order_number (주문번호) — INT — Primary key — NOT NULL
  • user_key (Key) — Foreign key → User.user_key — NOT NULL
  • order_date (주문날짜) — DATETIME
  • address_number (우편번호) — VARCHAR(20)
  • address (주소) — VARCHAR(50)
  • address_detail (상세주소) — VARCHAR(50)
  • receiver_name (수령자 이름) — VARCHAR(20)
  • receiver_phone (수령자 전화번호) — VARCHAR(20)

Order_detail (Untitled5)

  • order_detail_number (주문상세번호) — INT — Primary key — NOT NULL
  • order_number (주문번호) — INT — Foreign key → Order.order_number — NOT NULL
  • product_number (상품번호) — INT — Foreign key → product.product_number — NOT NULL — AUTO_INCREMENT
  • product_count (수량(개수)) — INT
  • product_price (가격) — INT
  • order_detail_status (처리상태) — VARCHAR(10)
  • refund_check (환불가능여부VARCHAR(30)) — VARCHAR(1)
  • Field

User (Untitled2)

  • user_key (Key) — Primary key — NOT NULL — AIUTO INCREMENT
  • user_id (아이디) — VARCHAR(30)
  • user_pwd (패스워드) — VARCHAR(50)
  • user_name (이름) — VARCHAR(20)
  • user_phone (전화번호) — VARCHAR(20)
  • user_email (이메일) — VARCHAR(30)
  • user_nickname (닉네임) — VARCHAR(20)
  • user_profile (프로필사진) — VARCHAR(100)
  • user_grade (등급) — VARCHAR(10)
  • user_insertdate (가입날짜) — DATETIME

product (Untitled)

  • product_number (상품번호) — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • category_code (카테고리) — varchar(30)
  • product_name (상품명) — VARCHAR(50)
  • product_price (가격) — INT
  • product_stock (수량(재고)) — INT
  • product_desc (설명) — TEXT
  • product_date (등록날짜) — DATETIME
  • product_hits (조회수) — INT