livro-s
Tables (4)
Book
- id — String(10) — Primary key — NOT NULL
- title — String(50)
- author — String(50)
- publisher — String(50)
- category — String(10)
- location — String(40)
- image — String(200)
- school — String(20)
Loan
- uuid — String(50) — Primary key — NOT NULL
- user_uuid (userUuid) — String(50) — Foreign key → User.uuid — NOT NULL
- bookId — String(10) — Foreign key → Book.id — NOT NULL
- school — String(20)
- created_at (createdAt) — String(30)
- deleted_at (deletedAt) — String(30)
Notice
- uuid — String(50) — Primary key — NOT NULL
- title — String(50)
- content — String(500)
- user_uuid (userUuid) — String(50) — Foreign key → User.uuid — NOT NULL
- school — String(20)
- created_at (createdAt) — Date
User
- uuid — String(50) — Primary key — NOT NULL
- userId — String(30)
- password — String(100)
- name — String(10)
- school — String(20)
- student_no (studentNo) — String(20)
- admin — Bool