Travel Club

Tables (6)

Address (주소)

  • id (주소아이디) — BIGINT — Primary key — NOT NULL
  • zipCode (우편번호) — VARCHAR
  • zipAddress (세부주소) — VARCHAR
  • streetAddress (도로명주소) — VARCHAR
  • country (나라이름) — VARCHAR
  • addressType (주소타입) — ENUM
  • id (멤버아이디) — BIGINT — Foreign key → CommunityMember.id — NOT NULL

ClubMembership (멤버십)

  • id (멤버십아이디) — BIGINT — Primary key — NOT NULL
  • clubId (클럽아이디) — BIGINT — Foreign key → TravelClub.id — NOT NULL
  • memberId (멤버아이디) — BIGINT — Foreign key → CommunityMember.id — NOT NULL
  • role (클럽내역할) — ENUM
  • createdDate (생성날짜) — DATETIME

CommunityMember (멤버)

  • id (멤버아이디) — BIGINT — Primary key — NOT NULL
  • email (이메일) — BIGINT — NOT NULL
  • name (이름) — VARCHAR
  • phoneNumber (전화번호) — VARCHAR
  • birthday (생일) — DATETIME

Posting (게시글)

  • id (게시글아이디) — BIGINT — Primary key — NOT NULL
  • boardId (게시판아이디) — BIGINT — Foreign key → SocialBoard.id — NOT NULL
  • title (제목) — VARCHAR
  • writerEmail (작성자이메일) — VARCHAR
  • contents (내용) — VARCHAR
  • readCount (조회수) — BIGINT

SocialBoard (게시판)

  • id (게시판아이디) — BIGINT — Primary key — NOT NULL
  • clubId (클럽아이디) — BIGINT — Foreign key → TravelClub.id — NOT NULL
  • name (게시판이름) — VARCHAR
  • adminEmail (관리자이메일) — VARCHAR
  • createdDate (생성날짜) — DATETIME

TravelClub (클럽)

  • id (클럽아이디) — BIGINT — Primary key — NOT NULL
  • name (클럽이름) — VARCHAR
  • intro (클럽설명) — VARCHAR
  • createdDate (생성날짜) — DATETIME