MoimMoim

Tables (11)

Authority (권한)

  • authority_name (권한이름) — varchar(50) — Primary key — NOT NULL

Comment (댓글)

  • comment_id (댓글 식별자 번호) — bigint — Primary key — NOT NULL
  • post_id (게시글 식별자 번호) — bigint — Foreign key → Post.post_id — NOT NULL
  • member_id (사용자 식별 번호) — bigint — Foreign key → Post.member_id — NOT NULL
  • content (내용) — varchar(1000) — NOT NULL
  • create_at (작성일자) — timestamp — NOT NULL

Member (회원)

  • member_id (사용자 식별 번호) — bigint — Primary key — NOT NULL
  • password (비밀번호) — varchar(255) — NOT NULL
  • email (이메일) — varchar(100) — NOT NULL
  • phone (휴대전화번호) — varchar(20) — NOT NULL
  • name (이름) — varchar(100) — NOT NULL
  • birth (생일) — date — NOT NULL
  • gender (성별) — enum — NOT NULL
  • nickname (닉네임) — varchar(100) — NOT NULL
  • signup_date (가입날짜) — timestamp — NOT NULL

Moim_Comment (모임 댓글)

  • moim_comment_id (모임 댓글 식별자 번호) — bigint — Primary key — NOT NULL
  • moim_post_id (모임 게시글 식별자 번호) — bigint — Foreign key → Moim_Post.moim_post_id — NOT NULL
  • content (내용) — varchar(1000) — NOT NULL
  • create_at (작성일자) — timestamp — NOT NULL

Moim_Post (모임 게시글)

  • moim_post_id (모임 게시글 식별자 번호) — bigint — Primary key — NOT NULL
  • member_id (모임 게시글 사용자 식별 번호) — bigint — Foreign key → Member.member_id — NOT NULL
  • title (제목) — varchar(255) — NOT NULL
  • category (카테고리) — enum — NOT NULL
  • content (내용) — text — NOT NULL
  • address_title (주소) — String — NOT NULL
  • road_address (도로명주소) — String — NOT NULL
  • region (행정구역) — String
  • mapy (위도) — decimal(10,8) — NOT NULL
  • mapx (경도) — decimal(11,8) — NOT NULL
  • moim_status (모임 상태) — enum — NOT NULL
  • max_participants (최대 참여 인원) — int — NOT NULL
  • current_participants (현재 참여 인원) — int — NOT NULL
  • moim_date (모임날짜) — timestamp — NOT NULL
  • create_at (작성일자) — timestamp — NOT NULL
  • view_count (조회수) — bigint — NOT NULL
  • cancellation_reason (취소 이유) — text

Notification (알림)

  • Nofitication_id (알림 식별자 번호) — bigint — Primary key — NOT NULL
  • member_id (알림 받을 회원 식별자 번호) — bigint — Foreign key → Member.member_id — NOT NULL
  • Notification_type_id (알림 유형 식별자 번호) — bigint — Foreign key → Notification_type.Notification_type_id — NOT NULL
  • massage (알림 내용) — varchar(255) — NOT NULL
  • status (알림상태(읽음,읽지 않음)) — enum — NOT NULL
  • created_at (알림 일자) — timestamp — NOT NULL

Notification_type (알림유형)

  • Notification_type_id (알림 유형 식별자 번호) — Primary key — NOT NULL
  • name (알림 유형) — varchar(20) — NOT NULL

Post (게시글)

  • post_id (게시글 식별자 번호) — bigint — Primary key — NOT NULL
  • member_id (사용자 식별 번호) — bigint — Foreign key → Member.member_id — NOT NULL
  • title (제목) — varchar(255) — NOT NULL
  • create_at (작성일자) — timestamp — NOT NULL
  • content (내용) — text — NOT NULL

member_authority (회원 권한)

  • member_id (사용자식별 번호) — bigint — Foreign key → Member.member_id — NOT NULL
  • authority_name (권한이름) — varchar(50) — Foreign key → Authority.authority_name — NOT NULL

moim_accpted_member (모임 수락 회원)

  • moim_acceped_member_id (수락된 회원 고유 식별자 번호) — bigint — Primary key — NOT NULL
  • moim_post_id (모임 게시글 식별자 번호) — bigint — Foreign key → moim_participation_request.moim_post_id — NOT NULL
  • member_id (모임 신청자 식별자 번호) — bigint — Foreign key → Member.member_id — NOT NULL
  • accepted_at (수락 날짜) — timestamp — NOT NULL

moim_participation_request (참여 신청)

  • moim_participation_request_id (모인 신청 식별자 번호) — bigint — Primary key — NOT NULL
  • moim_post_id (모임 게시글 식별자 번호) — bigint — Foreign key → Moim_Post.moim_post_id — NOT NULL
  • member_id (모임 신청자 식별 번호) — bigint — Foreign key → Member.member_id — NOT NULL
  • nickname (닉네임) — varchar(255) — NOT NULL
  • intro (참여 소개글) — varcahr(255) — NOT NULL
  • reason_participation (참여하고 싶은 이유) — varcahr(255) — NOT NULL
  • rejection_reason (거절 사유(거절 시)) — varchar(2550 — NOT NULL
  • created_at (모임신청 일자) — timestamp — NOT NULL
  • updated_at (상태 변경 일자) — timestamp — NOT NULL
  • participation_status (신청 수락 여부) — enum — NOT NULL