book0.1

Tables (8)

address

  • address_id — INT — Primary key — NOT NULL
  • address_number — VARCHAR(45)
  • address_basic — VARCHAR(45)
  • address_detail — VARCHAR(45)
  • users_users_id — INT — Foreign key → users.users_id — NOT NULL
  • INDEX — `fk_address_users1_idx`

backet

  • backet_id — INT — Primary key — NOT NULL
  • backet_date — VARCHAR(45)
  • users_users_id — INT — Foreign key → users.users_id — NOT NULL
  • INDEX — `fk_backet_users1_idx`

backet_has_book

  • backet_backet_id — INT — Foreign key → backet.backet_id — NOT NULL
  • book_book_id — INT — Foreign key → book.book_id — NOT NULL
  • INDEX — `fk_backet_has_book_book1_idx`
  • INDEX — `fk_backet_has_book_backet1_idx`

book

  • book_id — INT — Primary key — NOT NULL
  • book_name — VARCHAR(45)
  • book_count — INT
  • book_quantity — INT

card

  • card_id — INT — Primary key — NOT NULL
  • card_date — INT
  • card_kind — VARCHAR(45)
  • users_users_id — INT — Foreign key → users.users_id — NOT NULL
  • INDEX — `fk_card_users_idx`

order

  • order_id — INT — Primary key — NOT NULL
  • order_count — INT
  • order_date — VARCHAR(45)
  • card_kind — VARCHAR(45)
  • card_number — INT
  • address_number — VARCHAR(45)
  • address_basic — VARCHAR(45)
  • address_detail — VARCHAR(45)
  • users_users_id — INT — Foreign key → users.users_id — NOT NULL
  • INDEX — `fk_order_users1_idx`

order_has_book

  • book_book_id — INT — Foreign key → book.book_id — NOT NULL
  • order_order_id — INT — Foreign key → order.order_id — NOT NULL
  • INDEX — `fk_order_has_book_book1_idx`
  • INDEX — `fk_order_has_book_order1_idx`

users

  • users_id — INT — Primary key — NOT NULL
  • users_pwd — VARCHAR(45)
  • users_name — VARCHAR(45)
  • users_birth — VARCHAR(45)