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)