Reebook
Tables (5)
Additional Material (참고자료)
- bid (도서번호) — Int — Foreign key → Book.id — NOT NULL
- lid (강의번호) — int — Foreign key → Lecture.id — NOT NULL
- lid (Field2) — int
- kind (Field3) — char(10)
- Field4
Book (교재)
- id (도서번호) — Int — Primary key — NOT NULL
- lid (강의번호) — int — Foreign key → Lecture.id — NOT NULL
- title (Field) — char(20)
- author (Field2) — char(10)
- publisher (Field3) — char(10)
- Field4
Lecture (Untitled4)
- id (강의번호) — int — Primary key — NOT NULL
- professer (Field)
Rent (대여)
- id (대여번호) — int — Primary key — NOT NULL
- bid (도서번호) — Int — Foreign key → Book.id — NOT NULL
- uid (학번) — int — Foreign key → User.sn — NOT NULL
- s_date (Field3) — date
- r_date (Field4) — date
- d_line (Field5) — date
- Field6
User (Untitled2)
- sn (학번) — int — Primary key — NOT NULL
- name (Field) — char(10)
- Field3