6th

Tables (7)

book (Untitled2)

  • id (아이디) — Primary key — NOT NULL
  • name (제목)
  • discription (설명)
  • created_at (생성일)
  • update_at (Field)
  • category_id (카테고리 아이디) — Foreign key → category.id — NOT NULL

book_hash_tag (Untitled7)

  • id (아이디) — Primary key — NOT NULL
  • book_id (책 아이디) — Foreign key → book.id — NOT NULL
  • hash_tag_id (해시태그아이디) — Foreign key → hash_tag.id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)

category (Untitled4)

  • id (아이디) — Primary key — NOT NULL
  • name (이름)
  • created_at (생성일)
  • updated_at (수정일)

hash_tag (Untitled5)

  • id (아이디) — Primary key — NOT NULL
  • name (이름)
  • created_at (Field)
  • updated_at (Field2)

like (Untitled6)

  • id (아이디) — Primary key — NOT NULL
  • member_id (Key) — Foreign key → member.id — NOT NULL
  • book_id (아이디2) — Foreign key → book.id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)

member (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (이름)
  • nickname (닉네임)
  • phone_num (전화번호)
  • gender (성별)
  • created_at (Field)
  • updated_at (Field2)
  • status (Field3)
  • inactive_date (Field4)

rent (Untitled3)

  • id (아이디) — Primary key — NOT NULL
  • member_id (Key) — Foreign key → member.id — NOT NULL
  • book_id (아이디2) — Foreign key → book.id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)