test

Tables (9)

comments

  • commentId — BIGINT
  • meetingId — BIGINT — Foreign key → meetings.meetingId — NOT NULL
  • writerId — BIGINT — Foreign key → users.userId — NOT NULL
  • parentCommentId — BIGINT — Foreign key → comments.commentId
  • content — TEXT — NOT NULL
  • isDeleted — BOOLEAN
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • regionId — BIGINT — Foreign key → meetings.regionId — NOT NULL

meetingParticipants

  • participantId — BIGINT
  • meetingId — BIGINT — Foreign key → meetings.meetingId — NOT NULL
  • userId — BIGINT — Foreign key → users.userId — NOT NULL
  • status — ENUM('PENDING','APPROVED','REJECTED','CANCELLED')
  • message — TEXT
  • appliedAt — DATETIME
  • approvedAt — DATETIME
  • cancelledAt — DATETIME
  • regionId — BIGINT — Foreign key → meetings.regionId — NOT NULL

meetings

  • regionId — BIGINT — Primary key — NOT NULL
  • meetingId — BIGINT
  • hostUserId — BIGINT — Foreign key → users.userId — NOT NULL
  • sportId — BIGINT — Foreign key → sports.sportId — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • thumbnailImage — VARCHAR(500)
  • placeName — VARCHAR(100)
  • address — VARCHAR(255)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • meetingDate — DATE — NOT NULL
  • startTime — TIME — NOT NULL
  • maxMembers — INT — NOT NULL
  • meetingType — ENUM('ONE_TIME','REGULAR')
  • repeatType — ENUM('NONE','WEEKLY','BIWEEKLY','MONTHLY')
  • supplies — TEXT
  • guideText — TEXT
  • status — ENUM('RECRUITING','CLOSED','COMPLETED','CANCELLED')
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • deletedAt — DATETIME

regions

  • regionId — BIGINT
  • sido — VARCHAR(50) — NOT NULL
  • sigungu — VARCHAR(50) — NOT NULL
  • dong — VARCHAR(50)
  • createdAt — DATETIME

reports

  • reportId — BIGINT
  • reporterId — BIGINT — Foreign key → users.userId — NOT NULL
  • targetType — ENUM('MEETING','COMMENT','USER') — NOT NULL
  • meetingId — BIGINT — Foreign key → meetings.meetingId
  • commentId — BIGINT — Foreign key → comments.commentId
  • targetUserId — BIGINT — Foreign key → users.userId
  • reason — VARCHAR(100) — NOT NULL
  • content — TEXT
  • status — ENUM('PENDING','RESOLVED','REJECTED')
  • createdAt — DATETIME
  • processedAt — DATETIME
  • regionId — BIGINT — Foreign key → meetings.regionId — NOT NULL

reviews

  • reviewId — BIGINT
  • meetingId — BIGINT — Foreign key → meetings.meetingId — NOT NULL
  • writerId — BIGINT — Foreign key → users.userId — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT
  • reviewImage — VARCHAR(500)
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • regionId — BIGINT — Foreign key → meetings.regionId — NOT NULL

sports

  • sportId — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • category — VARCHAR(50)
  • isActive — BOOLEAN
  • createdAt — DATETIME

userSports

  • userSportId — BIGINT
  • userId — BIGINT — Foreign key → users.userId — NOT NULL
  • sportId — BIGINT — Foreign key → sports.sportId — NOT NULL
  • createdAt — DATETIME

users

  • userId — BIGINT
  • loginId — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • profileImage — VARCHAR(500)
  • regionId — BIGINT — Foreign key → regions.regionId
  • role — ENUM('USER','ADMIN')
  • status — ENUM('ACTIVE','SUSPENDED','DELETED')
  • createdAt — DATETIME
  • updatedAt — DATETIME