PLACEHOLD
Tables (11)
Category (카테고리)
- id — int — Primary key — NOT NULL
- name (카테고리명) — char
- slug — char
- created_at (생성일) — date
- updated_at (수정일) — date
Comment (댓글)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- meetup (meetup_id) — fk — Foreign key → Meetup.id — NOT NULL
- parent (부모 댓글) — fk — Foreign key → Comment.id — NOT NULL
- text (내용) — text
- created_at (생성일) — date
- updated_at (수정일) — date
Like (좋아요)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- meetup (meetup_id) — fk — Foreign key → Meetup.id — NOT NULL
- created_at (생성일) — date
Meetup (모임)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- title (제목) — char
- defcription (설명) — text
- place (장소) — char
- latitude (위도) — float
- longtitude (경도) — float
- date (모임일) — date
- is_public (공개 여부) — bool
- max_members (최대 인원) — int
- created_at (생성일) — date
- updated_at (수정일) — date
MeetupMember (모임원)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- meetup (meetup_id) — fk — Foreign key → Meetup.id — NOT NULL
- role (역할) — char
- status (상태) — char
- created_at (생성일) — date
- updated_at (수정일) — date
Meetup_Category (모임 카테고리)
- id — pk — Primary key — NOT NULL
- meetup (meetup_id) — fk — Foreign key → Meetup.id — NOT NULL
- category (category_id) — fk — Foreign key → Category.id — NOT NULL
Meetup_Tag (모임 태그)
- id — pk — Primary key — NOT NULL
- meetup (meetup_id) — fk — Foreign key → Meetup.id — NOT NULL
- tag (tag_id) — fk — Foreign key → Tag.id — NOT NULL
Notification (알림)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- message (알림 내용) — text
- is_read (읽음 여부) — bool
- created_at (생성일) — date
- updated_at (수정일) — date
Requestion (요청)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- meetup — fk — Foreign key → Meetup.id — NOT NULL
- text (내용) — text
- created_at (생성일) — date
- updated_at (수정일) — date
Tag (태그)
- id — pk — Primary key — NOT NULL
- name (태그명) — char
- slug — char
- created_at (생성일) — date
- updated_at (수정일) — date
User (회원)
- id — pk — Primary key — NOT NULL
- email (이메일) — char
- name (이름) — char
- nickname (별명) — char
- password (비밀번호) — char
- profile_image (프로필 사진) — image
- bio (자기소개) — text
- created_at (생성일) — date
- updated_at (수정일) — date