payhere

Tables (3)

book

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL — auto increment
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • title — varchar(20) — NOT NULL
  • description — varchar(100) — NOT NULL
  • delete_flag — tinyint(1) — NOT NULL

book_record

  • id — bigint(20) — Primary key — NOT NULL
  • book_id — bigint(20) — Foreign key → book.id — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • amount — int(11)
  • description — varchar(30) — NOT NULL
  • delete_flag — tinyint(1) — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL — auto increment
  • password — varchar(128) — utf8mb4_unicode_ci
  • last_login — datetime(6) — NOT NULL
  • email — varchar(100) — 이메일로 로그인
  • is_active — tinyint(1)
  • is_superuser — tinyint(1)