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 — 공통 엔티티