도서대여관리_study

테이블 (8)

alarm (Untitled5)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

book (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • book_category_id (Key2) — bigint — 외래 키 → book_category.id — NOT NULL
  • title (Field)
  • description (Field2)
  • created_at (Field3)
  • updated_at (Field4)

book_category (Untitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • created_at (Field)
  • updated_at (Field2)
  • Field3

book_hash_tag (CopyOfUntitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • book_id (Key2) — bigint — 외래 키 → book.id — NOT NULL
  • book_category_id (Key22) — bigint — 외래 키 → book.book_category_id — NOT NULL
  • id (Key3) — bigint — 외래 키 → hash_tag.id — NOT NULL
  • Field

book_likes (CopyOfUntitled43)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • id (Key2) — bigint — 외래 키 → book.id — NOT NULL
  • book_category_id (Key22) — bigint — 외래 키 → book.book_category_id — NOT NULL
  • id (Key3) — bigint — 외래 키 → member.id — NOT NULL
  • created_at (Field) — datetime(6)
  • updated_at (Field2) — datetime(6)

hash_tag (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(2)
  • created_at (Field2)
  • updated_at (Field3)

member (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field)
  • nickname (Field2)
  • phone (Field3)
  • gender (Field4)
  • created_at (Field5)
  • updated_at (Field6)
  • status (Field7)
  • inactive_date (Field8)

rent (CopyOfUntitled42)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • book_id (Key4) — bigint — 외래 키 → book.id — NOT NULL
  • member_id (Key5) — bigint — 외래 키 → member.id — NOT NULL
  • id (Key2) — bigint — 외래 키 → book.book_category_id — NOT NULL
  • created_at (Field) — datetime(6)
  • updated_at (Field2) — datetime(6)