mall
Tables (5)
Product (Untitled)
- product_number (상품번호) — INT — Primary key — NOT NULL
- product_name (상품명) — VARCHAR(50)
- product_price (가격) — INT
- product_stack (수량(재고)) — INT
- product_desc (설명) — TEXT
- product_date (등록날짜)
Product_category (Untitled5)
- category_code (카테고리코드) — VARCHAR(30) — Primary key — NOT NULL
- product_number (상품번호) — INT — Foreign key → Product.product_number — NOT NULL
- category_name (이름) — VARCHAR(30)
User (Untitled2)
- user_id (아이디) — VARCHAR(30) — Primary key — NOT NULL
- user_pwd (패스워드) — VARCHAR(50)
- user_phone (전화번호) — VARCHAR(30)
- user_email (이메일) — VARCHAR(50)
- user_role (유저 권한) — INT
- user_insertdate (가입날짜) — DATETIME
UserOrder_detail (Untitled4)
- order_detail_number (주문상세번호) — INT — Primary key — NOT NULL
- order_number (주문번호) — INT — Foreign key → User_Order.order_number — NOT NULL
- product_number (상품번호) — INT — Foreign key → Product.product_number — NOT NULL
- product_count (수량(개수)) — INT
- product_count (가격) — INT
User_Order (Untitled3)
- order_number (주문번호) — INT — Primary key — NOT NULL
- user_id (아이디) — VARCHAR(30) — Foreign key → User.user_id — NOT NULL
- order_date (주문날짜) — DATETIME
- address (배송지주소) — VARCHAR(20)
- receiver_name (수령자이름) — VARCHAR(20)
- receiver_phone (수령자 전화번호) — VARCHAR(20)