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