도서공유시스템2
테이블 (8)
address
- address_id — INT — 기본 키 — NOT NULL
- address_postnum — INT — NOT NULL
- address_basicaddress — VARCHAR(45) — NOT NULL
- address_detailaddress — VARCHAR(45) — NOT NULL
- user_user_id — VARCHAR(45) — 외래 키 → user.user_id — NOT NULL
- INDEX — `fk_address_user1_idx`
basket
- basket_id — INT — 기본 키 — NOT NULL
- basket_createdate — VARCHAR(45) — NOT NULL
- user_user_id — VARCHAR(45) — 외래 키 → user.user_id — NOT NULL
- INDEX — `fk_basket_user1_idx`
basket_list
- basket_basket_id — INT — 외래 키 → basket.basket_id — NOT NULL
- book_book_id — INT — 외래 키 → book.book_id — NOT NULL
- book_count — INT — NOT NULL
- book_price — INT — NOT NULL
- INDEX — `fk_basket_list_book1_idx`
book
- book_id — INT — 기본 키 — NOT NULL
- book_name — VARCHAR(45) — NOT NULL
- book_count — INT — NOT NULL
- book_price — INT — NOT NULL
card
- card_id — INT — 기본 키 — NOT NULL
- card_num — INT — NOT NULL
- card_date — VARCHAR(45) — NOT NULL
- card_type — VARCHAR(45) — NOT NULL
- user_user_id — VARCHAR(45) — 외래 키 → user.user_id — NOT NULL
- INDEX — `fk_card_user1_idx`
order
- order_id — INT — 기본 키 — NOT NULL
- order_price — INT — NOT NULL
- order_date — DATE — NOT NULL
- order_card_type — VARCHAR(45) — NOT NULL
- order_card_num — VARCHAR(45) — NOT NULL
- order_card_date — VARCHAR(45) — NOT NULL
- order_postnum — INT — NOT NULL
- order_basicaddress — VARCHAR(45) — NOT NULL
- order_detailaddress — VARCHAR(45) — NOT NULL
- user_user_id — VARCHAR(45) — 외래 키 → user.user_id — NOT NULL
- INDEX — `fk_order_user1_idx`
order_has_book
- order_order_id — INT — 외래 키 → order.order_id — NOT NULL
- book_book_id — INT — 외래 키 → book.book_id — NOT NULL
- book_count — INT
- INDEX — `fk_order_has_book_book1_idx`
- INDEX — `fk_order_has_book_order1_idx`
user
- user_id — VARCHAR(45) — 기본 키 — NOT NULL
- user_pw — VARCHAR(45) — NOT NULL
- user_name — VARCHAR(45) — NOT NULL