INNER_CIRCLE_SURVEY
Tables (5)
item_response_option
- response_option_seq — int — Primary key — NOT NULL — primary ket
- item_seq — int — Foreign key → survey_item.item_seq — NOT NULL — primary key
- rseponse_option (response_option) — varchar — NOT NULL — 응답 항목
survey
- survey_seq — int — Primary key — NOT NULL — primary key
- survey_name — varchar — NOT NULL — 설문조사 이름
- survey_description — varchar — NOT NULL — 설문조사 설명
- ip_address — varchar — NOT NULL — 계정 정보를 대신할 ip 주소
survey_item
- item_seq — int — Primary key — NOT NULL — primary key
- survey_seq — int — Foreign key → survey.survey_seq — NOT NULL — foriegn key
- item_name — varchar — NOT NULL — 항목 이름
- item_description — varchar — NOT NULL — 항목 설명
- item_response_type — tinyint(1) — NOT NULL — 항목 타입(기본 단답형)
- item_is_required — tinyint(1) — NOT NULL — 항목 필수 응답 여부(기본 false)
- is_deleted — tinyint(1) — NOT NULL — 항목 삭제 여부(기본 false)
survey_response
- response_seq — int — Primary key — NOT NULL — primary key
- item_seq — int — Foreign key → survey_item.item_seq — NOT NULL — primary key
- ip_address — varchar — NOT NULL — 중복 응답을 제한하기 위한 ip 주소
survey_response_detail
- response_detail_seq — int — Primary key — NOT NULL — primary key
- response_option_seq — int — Foreign key → item_response_option.response_option_seq — NOT NULL — primary ket
- response_seq (response_seq2) — int — Foreign key → survey_response.response_seq — NOT NULL — primary key
- response — varchar — NOT NULL — 설문 응답