3rd_Library

Tables (4)

Books (Untitled)

  • ID (Key) — varchar(50) — Primary key — NOT NULL
  • Title (Field) — varchar(100)
  • Author (Field2) — varchar(50)
  • Publisher (Field3) — varchar(50)
  • Price (Field4) — varchar(50)
  • Quantity (Field5) — int
  • Isbn (Field6) — varchar(50)
  • ReleaseDate (Field7) — varchar(50)
  • Information (Field8) — text

Logs (Untitled4)

  • ID (Key) — int — Primary key — NOT NULL
  • Timestamp (Field) — datetime
  • name (Field2) — varchar(50)
  • message (Field3) — varchar(100)
  • action (Field4) — varchar(100)

Rentals (Untitled3)

  • RentalId (Key) — int — Primary key — NOT NULL
  • UserId (Field) — varchar(50)
  • BookId (Field2) — varchar(50)
  • RentalDate (Field3) — dateTime
  • DueDate (Field4) — dateTime
  • ReturnDate (Field5) — dateTime

Users (Untitled2)

  • ID (Key) — varchar(50) — Primary key — NOT NULL
  • PW (Field) — varchar(50)
  • Name (Field2) — varchar(50)
  • Age (Field3) — varchar(50)
  • Phone (Field4) — varchar(50)
  • Address (Field5) — varchar(100)