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