DB_Design

Tables (8)

address (주소)

  • address_id (Key) — Primary key — NOT NULL
  • zip_code (Field)
  • basic_address (Field2)
  • detail_address (Field3)
  • user_num (Key2) — Foreign key → user.user_num — NOT NULL

book (도서)

  • book_id (Key) — Primary key — NOT NULL
  • book_name (Field)
  • inventory (Field2)
  • price (Field3)

card (신용카드)

  • card_num (Field) — Primary key
  • card_exp (Field2)
  • card_type (Field3)
  • user_num (Key2) — Foreign key → user.user_num — NOT NULL

cart (장바구니)

  • cart_id (Key) — Primary key — NOT NULL
  • user_num (Key2) — Foreign key → user.user_num — NOT NULL
  • create_date (Field)

cart_list (장바구니 목록)

  • cart_list_id (Key) — Primary key — NOT NULL
  • quantity (Field)
  • book_id (Key2) — Foreign key → book.book_id — NOT NULL
  • cart_id (Key3) — Foreign key → cart.cart_id — NOT NULL

order (주문)

  • order_id (Key) — Primary key — NOT NULL
  • order_date (Field)
  • total_price (Field2)
  • card_num (Field3)
  • card_type (Field4)
  • card_exp (Field5)
  • zip_code (Field6)
  • basic_address (Field7)
  • detail_address (Field8)
  • user_num (Key2) — Foreign key → user.user_num — NOT NULL

order_list (주문상세)

  • order_list_id (Key) — Primary key — NOT NULL
  • book_id (Key2) — Foreign key → book.book_id — NOT NULL
  • quantity (Field)
  • order_id (Key3) — Foreign key → order.order_id — NOT NULL

user (회원)

  • user_num (Key) — Primary key — NOT NULL
  • user_id (Field)
  • password (Field2)
  • name (Field3)