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