supporters-high
Tables (13)
Banner (배너)
- bannerId (Key) — bigint — Primary key — NOT NULL
- bannerTitle (Field) — varchar
- bannerType (Field2) — char
- linkUrl (Field3) — varchar
- expressionOrder (Field4) — int
- expressionCheck (Field5) — char
- existMediaCheck (Field6) — char
- startPostDate (Field7) — localdate
- endPostDate (Field8) — localdate
- createdAt (Field9) — localdate
- modifiedAt (Field10) — localdate
Category (카테고리)
- categoryId (Key) — bigint — Primary key — NOT NULL
- categoryName (Field) — varchar
- classificationCode (Field2) — varchar
- createdAt (Field3) — localdate
- modifiedAt (Field4) — localdate
Events (이벤트)
Faq (FAQ)
- faqId (Key) — bigint — Primary key — NOT NULL
- question (Field) — varchar
- answer (Field2) — text
- type (Field3) — char
- existMediaCheck (Field4) — char
- createdAt (Field5) — localdate
- modifiedAt (Field6) — localdate
Inquiry (문의)
- inquiryId (Key) — bigint — Primary key — NOT NULL
- inqiuiryTitle (Field) — varchar
- inquiryContent (Field2) — text
- memberId (Field3) — bigint
- nickName (Field4) — varchar
- secretCheck (Field5) — char
- answerCheck (Field6) — char
- answerContent (Field7) — text
- answeredAt (Field8) — localdate
- createdAt (Field9) — localdate
- modifiedAt (Field10) — localdate
Like (좋아요)
- likeId (Key) — bigint — Primary key — NOT NULL
- memberId (Field) — bigint
- meetingId (Field2) — bigint
- createdAt (Field3) — localdate
- modifiedAt (Field4) — localdate
Media (미디어)
- mediaId (Key) — bigint — Primary key — NOT NULL
- mediaTitle (Field) — varchar
- mediaUuidTitle (Field2) — varchar
- mediaUploadUrl (Field3) — varchar
- mediaUrl (Field4) — varchar
- contentType (Field5) — varchar
- type (Field6) — char
- mappingContentId (Field7) — bigint
- representCheck (Field8) — char
- createdAt (Field9) — localdate
- modifiedAt (Field10) — localdate
Meeting (모임)
- meetingId (Key) — bigint — Primary key — NOT NULL
- manager (Field14) — varchar
- managerId (Field15) — bigint
- categoryId (Field) — bigint
- category (Field2) — varchar
- meetingName (Field3) — varchar
- memberLimitCount (Field4) — int
- description (Field5) — text
- address (Field6) — varchar
- region (Field7) — varchar
- participantStatus (Field13) — char
- startAcceptancePeriodDate (Field8) — localdate
- endAcceptancePeriodDate (Field9) — localdate
- status (Field10) — char
- createdAt (Field11) — localdate
- modifiedAt (Field12) — localdate
Member (회원)
- memberId (Key) — bigint — Primary key — NOT NULL
- email (Field) — varchar
- nickName (Field2) — varchar
- password (Field3) — varchar
- accountType (Field4) — char
- address (Field5) — varchar
- birth_number (Field14) — char
- postalCode (Field6) — char
- phone (Field7) — char
- live (Field8) — char
- profileImage (Field11) — varchar
- IntroduceSelf (Field12) — text
- preferCategory (Field13) — varchar
- createdAt (Field9) — localdate
- modifiedAt (Field10) — localdate
Notice (공지사항)
- noticeId (Key) — bigint — Primary key — NOT NULL
- noticeTitle (Field) — varchar
- noticeContent (Field2) — text
- expressionCheck (Field3) — char
- existMediaCheck (Field4) — char
- createdAt (Field5) — localdate
- modifiedAt (Field6) — localdate
ParticipantOfMeeting (모임 참가 정보)
- participantId (Key) — bigint — Primary key — NOT NULL
- memberId (Field) — bigint
- nickName (Field2) — varchar
- meetingId (Field3) — bigint
- meetingName (Field4) — varchar
- createdAt (Field5) — localdate
- modifiedAt (Field6) — localdate
Review (리뷰)
- reviewId (Key) — bigint — Primary key — NOT NULL
- memberId (Field) — bigint
- reviewer (Field2) — varchar
- meetingId (Field3) — bigint
- meetingName (Field4) — varchar
- reviewContent (Field5) — text
- starRate (Field6) — int
- createdAt (Field7) — localdate
- modifiedAt (Field8) — localdate
Token (JWT)
- tokenId (Key) — bigInt — Primary key — NOT NULL
- refreshToken (Field) — varchar
- grantType (Field2) — char
- memberId (Field3) — bigint
- createdAt (Field4) — localdate
- modifiedAt (Field5) — localdate