MoEasy

Tables (7)

keyword

  • keyword_id — int — Primary key — NOT NULL — increment
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL
  • keyword — varchar(10) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL — 공통 엔티티
  • Field2 (updatedAt) — timestamp — NOT NULL — 공통 엔티티

meeting

  • meeting_id — int — Primary key — NOT NULL
  • name — varchar(18) — NOT NULL
  • explanation — varchar(255)
  • limit — int — NOT NULL
  • thumbnail — varchar(255) — NOT NULL
  • canjoin (canJoin) — varchar(255) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL — 공통 엔티티
  • Field (updatedAt) — timestamp — NOT NULL — 공통 엔티티

member

  • users_id — int — Foreign key → users.users_id — NOT NULL
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL
  • authority — enum('WAITING', 'MEMBER', 'MANAGER', 'OWNER') — NOT NULL
  • Field2 (applicationMessage) — varchar(255) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL — 공통 엔티티
  • Field2 (updatedAt) — timestamp — NOT NULL — 공통 엔티티

notification

  • notification_id — int — Primary key — NOT NULL
  • users_id — int — Foreign key → users.users_id — NOT NULL
  • content — varchar(255) — NOT NULL
  • checkedYn — tinyint(1) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL — 공통 엔티티
  • Field2 (updatedAt) — timestamp — NOT NULL — 공통 엔티티

participant

  • schedule_id — int — Foreign key → schedule.schedule_id — NOT NULL
  • users_id — int — Foreign key → users.users_id — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL — 공통 엔티티
  • Field2 (updatedAt) — timestamp — NOT NULL — 공통 엔티티

schedule

  • schedule_id — int — Primary key — NOT NULL — increment
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL
  • name — varchar(255) — NOT NULL
  • explantion (explanation) — varchar(255) — NOT NULL
  • reminder — int — NOT NULL
  • announcement — varchar(255) — NOT NULL
  • onlineYn — tinyint(1) — NOT NULL
  • address — varchar(255) — NOT NULL — 네이버 지도 API 참고
  • datailAddress (detailAddress) — varchar(255) — NOT NULL
  • startDate — datetime — NOT NULL
  • endDate — datetime
  • Field (createdAt) — timestamp — NOT NULL — 공통 엔티티
  • Field (updatedAt) — timestamp — NOT NULL — 공통 엔티티

users

  • users_id — int — Primary key — NOT NULL
  • discord_id — varchar(255) — NOT NULL
  • username — varchar(255) — NOT NULL
  • avatar — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • explanation — varchar(255) — NOT NULL
  • settings (allowNotificationYn) — tinyint(1) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL — 공통 엔티티
  • Field (updatedAt) — timestamp — NOT NULL — 공통 엔티티