bravo_v1
Tables (33)
Block
- idx — int — Primary key — NOT NULL
- userToken — varchar(50) — Foreign key → User.userToken — NOT NULL
- blockedUser — varchar(50) — NOT NULL
- createdAt — timestamp — NOT NULL
Certification
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL
- refreshToken — text
Comment
- commentToken — int — Primary key — NOT NULL
- comment — text
- userToken — varchar(200) — Foreign key → User.userToken
- feedToken — varchar(200)
- infoToken — int — PRI
- togetherToken — varchar(200)
- photo — varchar(255)
- createdAt — timestamp
CommentReport
- idx — int — Primary key — NOT NULL
- state — tinyint(1) — NOT NULL — 0 = 힐링정보 댓글, 1 = 이야기 댓글
- commentToken — int — Foreign key → Comment.commentToken — NOT NULL
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL
- reason — text
- createdAt — timestamp — NOT NULL
ContentLike
- idx — int — Primary key — NOT NULL — PRI
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL — MUL
- togetherToken — varchar(200)
- feedToken — varchar(256)
- infoToken — int — PRI
- createdAt — timestamp — NOT NULL
ContentShare
- idx — int — Primary key — NOT NULL — PRI
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL — MUL
- togetherToken — varchar(200) — Foreign key → Together.togetherToken
- feedToken — varchar(256) — Foreign key → Story.feedToken
- infoToken — int — Foreign key → HealingInfo.infoToken — PRI
- createdAt — timestamp — NOT NULL
Event
- eventToken — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- thumbnail — varchar(255) — NOT NULL
- detailImg — varchar(255)
- content — text
- notice — text
- mainBtn — varchar(100)
- createdAt — timestamp — NOT NULL — default_generated
Follow
- idx — int — Primary key — NOT NULL
- following — varchar(200) — Foreign key → User.userToken — NOT NULL — 팔로우 신청한사람
- follower — varchar(200) — Foreign key → User.userToken — NOT NULL — 팔로우 된사람
- createdAt — timestamp — NOT NULL
HealingInfo
- infoToken — int — Primary key — NOT NULL — PRI
- title — varchar(100)
- content — text — NOT NULL
- img — varchar(100) — NOT NULL
- category — varchar(100)
- viewCount — int
- createdAt — timestamp — NOT NULL — default_generated
HealingPhoto
- photoToken — int — Primary key — NOT NULL
- photo — varchar(100) — NOT NULL
- infoToken — int — Foreign key → HealingInfo.infoToken — NOT NULL
- contentType — varchar(100) — NOT NULL
- createdAt — timestamp — NOT NULL
Inquiry
- inquiryToken — varchar(200) — Primary key — NOT NULL
- isAlliance — tinyint(1) — NOT NULL
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL
- title — varchar(255)
- content — text
- answer — text
- category — varchar(100)
- createdAt — timestamp — NOT NULL
InquiryAnswer
- answerToken — int — Primary key — NOT NULL
- inquiryToken — varchar(200) — Foreign key → Inquiry.inquiryToken — NOT NULL
- title — varchar(255)
- answer — text
- createdAt — timestamp — NOT NULL
InquiryPhoto
- photoToken — int — Primary key — NOT NULL
- photo — varchar(100) — NOT NULL
- inquiryToken — varchar(200) — Foreign key → Inquiry.inquiryToken — NOT NULL
- contentType — varchar(100) — NOT NULL
- createdAt — timestamp — NOT NULL
Market
- marketToken — int — Primary key — NOT NULL
- title — varchar(255)
- content — varchar(255)
- price — int
- discount — int
- url — varchar(255)
- photo — varchar(255)
- createdAt — timestamp — NOT NULL
MarketViewUser
- ViewToken — int — Primary key — NOT NULL
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL
- marketToken — int — Foreign key → Market.marketToken — NOT NULL
- createdAt — timestamp — NOT NULL
Notice
- idx — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- thumbnail — varchar(255)
- notice — text
- mainBtn — varchar(100)
- createdAt — timestamp — NOT NULL — default_generated
Notification
- userToken — varchar(256) — Foreign key → User.userToken — NOT NULL — MUL
- fcmToken — varchar(512)
- allowDefault — tinyint(1)
- allowMarketing — tinyint(1)
- allowletter — tinyint(1)
- allowNewHealing — tinyint(1)
- allowNewMessage — tinyint(1)
- allowNewContent — tinyint(1)
- createdAt — timestamp — NOT NULL
Photo
- photoToken — int — Primary key — NOT NULL
- photo — varchar(100) — NOT NULL
- feedToken — varchar(100) — Foreign key → Story.feedToken — NOT NULL
- contentType — varchar(100) — NOT NULL
- createdAt — timestamp — NOT NULL
PointMinus
- idx — int — Primary key — NOT NULL
- userToken — varchar(200) — Foreign key → User.userToken
- point — bigint — NOT NULL
- type — varchar(50)
- createdAt — timestamp — NOT NULL
PointPlus
- idx — int — Primary key — NOT NULL
- userToken — varchar(200) — Foreign key → User.userToken
- point — bigint — NOT NULL
- type — varchar(50)
- createdAt — timestamp — NOT NULL
Region
- regionToken — varchar(20) — Primary key — NOT NULL
- sido — varchar(20) — NOT NULL
- sigungu — varchar(20) — NOT NULL
Story
- feedToken — varchar(200) — Primary key — NOT NULL
- idx — int — NOT NULL
- content — text
- region — varchar(10)
- category — varchar(100)
- userToken — varchar(200) — Foreign key → User.userToken
- viewCount — int
- createdAt — timestamp — NOT NULL
StoryReport
- idx — int — Primary key — NOT NULL
- feedToken — varchar(200) — Foreign key → Story.feedToken — NOT NULL
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL
- reason — text
- createdAt — timestamp — NOT NULL
Test
- testToken — int — Primary key — NOT NULL — PRI
- title — varchar(100)
- url — text — NOT NULL
- img — varchar(100) — NOT NULL
- viewCount — int
- createdAt — timestamp — NOT NULL — default_generated
TestComment
- commentToken — int — Primary key — NOT NULL
- comment — text
- userToken — varchar(200) — Foreign key → User.userToken
- testToken — int — Foreign key → Test.testToken — PRI
- photo — varchar(255)
- createdAt — timestamp
TestCommentReport
- idx — int — Primary key — NOT NULL
- commentToken — int — Foreign key → TestComment.commentToken — NOT NULL
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL
- reason — text
- createdAt — timestamp — NOT NULL
TestLike
- idx — int — Primary key — NOT NULL — PRI
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL — MUL
- testToken — int — Foreign key → Test.testToken — PRI
- createdAt — timestamp — NOT NULL
TestShare
- idx — int — Primary key — NOT NULL — PRI
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL — MUL
- testToken — int — Foreign key → Test.testToken — PRI
- createdAt — timestamp — NOT NULL
TodayHealing
- idx — int — Primary key — NOT NULL
- infoToken (infoToken2) — int — Foreign key → HealingInfo.infoToken — NOT NULL — PRI
- infoToken — int — NOT NULL
- selected — tinyint(1) — NOT NULL
- createdAt — timestamp — NOT NULL — default_generated
Together
- togetherToken — varchar(200) — Primary key — NOT NULL
- title — varchar(100)
- content — text
- peopleNum — int
- location — tinyint(1) — 0=오프라인, 1=온라인
- regionToken — int
- gender — varchar(10)
- ageState — tinyint(1) — 0=무관, 1=직접입력
- firstAge — int
- secondAge — int
- activityState — tinyint(1) — 0=일회성, 1=정기활동
- date — varchar(50)
- category — varchar(100)
- userToken — varchar(200) — Foreign key → User.userToken
- viewCount — int
- createdAt — timestamp — NOT NULL
TogetherPeople
- idx — int — Primary key — NOT NULL — PRI
- userToken — varchar(200) — Foreign key → User.userToken — NOT NULL — MUL
- togetherToken — varchar(200) — Foreign key → Together.togetherToken
- master — tinyint(1)
- createdAt — timestamp — NOT NULL
TogetherPhoto
- photoToken — int — Primary key — NOT NULL
- photo — varchar(100) — NOT NULL
- togetherToken — varchar(100) — Foreign key → Together.togetherToken — NOT NULL
- contentType — varchar(100) — NOT NULL
- createdAt — timestamp — NOT NULL
User
- userToken — varchar(200) — Primary key — NOT NULL
- email — varchar(50)
- name — varchar(20)
- userType — varchar(10) — NOT NULL
- profileImg — varchar(100)
- regionToken — int
- gender — tinyint(1) — 0=남자, 1=여자
- year — year
- createdAt — timestamp — NOT NULL