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 (포인트)