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)