libra
Tables (4)
Admin
- admin_number — int — Primary key — NOT NULL
- admin_id — varchar(30) — NOT NULL
- admin_pw — varchar(100) — NOT NULL
- salt — varchar(100) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
Book
- book_id (id) — int — Primary key — NOT NULL
- admin_number — int — Foreign key → Admin.admin_number — NOT NULL
- title — varchar(50) — NOT NULL
- book_state (state) — varchar(16) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
Rental
- rental_id (id) — int — Primary key — NOT NULL
- book_id — int — Foreign key → Book.book_id — NOT NULL
- user_id — varhcar(30) — Foreign key → User.user_id — NOT NULL
- rental_date — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
User
- user_id (id) — varhcar(30) — Primary key — NOT NULL
- user_name (name) — varchar(10) — NOT NULL
- course_name — varchar(30) — NOT NULL
- user_state — varchar(16) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL