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 — 질문에 대한 답변