dodo

Tables (15)

optional_consent (선택동의항목)

  • id (선택동의항목id) — Primary key — NOT NULL

optional_consent (선택동의항목2)

  • id (선택동의항목id) — Primary key — NOT NULL

required_consent (필수동의항목)

  • id (필수동의항목id) — Primary key — NOT NULL

required_consent (필수동의항목2)

  • id (필수동의항목id) — Primary key — NOT NULL

terms (약관)

  • id (약관id) — Primary key — NOT NULL
  • isrequired (필수선택여부)

user (회원)

  • id (회원id) — Primary key — NOT NULL

user (회원2)

  • id (회원id) — Primary key — NOT NULL

user (회원3)

  • id (회원id) — Primary key — NOT NULL

user-terms (회원약관동의여부)

  • consent_id (약관동의여부id) — Primary key — NOT NULL
  • user_id (회원id) — Foreign key → user.id — NOT NULL
  • terms_id (약관id) — Foreign key → terms.id — NOT NULL

user-terms-revision (약관동의여부이력)

  • created_at (생성일) — Primary key — NOT NULL
  • consent_id (약관동의여부id) — Foreign key → user-terms.consent_id — NOT NULL

user_optional_consent (회원 선택동의여부)

  • created_at (생성일) — Primary key — NOT NULL
  • id (회원id) — Foreign key → user.id — NOT NULL
  • optional_id (선택동의항목id) — Foreign key → optional_consent.id — NOT NULL

user_optional_consent (회원선택동의여부2)

  • id (회원선택동의id) — Primary key — NOT NULL
  • user_id (회원id) — Foreign key → user.id — NOT NULL
  • optional_id (선택동의항목id) — Foreign key → optional_consent.id — NOT NULL

user_optional_consent_revision (회원동의여부이력)

  • created_at (생성일) — Primary key — NOT NULL
  • id (회원선택동의id) — Foreign key → user_optional_consent.id — NOT NULL
  • 동의여부 (Field)

user_requirec_consent (회원 필수동의여부)

  • id (회원id) — Foreign key → user.id — NOT NULL
  • required_id (필수동의항목id) — Foreign key → required_consent.id — NOT NULL
  • consented (동의여부)
  • created_at (동의날짜)

user_required_consent (회원필수동의여부2)

  • id (회원id) — Foreign key → user.id — NOT NULL
  • required_id (필수동의항목id) — Foreign key → required_consent.id — NOT NULL