test-hosung

Tables (5)

consent_type (상위 동의)

  • consent_type_no — Primary key — NOT NULL
  • consent_privacy_id
  • consent_name
  • term_version
  • term_link

consent_user_history (유저-동의-히스토리)

  • consent_user_history_no — Primary key — NOT NULL
  • trace_id
  • account_unique_id
  • consent_id (consnet_id)
  • term_version
  • term_link
  • consent_name
  • consent_yn
  • consent_date
  • consent_version
  • sub_consent_code
  • sub_consent_yn

consent_user_r (유저-동의 맵핑)

  • consent_type_no — 복합키 — Foreign key → consent_type.consent_type_no — NOT NULL
  • oappnoweb_user_no (Key) — Foreign key → user_b.oappnoweb_user_no — NOT NULL
  • sub_consent_type_no — Foreign key → sub_consent_type.sub_consent_type_no — NOT NULL
  • consent_yn (consnet_yn)
  • sub_consent_yn (sub_consnet_yn)
  • consent_date

sub_consent_type (하위 동의)

  • sub_consent_type_no — Primary key — NOT NULL
  • consent_type_no — Foreign key → consent_type.consent_type_no — NOT NULL
  • sub_consent_name
  • sub_consnet_code (sub_consent_code)

user_b (유저테이블)

  • oappnoweb_user_no (Key) — Primary key — NOT NULL