umc_practice

Tables (4)

book (Untitled2)

  • id — int — Primary key — NOT NULL
  • 책이름 (name) — NOT NULL
  • 책설명 (description) — NOT NULL

bookCategory (Untitled3)

  • id — int — Primary key — NOT NULL
  • 카테고리명 (name) — NOT NULL

member (Untitled)

  • id — int — Primary key — NOT NULL
  • 이름 (name) — NOT NULL
  • 닉네임 (nickname) — NOT NULL
  • 전화번호 (phoneNum) — NOT NULL
  • 성별 (sex)

rent (Untitled4)

  • id — int — Primary key — NOT NULL
  • 책의id (book_id) — NOT NULL
  • 빌린사람의id (member_id) — NOT NULL