1
Tables (6)
BOOK (Untitled2)
- ID (PK) — CHAR(20) — Primary key — NOT NULL
- ISBN (FK) — NUMBER — Primary key — NOT NULL
- M_ID (FK1) — Foreign key → RENTAL.M_ID — NOT NULL
- B_ID (FK2) — Foreign key → RENTAL.B_ID — NOT NULL
- RENT_DATE (Key) — DATE — Foreign key → RENTAL.RENT_DATE — NOT NULL
- ID (PK2) — CHAR(20) — Foreign key → RENTAL.ID — NOT NULL
- M_ID (FK12) — Foreign key → RESERVE.M_ID — NOT NULL
- B_ID (FK22) — Foreign key → RESERVE.B_ID — NOT NULL
- AVAILABLE (Field) — NUMBER
BOOKINFO (Untitled5)
- ISBN (PK) — NUMBER — Primary key — NOT NULL
- NAME (Field) — VARCHAR(20)
- AUTHOR (Field2) — VARCHAR(10)
- PUBLISHER (Field3) — VARCHAR(10)
- RECEIVE_DATE (Field4) — DATE
BOOKLOCATION (Untitled6)
- ISBN (FK) — NUMBER — Primary key — NOT NULL
- LOCATION (Key) — VARCHAR(20) — Primary key — NOT NULL
MEMBER (Untitled)
- ID (PK) — CHAR(20) — Primary key — NOT NULL
- NAME (Field) — VARCHAR(10)
- PHONENUMBER (Field2) — NUMBER
- BIRTH_DATE (Field3) — DATE
- REGISTER_DATE (Field4) — DATE
RENTAL (Untitled3)
- M_ID (FK1) — Primary key — NOT NULL
- B_ID (FK2) — Primary key — NOT NULL
- RENT_DATE (Key) — DATE — Primary key — NOT NULL
- ID (PK) — CHAR(20) — Foreign key → MEMBER.ID — NOT NULL
- RETURN_DATE (Field2) — DATE
RESERVE (Untitled4)
- M_ID (FK1) — Primary key — NOT NULL
- B_ID (FK2) — Primary key — NOT NULL
- RESERVEDATE (Field) — DATE
- ID (PK) — CHAR(20) — Foreign key → MEMBER.ID — NOT NULL