도서대여

테이블 (3)

Book (Untitled2)

  • bookId (Key) — int — 기본 키 — NOT NULL
  • title (Field) — VARCHAR2
  • author (Field2) — VARCHAR2
  • publisher (Field3) — VARCHAR2

Member (Untitled)

  • memberId (Key) — int — 기본 키 — NOT NULL
  • name (Field) — VARCHAR2
  • age (Field2) — int
  • joined_at (Field3) — VARCHAR2

Rent (Untitled3)

  • rentId (Key) — int — 기본 키 — NOT NULL
  • memberId (Key3) — int — 외래 키 → Member.memberId — NOT NULL
  • bookId (Key2) — int — 외래 키 → Book.bookId — NOT NULL
  • date (Field) — Date