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 — 연락처