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