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