getum

Tables (6)

Delivery (배송)

  • delivery_id (배송번호) — INT — Primary key — NOT NULL
  • delivery_addr (배송주소) — VARCHAR(50)
  • delivery_status (배송상태(준비, 배송완료)) — VARCHAR(10)

Member (회원)

  • member_email (회원 이메일) — VARCHAR(300) — Primary key
  • member_pw (회원비밀번호) — VARCHAR(50) — NOT NULL
  • member_name (회원이름) — VARCHAR(30) — NOT NULL
  • member_tel (회원전화번호) — VARCHAR(15) — NOT NULL
  • member_addr (회원 주소) — VARCHAR(300) — NOT NULL
  • reg_date (가입 날짜) — TIMESTAMP — NOT NULL

order (주문)

  • order_id (주문자번호) — INT — Primary key — NOT NULL
  • member_email (회원 이메일) — VARCHAR(300) — Foreign key → Member.member_email
  • order_name (주문자 이름) — VARCHAR(20)
  • order_tel (주문자 전화번호) — VARCHAR(15)
  • order_addr (배송 주소) — VARCHAR(50)
  • order_status (주문 상태(주문/취소)) — VARCHAR(10)
  • quantity (수량) — INT
  • reg_date (주문 날짜) — TIMESTAMP

orderProduct (주문상품)

  • orderProduct_id (주문상품번호) — INT — Primary key — NOT NULL
  • order_id (주문자번호) — INT — Foreign key → order.order_id — NOT NULL
  • product_id (상품번호2) — INT — Foreign key → product.product_id — NOT NULL
  • member_email (회원 이메일) — VARCHAR(300) — Foreign key → order.member_email
  • order_count (주문 수량) — INT
  • order_price (주문 금액) — INT

product (상품)

  • product_id (상품번호) — INT — Primary key — NOT NULL
  • product_nm (상품이름) — VARCHAR(20) — NOT NULL
  • product_detail (상품 상세 정보) — TEXT
  • price (상품 가격) — INT — NOT NULL
  • stock (상품 수량) — INT — NOT NULL
  • product_reg (상품 등록 날짜) — TIMESTAMP — NOT NULL
  • product_img (상품이미지) — VARCHAR(50)

review (리뷰)

  • review_id (리뷰번호) — INT — Primary key — NOT NULL
  • product_id (상품번호) — INT — Foreign key → product.product_id — NOT NULL
  • member_email (회원 이메일) — VARCHAR(300) — Foreign key → Member.member_email
  • review_contents (리뷰 내용) — VARCHART(200)
  • review_img (리뷰 이미지) — VARCHAR(40)
  • review_like (좋아요) — INT
  • review_count (조회수) — INT
  • reg_date (작성날짜) — TIMESTAMP
  • modified_date (수정날짜) — TIMESTAMP