FinalProject
Tables (7)
ADDRESS (Untitled5)
- zipCode (Key) — char(5) — Primary key — NOT NULL
- address (Field) — char(50)
- address2 (Field2) — char(30)
AUTHOR (Untitled6)
- authorID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(30)
- description (Field2) — char(50)
BOOK (Untitled3)
- bookNO (Key) — char(10) — Primary key — NOT NULL
- title (Field) — char(50)
- pubYMD (Field2) — date
- publisher (Field3) — char(20)
- ISBN (Field4) — char(13)
- price (Field5) — int(6)
BOOK_AUTHOR (Untitled7)
- bookNO (Key) — char(10) — Foreign key → BOOK.bookNO — NOT NULL
- authorID (Key2) — char(10) — Foreign key → AUTHOR.authorID — NOT NULL
BOOK_RENT (Untitled2)
- rentNO (Key) — char(10) — Primary key — NOT NULL
- rentDate (Field) — date
- returnDate (Field2) — date
- userID (Key2) — char(10) — Foreign key → LIBUSER.userID — NOT NULL
- bookNO (Key3) — char(10) — Foreign key → BOOK.bookNO — NOT NULL
BOOK_REQUEST (Untitled4)
- requestNO (Key) — char(10) — Primary key — NOT NULL
- userID (Key2) — char(10) — Foreign key → LIBUSER.userID — NOT NULL
- bookNO (Key3) — char(10) — Foreign key → BOOK.bookNO — NOT NULL
- requestDate — date
LIBUSER (Untitled)
- userID (Key) — char(10) — Primary key — NOT NULL
- uesrName (Field) — char(20)
- gender (Field2) — char(1)
- enrollYMD (Field3) — date
- userType (Field4) — char(1)
- zipCode (Key2) — char(5) — Foreign key → ADDRESS.zipCode — NOT NULL