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