library
Tables (3)
books (Untitled2)
- Key — int — Primary key — NOT NULL
- Key (Key2) — int — Foreign key → rental.Key — NOT NULL
- Key (Key22) — int — Foreign key → rental.Key — NOT NULL
- Key (Key222) — int — Foreign key → rental.Key — NOT NULL
- book_name (Field) — int
- author (Field2) — varchar(10)
- publisher (Field3) — varchar(30)
- published_date (Field4) — date
- ISBN (Field5) — varchar(30)
rental (Untitled3)
- Key — int — Primary key — NOT NULL
- Key (Key2) — int — Foreign key → books.Key — NOT NULL
- Key (Key22) — int — Foreign key → books.Key — NOT NULL
- book_id (Field) — int
- user_id (Field2) — int
- rent_date (Field3) — date
- Field4
users (Untitled)
- Key — int — Primary key — NOT NULL
- name (Field) — varchar(10)
- social_security_num (Field2) — long
- address (Field3) — long
- phone_num (Field4) — varchar(30)
- email (Field5) — varchar(30)
- password (Field6) — varchar(30)
- late_fee (Field7) — long