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 (생성일)