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