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)