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)