BeatBuddy

Tables (47)

Archive

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • memberId — bigint

CampaignSequence

  • id — bigint

Comment

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • anonymousNickname — varchar(255)
  • content — varchar(255)
  • isAnonymous — bit — NOT NULL
  • isDeleted — bit — NOT NULL
  • likes — int — NOT NULL
  • memberId — bigint
  • postId — bigint
  • replyId — bigint

CommentLike

  • id — bigint
  • commentId — bigint — NOT NULL
  • memberId — bigint

Coupon

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • active — bit
  • subTitle — varchar(255)
  • expireDate — date
  • howToUse — tinytext
  • maxReceiveCountPerUser — int
  • title — varchar(255)
  • notes — tinytext
  • policy — enum
  • quota — int — NOT NULL
  • sameVenueUse — int

Event

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • content — tinytext
  • depositAccount — varchar(255)
  • depositAmount — int
  • endDate — datetime(6)
  • entranceFee — int — NOT NULL
  • entranceNotice — varchar(255)
  • imageUrls — varchar(3000)
  • isFreeEntrance — bit — NOT NULL
  • isVisible — bit — NOT NULL
  • likes — int — NOT NULL
  • location — varchar(255)
  • notice — varchar(255)
  • receiveGender — bit — NOT NULL
  • receiveInfo — bit — NOT NULL
  • receiveMoney — bit — NOT NULL
  • receiveName — bit — NOT NULL
  • receivePhoneNumber — bit — NOT NULL
  • receiveSNSId — bit — NOT NULL
  • receiveTotalCount — bit — NOT NULL
  • region — enum — NOT NULL
  • startDate — datetime(6)
  • status — enum — NOT NULL
  • thumbImage — varchar(255)
  • title — varchar(255)
  • views — int — NOT NULL
  • memberId — bigint
  • venueId — bigint
  • is_attendable — bit

EventAttendance

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • gender — tinyint
  • hasPaid — bit
  • name — varchar(255)
  • phoneNumber — varchar(255)
  • snsId — varchar(255)
  • snsType — enum
  • totalMember — int
  • eventId — bigint
  • memberId — bigint

EventComment

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • anonymous — bit — NOT NULL
  • anonymousNickname — varchar(255)
  • content — varchar(255)
  • level — int
  • parentId — bigint
  • authorId — bigint
  • eventId — bigint

EventLike

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • eventId — bigint
  • memberId — bigint

FailedNotification

  • id — bigint
  • lastTriedAt — datetime(6)
  • payloadJson — tinytext
  • reason — varchar(255)
  • resolved — bit — NOT NULL
  • retryCount — int — NOT NULL
  • targetToken — varchar(255)

Follows

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • followerId — bigint
  • followingId — bigint

FreePost

  • id — bigint — NOT NULL

FreePost_hashtag

  • FreePost_id — bigint — NOT NULL
  • hashtag — enum

Genre

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • name — varchar(255) — NOT NULL

Heartbeat

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • memberId — bigint
  • venueId — bigint

Magazine

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • content — varchar(255)
  • isPicked — bit — NOT NULL
  • isPinned — bit — NOT NULL
  • isSponsored — bit — NOT NULL
  • isVisible — bit — NOT NULL
  • likes — int — NOT NULL
  • orderInHome — int — NOT NULL
  • thumbImage — varchar(255)
  • title — varchar(255)
  • views — int — NOT NULL
  • eventId — bigint
  • memberId — bigint
  • stayCount — bigint — NOT NULL
  • totalStaySeconds — bigint — NOT NULL
  • start_date — date
  • end_date — date

MagazineLike

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • magazineId — bigint
  • memberId — bigint

Magazine_imageUrls

  • Magazine_id — bigint — NOT NULL
  • imageUrls — varchar(255)

Member

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • businessName — varchar(255)
  • dateOfBirth — date
  • isApproved — bit
  • isVerified — bit — NOT NULL
  • phoneNumber — varchar(255)
  • telCarrier — varchar(255)
  • fcmToken — varchar(512)
  • gender — tinyint
  • isLocationConsent — bit
  • isMarketingConsent — bit
  • latestArchiveId — bigint
  • loginId — varchar(255)
  • nickname — varchar(255)
  • nicknameChangeCount — int — NOT NULL
  • nicknameChangedAt — datetime(6)
  • postProfileImageUrl — varchar(255)
  • postProfileNickname — varchar(255)
  • postProfileNicknameChangeCount — int — NOT NULL
  • postProfileNicknameChangedAt — datetime(6)
  • setNewPostProfileNickname — bit
  • profileImage — varchar(255)
  • realName — varchar(255)
  • role — enum
  • setNewNickname — bit
  • version — bigint — NOT NULL
  • active — bit — NOT NULL
  • warning_count — int — NOT NULL
  • is_banned — bit — NOT NULL
  • restrict_until — datetime

