| id |
int(10)
|
|
|
|
| title |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| title_en |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| author |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| isbn |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| publisher |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| publish_year |
year(4)
|
|
|
|
| language |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| keywords |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| category_id |
int(10)
|
|
|
|
| koha_biblionumber |
int(10)
|
|
|
|
| koha_metadata_synced_at |
timestamp
|
|
|
|
| file_path |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| file_hash |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| file_size |
bigint(20)
|
|
|
|
| page_count |
int(10)
|
|
|
|
| thumbnail_path |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| access_level |
enum('public', 'students_only', 'restricted')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('pending_review', 'published', 'rejected', 'archived')
|
utf8mb4_unicode_ci
|
|
|
| uploaded_by |
int(10)
|
|
|
|
| reviewed_by |
int(10)
|
|
|
|
| reviewed_at |
timestamp
|
|
|
|
| rejection_reason |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| download_allowed |
tinyint(1)
|
|
|
|
| print_allowed |
tinyint(1)
|
|
|
|
| view_count |
int(10)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
