도서공유시스템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