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)