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