HanaNew2
Tables (5)
books
- book_id — BIGINT — Primary key — NOT NULL
- book_name — VARCHAR
- book_type — ENUM
- create_at — TIMESTAMP
histories
- history_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- book_id — BIGINT — Foreign key → books.book_id — NOT NULL
- create_at — TIMESTAMP
- return_at — TIMESTAMP
point_histories
- point_history_id — BIGINT — Primary key — NOT NULL
- point_amt — BIGINT
- type — ENUM
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
user_book
- user_book_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- book_id — BIGINT — Foreign key → books.book_id — NOT NULL
- create_at — TIMESTAMP
- type — enum
users
- user_id — BIGINT — Primary key — NOT NULL
- user_name — VARCHAR
- create_at — TIMESTAMP
- platform — VARCHAR
- point (Field) — BIGINT