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