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