1

Tables (4)

Book (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL — 도서ID
  • title (Field) — string — 제목
  • author (Field2)
  • publisher (Field3)
  • publish_year (Field4)
  • classfication_name (Field5)

BookInfo (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL — 재고ID
  • id (Key2) — bigint — Foreign key → Book.id — NOT NULL — 도서ID
  • isbn (Key3) — VARCHAR2(13) — NOT NULL — ISBN
  • status (Key4) — enum — NOT NULL — 재고상태

Rent (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL — 대여ID
  • id (Key2) — bigint — Foreign key → User.id — NOT NULL — 회원ID
  • id (Key3) — bigint — Foreign key → BookInfo.id — NOT NULL — 재고ID
  • id (Key22) — bigint — Foreign key → BookInfo.id — NOT NULL — 도서ID
  • rent_date (Field) — DATETIME — 대여일
  • return_date (Field2) — DATETIME — 반납예정일
  • overdue_start_date (Field4) — DATETIME — 연체시작일
  • overdue_end_date (Field5) — 연체종료일
  • status (Field3) — enum — 대여상태

User (유저)

  • id (Key) — bigint — Primary key — NOT NULL — 회원ID
  • username (Field) — string — NOT NULL — 로그인ID
  • password (Field2) — string — NOT NULL — 비밀번호
  • phone (Field3) — string — 연락처