도서관

테이블 (4)

book (Untitled2)

  • bookId (Key) — long — 기본 키 — NOT NULL
  • title (Field) — varchar(50)
  • author (Field2) — varchar(50)
  • language (Field3) — varchar(50)
  • company (Field4) — varchar(50)
  • checkout (Field6) — bool
  • createdAt (Field5) — Timestamp

checkInOut (Untitled4)

  • checkId (Key) — long — 기본 키 — NOT NULL
  • userId (Key2) — long — 외래 키 → user.userId — NOT NULL
  • bookId (Key3) — long — 외래 키 → book.bookId — NOT NULL

hitory (Untitled3)

  • id (Key) — long — 기본 키 — NOT NULL
  • userid (Key2) — long — 외래 키 → user.userId — NOT NULL
  • bookId (Key3) — long — 외래 키 → book.bookId — NOT NULL
  • username (Field) — varchar(50)
  • phoneNumber (Field2) — varchar(50)
  • title (Field3) — varchar(50)
  • author (Field4) — varchar(50)

user (Untitled)

  • userId (Key) — long — 기본 키 — NOT NULL
  • username (Field) — varchar(50)
  • gender (Field2) — varchar(50)
  • residentialnumber (Field3) — varchar(50)
  • phonenumber (Field4) — varchar(50)
  • address (Field5) — String
  • Field6 — Timestamp