ods

Tables (24)

education_reference

  • id — BIGINT — Primary key — NOT NULL — 아이디
  • reference_menu_id — BIGINT — Foreign key → education_reference_menu.id — NOT NULL — 메뉴 아이디
  • name — varchar(50) — NOT NULL — 이름
  • file_no — BIGINT — NOT NULL — 파일 번호
  • use_yn — bit — NOT NULL — 사용 여부
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

education_reference_menu

  • id — BIGINT — Primary key — NOT NULL — 아이디
  • name — varchar(30) — NOT NULL — 이름
  • language — varchar(20) — NOT NULL — 언어
  • use_yn — bit — NOT NULL — 사용 여부
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

faq

  • id — bigint — Primary key — NOT NULL
  • click_count — integer — NOT NULL — 클릭 수
  • use_yn — bit — NOT NULL — 사용 여부
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — bigint
  • updated_by — bigint

faq_translation

  • id — bigint — Primary key — NOT NULL
  • faq_id — bigint — Foreign key → faq.id — NOT NULL
  • language — varchar(20) — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — varchar(300) — NOT NULL
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_by — bigint — NOT NULL

marketing_information_receice_terms

  • id — BIGINT — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL — 관리용 제목 (한국어)
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

marketing_information_receice_terms_text_editor_files

  • marketing_terms_id — BIGINT — Foreign key → marketing_information_receice_terms.id — NOT NULL
  • text_editor_files_id — BIGINT — NOT NULL

marketing_information_receice_terms_translation

  • id — BIGINT — Primary key — NOT NULL
  • marketing_terms_id — BIGINT — Foreign key → marketing_information_receice_terms.id — NOT NULL
  • language — varchar(20) — NOT NULL — 언어 코드
  • title — varchar(100) — NOT NULL — 제목
  • html_content — TEXT — NOT NULL — HTML 내용
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_by — BIGINT — NOT NULL

marketing_information_receice_terms_translation_text_editor_files

  • translation_id — BIGINT — Foreign key — NOT NULL
  • text_editor_files_id — BIGINT — NOT NULL

notice

  • id — bigint — Primary key — NOT NULL — 아이디
  • title — varchar(500) — NOT NULL — 제목
  • language — varchar(20) — NOT NULL — 언어
  • content — TEXT — NOT NULL — 내용
  • use_yn — bit — NOT NULL — 사용 여부
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — bigint
  • updated_by — bigint

notice_file

  • notice_id — bigint — Foreign key → notice.id — NOT NULL
  • file_id — bigint — NOT NULL

privacy_process_policy

  • id — BIGINT — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL — 관리용 제목 (한국어)
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

privacy_process_policy_text_editor_files

  • privacy_terms_id — BIGINT — Foreign key → privacy_process_policy.id — NOT NULL
  • text_editor_files_id — BIGINT — NOT NULL

privacy_process_policy_translation

  • id — BIGINT — Primary key — NOT NULL
  • privacy_terms_id — BIGINT — Foreign key → privacy_process_policy.id — NOT NULL
  • language — varchar(20) — NOT NULL — 언어 코드
  • title — varchar(100) — NOT NULL — 제목
  • html_content — TEXT — NOT NULL — HTML 내용
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_by — BIGINT — NOT NULL

privacy_process_policy_translation_text_editor_files

  • translation_id — BIGINT — Foreign key — NOT NULL
  • text_editor_files_id — BIGINT — NOT NULL

privacy_wtcs

  • id — BIGINT — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL — 관리용 제목 (한국어)
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

privacy_wtcs_translation

  • id — BIGINT — Primary key — NOT NULL
  • privacy_contract_id — BIGINT — Foreign key → privacy_wtcs.id — NOT NULL
  • language — varchar(20) — NOT NULL — 언어 코드
  • file_no — BIGINT — NOT NULL — 파일 번호
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_by — BIGINT — NOT NULL

service_utilization_terms

  • id — BIGINT — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL — 관리용 제목 (한국어)
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

service_utilization_terms_text_editor_files

  • service_terms_id — BIGINT — Foreign key → service_utilization_terms.id — NOT NULL
  • text_editor_files_id — BIGINT — NOT NULL

service_utilization_terms_translation

  • id — BIGINT — Primary key — NOT NULL
  • service_terms_id — BIGINT — Foreign key → service_utilization_terms.id — NOT NULL
  • language — varchar(20) — NOT NULL — 언어 코드
  • title — varchar(100) — NOT NULL — 제목
  • html_content — TEXT — NOT NULL — HTML 내용
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_by — BIGINT — NOT NULL

service_utilization_terms_translation_text_editor_files

  • translation_id — BIGINT — Foreign key — NOT NULL
  • text_editor_files_id — BIGINT — NOT NULL

support_reference

  • id — BIGINT — Primary key — NOT NULL — 아이디
  • reference_menu_id — BIGINT — Foreign key → support_reference_menu.id — NOT NULL — 메뉴 아이디
  • name — varchar(50) — NOT NULL — 이름
  • file_no — BIGINT — NOT NULL — 파일 번호
  • use_yn — bit — NOT NULL — 사용 여부
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

support_reference_menu

  • id — BIGINT — Primary key — NOT NULL — 아이디
  • name — varchar(30) — NOT NULL — 이름
  • language — varchar(20) — NOT NULL — 언어
  • use_yn — bit — NOT NULL — 사용 여부
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

task_consign_contract

  • id — BIGINT — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL — 관리용 제목 (한국어)
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT
  • updated_by — BIGINT

task_consign_contract_translation

  • id — BIGINT — Primary key — NOT NULL
  • task_consign_contract_id — BIGINT — Foreign key → task_consign_contract.id — NOT NULL
  • language — varchar(20) — NOT NULL — 언어 코드
  • file_no — BIGINT — NOT NULL — 파일 번호
  • create_dt — datetime(6) — NOT NULL
  • update_dt — datetime(6) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_by — BIGINT — NOT NULL