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