stopMoving

Tables (6)

Book (책)

  • id — Primary key — NOT NULL
  • library_id — Foreign key → Library.id — NOT NULL
  • isbn — Foreign key → Bookinfo.isbn — NOT NULL
  • user_id — Foreign key → user-book.user_id — NOT NULL
  • expire_date (만료일)
  • current_price (가격)
  • donation_date (기증일)
  • status (상태)
  • donor_user_id (기증자)

Bookinfo (책정보)

  • isbn — Primary key — NOT NULL
  • name (제목)
  • author (저자)
  • publisher (출판사)
  • cover (표지 이미지)
  • category_name (카테고리)
  • regular_price (정가)
  • description (설명)
  • vector (벡터값)

Library (도서관)

  • id — Primary key — NOT NULL
  • name (이름)
  • address (주소)
  • contact (연락처)
  • closed_days (휴관일)
  • hours_of_use (이용시간)
  • SNS (sns)
  • lat (위도)
  • long (경도)

User (회원)

  • id — Primary key — NOT NULL
  • nickname (닉네임)
  • username (아이디)
  • pw (비번(해시))

user-book (사용자-책)

  • user_id — Foreign key → User.id — NOT NULL
  • status (싱테) — ENUM
  • Field

userinfo (회원정보)

  • id — Foreign key → User.id — NOT NULL
  • preference_keyword (설문결과)
  • preference_vector (취향벡터)
  • points (포인트)