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