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