MemberCoupon

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • status — enum
  • usedDate — datetime(6)
  • couponId — bigint
  • memberId — bigint
  • venueId — bigint

MemberGenre

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • archive_id — bigint
  • genre_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL

MemberMood

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • archive_id — bigint
  • member_id — bigint — NOT NULL
  • mood_id — bigint — NOT NULL

MemberRegion

  • id — bigint
  • memberId — bigint — NOT NULL
  • archiveId — bigint
  • regionId — bigint — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

MemberType

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • archive_id — bigint
  • member_id — bigint — NOT NULL
  • type_id — bigint — NOT NULL

Mood

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • name — varchar(255) — NOT NULL

Notification

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • contentId — bigint
  • imageUrl — varchar(255)
  • isRead — bit — NOT NULL
  • message — varchar(255)
  • readAt — datetime(6)
  • title — varchar(255)
  • type — varchar(64)
  • url — varchar(255)
  • receiverId — bigint — NOT NULL
  • campaignId — bigint

Piece

  • id — bigint
  • currentMembers — int — NOT NULL
  • eventDate — datetime(6)
  • totalMembers — int — NOT NULL
  • totalPrice — int — NOT NULL
  • memberId — bigint
  • venueId — bigint

PiecePost

  • id — bigint — NOT NULL
  • pieceId — bigint
  • venueId — bigint

Post

  • DTYPE — varchar(31) — NOT NULL
  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • anonymous — bit — NOT NULL
  • comments — int — NOT NULL
  • content — varchar(1000) — NOT NULL
  • imageUrls — varchar(3000)
  • likes — int — NOT NULL
  • scraps — int — NOT NULL
  • thumbnailUrls — varchar(4000)
  • title — varchar(255)
  • views — int — NOT NULL
  • memberId — bigint

PostLike

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • memberId — bigint
  • postId — bigint

PostScrap

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • memberId — bigint
  • postId — bigint

RecentSearch

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • keyword — varchar(20) — NOT NULL
  • searchType — enum — NOT NULL
  • memberId — bigint — NOT NULL

Region

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

Report

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • content — tinytext
  • reason — varchar(255)
  • targetId — bigint
  • targetType — enum
  • title — varchar(255)
  • reporterId — bigint — NOT NULL
  • reportedId — bigint
  • is_processed — bit

Type

  • id — bigint
  • name — varchar(255) — NOT NULL

Venue

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • address — varchar(255) — NOT NULL
  • description — varchar(255)
  • englishName — varchar(255)
  • entranceFee — int — NOT NULL
  • entrance_notice — varchar(255)
  • heartbeatNum — bigint
  • instaId — varchar(255)
  • instaUrl — varchar(255)
  • isFreeEntrance — bit — NOT NULL
  • isSmokingAllowed — bit — NOT NULL
  • koreanName — varchar(255)
  • latitude — double — NOT NULL
  • logoUrl — varchar(255)
  • longitude — double — NOT NULL
  • notice — varchar(255)
  • phoneNum — varchar(255)
  • regionId — BIGINT

VenueGenre

  • id — bigint
  • genre_id — bigint — NOT NULL
  • venue_id — bigint — NOT NULL

VenueMood

  • id — bigint
  • mood_id — bigint — NOT NULL
  • venue_id — bigint — NOT NULL

VenueReview

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • content — varchar(400) — NOT NULL
  • imageUrls — varchar(3000)
  • likes — int — NOT NULL
  • thumbnailUrls — varchar(3000)
  • memberId — bigint
  • venueId — bigint

VenueReviewLike

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • memberId — bigint
  • venueReviewId — bigint

VenueType

  • id — bigint
  • type_id — bigint — NOT NULL
  • venue_id — bigint — NOT NULL

Venue_backgroundUrl

  • Venue_id — bigint — NOT NULL
  • backgroundUrl — varchar(255)

Venue_operationHours

  • Venue_id — bigint — Primary key — NOT NULL
  • operationHours_KEY — varchar(255) — Primary key — NOT NULL
  • operationHours — varchar(255)

campaign

  • id — bigint
  • title — varchar(255) — NOT NULL
  • message — varchar(255)
  • type — varchar(50)
  • createdAt — datetime(6)
  • updatedAt — datetime(6)

couponVenue

  • couponId — bigint — NOT NULL
  • venueId — bigint — NOT NULL

magazineVenue

  • magazineId — bigint — NOT NULL
  • venueId — bigint — NOT NULL

member_block

  • id — bigint
  • createdAt — datetime(6)
  • updatedAt — datetime(6)
  • blocked_id — bigint — NOT NULL
  • blocker_id — bigint — NOT NULL