databaseDiagram
Tables (5)
adminaccounts
- id — NUMBER(38) — NOT NULL
- email — VARCHAR2(30) — NOT NULL
- password — VARCHAR2(30) — NOT NULL
bookinfomation
- title — VARCHAR2(255) — NOT NULL
- isbn — VARCHAR2(255) — NOT NULL
- author — VARCHAR2(255) — NOT NULL
- publisher — VARCHAR2(255) — NOT NULL
- categories — VARCHAR2(255) — NOT NULL
- subCategories — VARCHAR2(255) — NOT NULL
- year — NUMBER(38) — NOT NULL
- total — NUMBER(38) — NOT NULL
issuedbooksinfomation
- issueCode — VARCHAR2(255) — NOT NULL
- issuedUserName — VARCHAR2(255) — NOT NULL
- issuedUserEmail — VARCHAR2(255) — NOT NULL
- bookTitle — VARCHAR2(255) — NOT NULL
- ISBN — VARCHAR2(255) — NOT NULL
- phoneNumber — VARCHAR2(255) — NOT NULL
- issueDate — DATE
- returnDate — DATE
overdue
- overdueIssueCode — VARCHAR2(255) — NOT NULL
- overdueIssueUserEmail — VARCHAR2(255) — NOT NULL
- overdueIssueUserName — VARCHAR2(255) — NOT NULL
- overdueIssuedBookTitle — VARCHAR2(255) — NOT NULL
- isbn — VARCHAR2(255) — NOT NULL
- overduePhoneNumber — VARCHAR2(255) — NOT NULL
- overdueReturnDate — DATE — NOT NULL
useraccounts
- userName — VARCHAR2(255) — NOT NULL
- userEmail — VARCHAR2(255) — NOT NULL
- password — VARCHAR2(255) — NOT NULL
- gender — VARCHAR2(255) — NOT NULL
- phoneNumber — VARCHAR2(255) — NOT NULL
- address — VARCHAR2(255)