Odok

Tables (5)

Book (책)

  • bookId (ID) — bigint — Primary key — NOT NULL
  • bookName (책 이름) — varchar
  • bookImage (책 사진) — varchar
  • writer (작가) — varchar
  • summary (책 요약) — varchar
  • publisher (출판사) — varchar
  • createdAt (생성 일자) — DateTime
  • modifiedAt (수정 일자) — DateTime

Club (모임)

  • clubId (ID) — bigint — Primary key — NOT NULL
  • clubName (모임 이름) — varchar
  • clubIntro (모임 소개) — varchar
  • plan (모임 계획) — varchar
  • location (모임 장소) — varchar
  • schedule (모임 일정) — varchar
  • memberLimit (제한 인원) — bigint
  • category (모임 종류) — varchar
  • summary (모임 설명) — varchar
  • imageUrl (모임 이미지) — varchar
  • createdAt (생성 일자) — DateTime
  • modifiedAt (수정 일자) — DateTime
  • memberId (Field) — bigint

ClubBook (모임 선정 책)

  • id (ID) — bigint — Primary key — NOT NULL
  • clubId (ID2) — bigint — Foreign key → Club.clubId — NOT NULL
  • bookId (ID3) — bigint — Foreign key → Book.bookId — NOT NULL

ClubMember (모임 참여자)

  • id (ID) — bigint — Primary key — NOT NULL
  • memberId (ID2) — varchar — Foreign key → Member.memberId — NOT NULL
  • clubId (ID3) — bigint — Foreign key → Club.clubId — NOT NULL

Member (회원)

  • memberId (ID) — varchar — Primary key — NOT NULL
  • email (이메일) — varchar
  • name (유저이름) — varchar
  • address (주소) — varchar
  • phoneNumber (연락처) — varchar
  • password (비밀번호) — varchar
  • createdAt (생성일자) — DateTime
  • modifiedAt (수정일자) — DateTime