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