도서관
테이블 (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