PLACEHOLD_
Tables (9)
Comment (댓글)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- meetup (meetup_id) — pk — Foreign key → Meetup.id — NOT NULL
- parent (부모 댓글) — fk — Foreign key → Comment.id
- text (내용) — text — NOT NULL
- created_at (생성일) — date — NOT NULL
- updated_at (수정일) — date — NOT NULL
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 — NOT NULL
Meetup (모임)
- id — pk — Primary key — NOT NULL
- organizer (모임장) — fk — Foreign key → User.id — NOT NULL
- name (이름) — char — NOT NULL
- description (설명) — text — NOT NULL
- place (장소) — char — NOT NULL
- place_description (장소 설명) — char — NOT NULL
- image (이미지) — image — NOT NULL
- started_at (시작일) — date
- ended_at (종료일) — date
- ad_title (광고 제목) — char — NOT NULL
- ad_ended_at (광고 종료일) — date — NOT NULL
- is_public (공개 여부) — bool — NOT NULL
- created_at (생성일) — date — NOT NULL
- updated_at (수정일) — date — NOT NULL
Member (모임원)
- 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 — NOT NULL
- created_at (생성일) — date — NOT NULL
- updated_at (수정일) — date — NOT NULL
Notification (알림)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- message (알림 내용) — text — NOT NULL
- is_read (읽음 여부) — bool — NOT NULL
- created_at (생성일) — date — NOT NULL
- updated_at (수정일) — date — NOT NULL
Proposal (신청)
- 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 (내용) — char — NOT NULL
- status (상태) — char — NOT NULL
- created_at (생성일) — date — NOT NULL
- updated_at (수정일) — date — NOT NULL
Schedule (스케줄)
- id — pk — Primary key — NOT NULL
- meetup (meetup_id) — fk — Foreign key → Meetup.id — NOT NULL
- participant (참여자) — fk — Foreign key → User.id — NOT NULL
- scheduled_at (예정일) — date — NOT NULL
- place (장소) — char — NOT NULL
- address (주소) — char — NOT NULL
- latitude (위도) — float — NOT NULL
- longitude (경도) — float — NOT NULL
- memo (메모) — char — NOT NULL
- image (이미지) — image
- created_at (생성일) — date — NOT NULL
- updated_at (수정일) — date — NOT NULL
ScheduleComment (스케줄 댓글)
- id — pk — Primary key — NOT NULL
- user (user_id) — fk — Foreign key → User.id — NOT NULL
- schedule (schedule_id) — fk — Foreign key → Schedule.id — NOT NULL
- id (id2) — pk — Foreign key → Schedule.participant — NOT NULL
- parent (schedule_comment_id) — fk — Foreign key → ScheduleComment.id
- text (내용) — text — NOT NULL
- created_at (생성일) — date — NOT NULL
- updated_at (수정일) — date — NOT NULL
User (회원)
- id — pk — Primary key — NOT NULL
- email (이메일) — char — NOT NULL
- nickname (별명) — char — NOT NULL
- password (비밀번호) — char — NOT NULL
- image (프로필 사진) — image
- bio (자기소개) — text — NOT NULL
- created_at (생성일) — date — NOT NULL
- updated_at (수정일) — date — NOT NULL