survey

Tables (13)

BizProfile (biz_profile)

  • Key — Primary key — NOT NULL
  • businessId (business_id) — varchar(50) — NOT NULL
  • name — varchar(30) — NOT NULL
  • imageUrl (image_url) — varchar(50)
  • profileUrl (profile_url) — varchar(1000) — NOT NULL
  • Field

Member (member)

  • id — Long — Primary key — NOT NULL — member pk
  • daangnId (daangn_id) — String — NOT NULL — 당근 고유 아이디(유저, 비즈프로필)
  • name — varchar(30) — NOT NULL — 당근 이름
  • imageUrl (image_url) — varchar(255) — 프로필 이미지 url
  • role — String — NOT NULL — 역할(사용자, 비즈니스)
  • region — varchar(255) — 가게 위치
  • profileUrl (profile_url) — varchar(1000) — 프로필 url
  • bizCategory (biz_category) — varchar(50)

Notification

  • id — Long — Primary key — NOT NULL — 알림 pk
  • memberId (member_id) — Long — Foreign key → Member.id — NOT NULL — member pk
  • subject — String — NOT NULL — 알림 주제
  • type — String — NOT NULL — 알림 타입(채팅)
  • isNotifying (is_notifying) — boolean — NOT NULL — 알림을 받을건지

ShortUrl

  • id — Long — Primary key — NOT NULL
  • shortUrl (short_url) — varchar(1000) — NOT NULL
  • originUrl (origin_url) — varchar(1000) — NOT NULL
  • schemeUrl (scheme_url) — varchar(1000)
  • reqCount (req_count) — long — NOT NULL
  • createdAt (created_at) — LocalDateTime — NOT NULL
  • modifiedAt (modified_at) — LocalDateTime — NOT NULL — 마지막으로 수정한 날짜

SurveyInfo (survey_info)

  • id — Long — Primary key — NOT NULL — ID
  • writerDaangnId (writer_daangn_id) — Long — NOT NULL — 작성자 id
  • writerType (writer_type) — Enum — NOT NULL — 작성자 type

choice

  • id — Long — Primary key — NOT NULL — choice pk
  • questionId (question_id) — Long — Foreign key → question.id — NOT NULL — question pk
  • number — int — NOT NULL — 선택지 번호
  • value — varchar(30) — NOT NULL — 선택지 값

choiceResponse (choice_response)

  • id — Long — Primary key — NOT NULL — choice response pk
  • surveyResponseId (survey_response_id) — Long — Foreign key → surveyResponse.id — NOT NULL — survey_response_id
  • choiceId (choice_id) — Long — Foreign key → choice.id — NOT NULL — choice pk
  • questionId (question_id) — Long — Foreign key → question.id — NOT NULL — question pk

feedback

  • id — Long — Primary key — NOT NULL — feedback pk
  • memberId (member_id) — Long — Foreign key → Member.id — NOT NULL — member pk
  • question — varchar(255) — NOT NULL — 질문
  • answer — varchar(255) — 답변

question

  • id — Long — Primary key — NOT NULL — question pk
  • surveyId (survey_id) — Long — Foreign key → survey.id — NOT NULL — survey pk
  • questionTypeId (question_type_id) — Long — Foreign key → questionType.id — NOT NULL — question type code
  • number — int — NOT NULL — 질문 번호
  • text — varchar(200) — 질문명
  • description — varchar(200) — 설명
  • createdAt (created_at) — LocalDateTime — NOT NULL

questionType (question_type)

  • id — Long — Primary key — NOT NULL — question type code
  • name — varchar(30) — NOT NULL

survey

  • id — Long — Primary key — NOT NULL — survey pk
  • memberId (member_id) — Long — Foreign key → Member.id — NOT NULL — member pk
  • title — varchar(50) — NOT NULL — 제목
  • target — int — NOT NULL — 0: 모두, 1: 단골, 2:비즈 프로필 방문자
  • publishedAt (published_at) — LocalDateTime
  • isDeleted (is_deleted) — boolean — NOT NULL — 설문 삭제 여부
  • createdAt (created_at) — LocalDateTime — NOT NULL

surveyResponse (survey_response)

  • id — Long — Primary key — NOT NULL — survey_response_id
  • memberId (member_id) — Long — Foreign key → Member.id — NOT NULL — member pk
  • surveyId (survey_id) — Long — Foreign key → survey.id — NOT NULL — survey pk
  • createdAt (created_at) — LocalDateTime — NOT NULL

textResponse (text_response)

  • id — Long — Primary key — NOT NULL — text response pk
  • questionId (question_id) — Long — Foreign key → question.id — NOT NULL — question pk
  • surveyResponseId (survey_response_id) — Long — Foreign key → surveyResponse.id — NOT NULL — survey_response_id
  • answer — varchar(100) — NOT NULL — 질문에 대한 답변