opengallery_assignment
Tables (6)
Answer (응답)
- id (Key) — Primary key — NOT NULL
- question (설문문항) — Foreign key → Question.id — NOT NULL
- response (응답정보) — Foreign key → Response.Key — NOT NULL
- created (생성일)
- updated (수정일)
- body (내용)
Category (카테고리)
- id (Key) — Primary key — NOT NULL
- survey (pk) — Foreign key → Survey.id — NOT NULL
- name (이름)
- order (순서)
- description (설명)
Question (설문문항)
- id (pk) — Primary key — NOT NULL
- survey (설문조사) — Foreign key → Survey.id — NOT NULL
- category (카테고리) — Foreign key → Category.id — NOT NULL
- text (텍스트)
- order (순서)
- required (필수여부)
- type (문항타입)
- choices (선택문항)
Response (응답정보)
- Key — Primary key — NOT NULL
- user (유저) — Foreign key → User.id — NOT NULL
- survey (설문조사) — Foreign key → Survey.id — NOT NULL
- created (Field)
- updated (Field2)
- interview_uuid (Field3)
Survey (설문조사)
- id (pk) — Primary key — NOT NULL
- name (이름)
- description (설명)
- is_published (발행여부)
- need_logged_user (로그인여부)
- editable_answers (편집가능여부)
- display_method (게시방법)
- template (템플릿)
- publish_date (발행일)
- expire_date (만료일)
- redirect_url (리다이렉트)
User (유저)
- id (Key) — Primary key — NOT NULL
- username (유저이름)
- first_name (이름)
- last_name (성)
- email (이메일)
- is_staff (관리자여부)
- is_active (활성여부)
- date_joined (생성일)