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