연습

테이블 (5)

book (Untitled)

  • book_id (Key) — 기본 키 — NOT NULL
  • book_name (Field)
  • book_description (Field2)
  • created_at (Field3)
  • updated_atd (Field4)

category (Untitled5)

  • category_id (Key) — 기본 키 — NOT NULL
  • category_name (Field)

likes (Untitled4)

  • likes_id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • book_id (Key3) — 외래 키 → book.book_id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)

member (Untitled2)

  • member_id (Key) — 기본 키 — NOT NULL
  • member_name (Field)
  • member_nickname (Field2)
  • member_gender (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • status (Field6)
  • inactive_date (Field7)

rent (Untitled3)

  • rent_id (Key) — 기본 키 — NOT NULL
  • book_id (Key2) — 외래 키 → book.book_id — NOT NULL
  • member_id (Key3) — 외래 키 → member.member_id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)