rental system

Tables (4)

Admins (관리자)

  • admin_id (Key) — varchar(10) — Primary key — NOT NULL
  • admin_pw (Field) — varchar(50)
  • admin_key (Field2) — varchar(50)

Products (물품)

  • product_id (Key) — int — Primary key — NOT NULL
  • product_name (Field) — varchar(20)
  • product_ quantity (Field2) — int
  • product_status (Field5) — Y / N

Rentals (대여)

  • rental_id (Key) — int — Primary key — NOT NULL
  • stuednt_id (Key2) — varchar(7) — Foreign key → Students.stuednt_id — NOT NULL
  • product_id (Key3) — int — Foreign key → Products.product_id — NOT NULL
  • rental_rentaltime (Field3) — datetime
  • rental_returntime (Field4) — datetime
  • createdAt (Field) — datetime

Students (학생)

  • stuednt_id (Key) — varchar(7) — Primary key — NOT NULL
  • student_name (Field) — varchar(50)
  • student_pw (Field2) — varchar(100)
  • student_year (Field3) — varchar(2)
  • student_grade (Field4) — varchar(1)
  • student_class (Field5) — varchar(2)
  • student_num (Field6) — varchar(2)
  • student_status (Field7) — Y / N