MOIMMOIM

Tables (15)

Category

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL

FavoriteMeeting

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Members.id — NOT NULL
  • meeting_post_id — BIGINT — Foreign key → MeetingPost.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Members.region_id — NOT NULL
  • note — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

InterestAction

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Members.id — NOT NULL
  • category_id — BIGINT — Foreign key → Category.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Members.region_id — NOT NULL
  • action_type — ENUM('VIEW', 'APPLY', 'FAVORITE', 'CLICK_ALERT')
  • score — INT
  • create_at — DATETIME

MeetingPost

  • id — BIGINT — Primary key — NOT NULL
  • creator_id — BIGINT — Foreign key → Members.id — NOT NULL
  • category_id — BIGINT — Foreign key → Category.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Members.region_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • capacity — INT — NOT NULL
  • location — VARCHAR(255)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • thumbnail — VARCHAR(255)
  • start_date — DATETIME
  • end_date — DATETIME
  • is_public — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • faborite_count — INT DEFAULT 0
  • updated_at — DATETIME

MeetingPostTag

  • meeting_post_id — BIGINT — Primary key — NOT NULL
  • tag_id — BIGINT — Primary key — NOT NULL

MemberInterest

  • id — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Members.id — NOT NULL
  • category_id — BIGINT — Foreign key → Category.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Members.region_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • score — INT DEFAULT 0
  • updated_at — DATETIME

MemberReview

  • id — BIGINT — Primary key — NOT NULL
  • participation_id — BIGINT — Foreign key → Participation.id — NOT NULL
  • reviewer_id — BIGINT — Foreign key → MeetingPost.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → MeetingPost.id — NOT NULL
  • score — INT — NOT NULL
  • comment — TEXT — EX
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • status — ENUM('PENDING', 'CONFIRMED')

Members (Member)

  • id — BIGINT — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → Region.id — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • age — INT
  • introduction — TEXT
  • role — VARCHAR(20) — NOT NULL
  • points — INT — NOT NULL
  • level — INT — NOT NULL
  • profile_image — VARCHAR(255)
  • status — ENUM('ACTIVE', 'INACTIVE', 'BANNED')
  • last_login — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

Notification

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MeetingPost.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → MeetingPost.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • reference_id — BIGINT
  • content — TEXT — NOT NULL
  • read_status — BOOLEAN — NOT NULL
  • channel_type — ENUM(’APP’,’EMAIL’,’SMS’)
  • created_at — DATETIME — NOT NULL
  • exprie_at — DATETIME

Participation

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Members.id — NOT NULL
  • meeting_post_id — BIGINT — Foreign key → MeetingPost.id — NOT NULL
  • status — ENUM(PENDING, APPROVED, REJECTED) — NOT NULL
  • join_reason — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • role — ENUM('PARTICIPANT','ORGANIZER')
  • rating_given — BOOLEAN

Post&Comment

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Members.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Members.region_id — NOT NULL
  • meeting_post_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • parent_id — BIGINT
  • content — TEXT — NOT NULL
  • like_count — INT
  • comment_count — INT
  • deleted_flag — BOOLEAN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

PostCommentLike

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Members.id — NOT NULL
  • target_id — BIGINT — Foreign key → Post&Comment.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Members.region_id — NOT NULL
  • target_type — ENUM('POST','COMMENT')
  • created_at (create_at) — DATETIME

Region

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • depth — COMMENT
  • parent_id — COMMENT
  • created_at — DATETIME
  • updated_at — DATETIME

Review

  • id — BIGINT — Primary key — NOT NULL
  • reviewer_id — BIGINT — Foreign key → Members.id — NOT NULL
  • meeting_post_id — BIGINT — Foreign key → MeetingPost.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → Members.region_id — NOT NULL
  • rating — DECIMAL(2,1) — NOT NULL
  • comment — TEXT — EX
  • created_at — DATETIME — NOT NULL
  • deleted_flag (deleted_falg) — BOOLEAN

Tag

  • tag_id — BIGINT — Foreign key → MeetingPostTag.tag_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL