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