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