umc4

Tables (9)

alarm (알람)

  • pk (id) — bigint — Primary key — NOT NULL
  • pk (user_Id) — bigint — Foreign key → user.pk — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • 제목 (title) — varchar(30)
  • 내용 (content) — text
  • 공지 종류 (type) — enum

book (책)

  • pk (id) — bigint — Primary key — NOT NULL
  • pk (category_id) — bigint — Foreign key → category.pk — NOT NULL
  • 제목 (title) — varchar(50)
  • 설명 (content) — varchar(50)
  • created_at — datetime(6)
  • updated_at — datetime(6)

book_hashtag (책 해시태그)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (hashtag_id) — bigint — Foreign key → hashtag.pk — NOT NULL
  • fd (book_Id) — bigint — Foreign key → book.pk — NOT NULL

category (카테고리)

  • pk (id) — bigint — Primary key — NOT NULL
  • 카테고리 (category) — varchar(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)

hashtag (해시태그)

  • pk (id) — bigint — Primary key — NOT NULL
  • 내용 (content) — varchar(30)
  • created_at — datetime(6)
  • updated_at — datetime(6)

like (좋아요)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (user_id) — bigint — Foreign key → user.pk — NOT NULL
  • fk (book_Id) — bigint — Foreign key → book.pk — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

rent (대여)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (user_id) — bigint — Foreign key → user.pk — NOT NULL
  • fk (book_Id) — bigint — Foreign key → book.pk — NOT NULL
  • 반납 마감 시간 (last_time) — datetime
  • 반납시간 (time) — datetime
  • 대여시간 (created_at) — datetime(6)
  • Field

table (테이블)

  • pk (id) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

user (사용자)

  • pk (id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar(15)
  • 닉네임 (nickname) — varchar(15)
  • 전화번호 (phone) — varchar(15)
  • 성별 (gender) — varchar(10)
  • created)at (created_at) — datetime(6)
  • updated_at — datetime(6)
  • 탈퇴여부 (status) — varchar(15)
  • 비활성기간 (inactive_date) — datetime