gwk
Tables (29)
member_pers_info_destruction_history
- member_pers_info_destruction_history_seq — BIGINT — Primary key — NOT NULL
- supplier_member_seq — BIGINT — Foreign key → member_supplier_member.supplier_member_seq — NOT NULL
- destruction_reason_code — VARCHAR(20) — NOT NULL
- destruction_datetime — DATETIME — NOT NULL
member_personal_info_agreement_history
- member_personal_info_agreement_history_seq — BIGINT — Primary key — NOT NULL
- personal_info_consent_seq — BIGINT — NOT NULL
- supplier_member_seq — BIGINT — Foreign key → member_supplier_member.supplier_member_seq — NOT NULL
- agree_datetime — DATETIME — NOT NULL
member_personal_info_alert_send
- member_personal_info_alert_send_seq — BIGINT — Primary key — NOT NULL
- member_personal_info_alert_form_seq — BIGINT — NOT NULL
- send_start_datetime — DATETIME
- send_status — VARCHAR(20) — NOT NULL
- input_emp_datetime — DATETIME — NOT NULL
- input_emp_no — VARCHAR(255) — NOT NULL
- update_emp_datetime — DATETIME — NOT NULL
- update_emp_no — VARCHAR(255) — NOT NULL
member_personal_info_alert_send_history
- member_personal_info_alert_send_history_seq — BIGINT — Primary key — NOT NULL
- member_personal_info_alert_send_seq — BIGINT — Foreign key → member_personal_info_alert_send.member_personal_info_alert_send_seq — NOT NULL
- supplier_member_seq — BIGINT — Foreign key → member_supplier_member.supplier_member_seq — NOT NULL
- send_datetime — DATETIME
- send_history_status — VARCHAR(20) — NOT NULL
- input_emp_datetime — DATETIME — NOT NULL
- input_emp_no — VARCHAR(255) — NOT NULL
- update_emp_datetime — DATETIME — NOT NULL
- update_emp_no — VARCHAR(255) — NOT NULL
member_personal_info_parts_agreement
- personal_info_parts_seq — BIGINT — Primary key — NOT NULL
- personal_info_parts_code — VARCHAR(10) — NOT NULL
- collect_purpose — VARCHAR(10) — NOT NULL
- parts_consent_form_description — TEXT — NOT NULL
- collect_start_date — DATE — NOT NULL
- use_flag — TINYINT — NOT NULL
- input_emp_datetime — DATETIME — NOT NULL
- input_emp_no — VARCHAR(255) — NOT NULL
member_personal_info_parts_agreement_history
- personal_info_parts_agreement_history_seq — BIGINT — Primary key — NOT NULL
- supplier_seq — BIGINT — NOT NULL
- supplier_member_seq — BIGINT — Foreign key → member_supplier_member.supplier_member_seq — NOT NULL
- personal_info_parts_seq — BIGINT — Foreign key → member_personal_info_parts_agreement.personal_info_parts_seq — NOT NULL
- agree_datetime — DATETIME — NOT NULL
member_supplier_account
- supplier_account_seq — BIGINT — Primary key — NOT NULL
- supplier_seq — BIGINT — NOT NULL
- sap_account_seq — BIGINT
- nation_code — VARCHAR(20) — NOT NULL
- bank_code — VARCHAR(20)
- bank_name — VARCHAR(200)
- account_no — VARCHAR(500)
- account_holder_name — VARCHAR(200) — NOT NULL
- swift_code — VARCHAR(20)
- bic — VARCHAR(100)
- iban — VARCHAR(100)
- comment — VARCHAR(100) — ARCHAR(100
- account_copy_file_name — VARCHAR(255)
- account_copy_file_path — VARCHAR(400)
- default_account_flag — TINYINT — NOT NULL
- virtual_flag — TINYINT — NOT NULL
- virtual_amount — DECIMAL(20,2)
- use_flag — TINYINT — NOT NULL
- input_emp_datetime — DATETIME
- input_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
- input_member_seq — BIGINT
- input_member_datetime — DATETIME
- update_member_seq — BIGINT
- update_member_datetime — DATETIME
member_supplier_account_change
- supplier_account_change_seq — BIGINT — Primary key — NOT NULL
- supplier_change_seq — BIGINT — Foreign key → member_supplier_change.supplier_change_seq — NOT NULL
- supplier_account_seq — BIGINT
- sap_account_seq — BIGINT
- account_change_code — VARCHAR(20) — NOT NULL
- nation_code — VARCHAR(20) — NOT NULL
- bank_code — VARCHAR(20)
- bank_name — VARCHAR(200)
- account_no — VARCHAR(500)
- account_holder_check_flag — TINYINT — NOT NULL
- account_holder_match_flag — TINYINT
- account_holder_name — VARCHAR(200) — NOT NULL
- actual_account_holder_name — VARCHAR(200)
- swift_code — VARCHAR(20)
- bic — VARCHAR(100)
- iban — VARCHAR(100)
- comment — VARCHAR(100) — ARCHAR(100
- account_copy_file_name — VARCHAR(255)
- account_copy_file_path — VARCHAR(400)
- default_account_flag — TINYINT — NOT NULL
- virtual_flag — TINYINT — NOT NULL
- virtual_amount — DECIMAL(20,2)
- use_flag — TINYINT — NOT NULL
- input_emp_datetime — DATETIME
- input_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
- input_member_seq — BIGINT
- input_member_datetime — DATETIME
- update_member_seq — BIGINT
- update_member_datetime — DATETIME
member_supplier_account_change_separate
- supplier_account_change_separate_seq — BIGINT — Primary key — NOT NULL
- supplier_change_separate_seq — BIGINT — Foreign key → member_supplier_change_separate.supplier_change_separate_seq — NOT NULL
- supplier_account_change_seq — BIGINT — NOT NULL
- bank_name — VARCHAR(200)
- account_no — VARCHAR(500)
- account_holder_name — VARCHAR(200) — NOT NULL
- actual_account_holder_name — VARCHAR(200)
- swift_code — VARCHAR(20)
- bic — VARCHAR(100)
- iban — VARCHAR(100)
- account_copy_file_name — VARCHAR(255)
- account_copy_file_path — VARCHAR(400)
- separate_datetime — DATETIME — NOT NULL
member_supplier_account_separate
- supplier_account_separate_seq — BIGINT — Primary key — NOT NULL
- supplier_separate_seq — BIGINT — NOT NULL
- supplier_account_seq — BIGINT — NOT NULL
- bank_name — VARCHAR(200)
- account_no — VARCHAR(500)
- account_holder_name — VARCHAR(200) — NOT NULL
- swift_code — VARCHAR(20)
- bic — VARCHAR(100)
- iban — VARCHAR(100)
- account_copy_file_name — VARCHAR(255)
- account_copy_file_path — VARCHAR(400)
- separate_datetime — DATETIME — NOT NULL
member_supplier_change
- supplier_change_seq — BIGINT — Primary key — NOT NULL
- supplier_seq — BIGINT — NOT NULL
- request_flag — TINYINT — NOT NULL
- requester_code — VARCHAR(20)
- supplier_change_code — VARCHAR(20) — NOT NULL
- before_supplier_name — VARCHAR(200)
- before_owner_name — VARCHAR(200)
- before_owner_foreigner_flag — TINYINT
- before_main_member_seq — BIGINT
- before_business_item — VARCHAR(200)
- before_business_type — VARCHAR(200)
- before_post_no — VARCHAR(50)
- before_main_address — VARCHAR(500)
- before_sub_address — VARCHAR(500)
- before_telephone_no — VARCHAR(50)
- before_nation_code — VARCHAR(20)
- before_portal_use_flag — TINYINT
- before_delivery_plan_flag — TINYINT
- before_currency_code — VARCHAR(20)
- before_art_insurance_flag — TINYINT
- after_supplier_name — VARCHAR(200) — NOT NULL
- after_owner_name — VARCHAR(200) — NOT NULL
- after_owner_foreigner_flag — TINYINT — NOT NULL
- after_main_member_seq — BIGINT
- after_business_item — VARCHAR(200)
- after_business_type — VARCHAR(200)
- after_post_no — VARCHAR(50)
- after_main_address — VARCHAR(500)
- after_sub_address — VARCHAR(500)
- after_telephone_no — VARCHAR(50) — NOT NULL
- after_nation_code — VARCHAR(20)
- after_portal_use_flag — TINYINT — NOT NULL
- after_delivery_plan_flag — TINYINT — NOT NULL
- after_currency_code — VARCHAR(20)
- after_art_insurance_flag — TINYINT — NOT NULL
- account_change_flag — TINYINT — NOT NULL
- supplier_withdrawal_reason_code — VARCHAR(20)
- supplier_withdrawal_requester — VARCHAR(20)
- change_request_reason — VARCHAR(200)
- change_approval_reason — VARCHAR(200)
- request_status — VARCHAR(20) — NOT NULL
- input_emp_datetime — DATETIME
- input_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
- input_member_seq — BIGINT
- input_member_datetime — DATETIME
- update_member_seq — BIGINT
- update_member_datetime — DATETIME
member_supplier_change_separate
- supplier_change_separate_seq — BIGINT — Primary key — NOT NULL
- supplier_separate_seq — BIGINT — NOT NULL
- supplier_change_seq — BIGINT — NOT NULL
- before_supplier_name — VARCHAR(200)
- before_owner_name — VARCHAR(200)
- before_post_no — VARCHAR(50)
- before_main_address — VARCHAR(500)
- before_sub_address — VARCHAR(500)
- before_telephone_no — VARCHAR(50)
- after_supplier_name — VARCHAR(200) — NOT NULL
- after_owner_name — VARCHAR(200) — NOT NULL
- after_post_no — VARCHAR(50)
- after_main_address — VARCHAR(500)
- after_sub_address — VARCHAR(500)
- after_telephone_no — VARCHAR(50) — NOT NULL
- separate_datetime — DATETIME — NOT NULL
member_supplier_esg_checklist
- member_supplier_esg_checklist_seq — BIGINT — Primary key — NOT NULL
- member_supplier_esg_form_seq — BIGINT — Foreign key → member_supplier_esg_form.member_supplier_esg_form_seq — NOT NULL
- esg_group — VARCHAR(20) — NOT NULL
- description — VARCHAR(500)
- sort_seq — INT — NOT NULL
- input_emp_no — VARCHAR(255)
- input_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
member_supplier_esg_form
- member_supplier_esg_form_seq — BIGINT — Primary key — NOT NULL
- start_date — DATE — NOT NULL
- status — VARCHAR(20) — NOT NULL
- input_emp_no — VARCHAR(255)
- input_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
member_supplier_esg_submit_checklist
- member_supplier_esg_submit_checklist_seq — BIGINT — Primary key — NOT NULL
- member_supplier_esg_submit_history_seq — BIGINT — Foreign key → member_supplier_esg_submit_history.member_supplier_esg_submit_history_seq — NOT NULL
- member_supplier_esg_checklist_seq — BIGINT — Foreign key → member_supplier_esg_checklist.member_supplier_esg_checklist_seq — NOT NULL
- esg_submit_response — TINYINT — NOT NULL
member_supplier_esg_submit_history
- member_supplier_esg_submit_history_seq — BIGINT — Primary key — NOT NULL
- supplier_change_seq — BIGINT — Foreign key → member_supplier_change.supplier_change_seq — NOT NULL
- member_supplier_esg_form_seq — BIGINT — Foreign key → member_supplier_esg_form.member_supplier_esg_form_seq — NOT NULL
- esg_submit_opinion — TEXT
- input_member_seq — BIGINT
- input_member_datetime — DATETIME
member_supplier_individual
- supplier_id_seq — BIGINT — Primary key — NOT NULL
- supplier_seq — BIGINT
- resid_number — VARCHAR(1500)
- resid_file_name — VARCHAR(255)
- resid_file_path — VARCHAR(400)
- input_member_seq — BIGINT
- input_member_datetime — DATETIME
- update_member_seq — BIGINT
- update_member_datetime — DATETIME
member_supplier_individual_separate
- member_supplier_individual_separate_seq — BIGINT — Primary key — NOT NULL
- supplier_separate_seq — BIGINT — NOT NULL
- supplier_id_seq — BIGINT — NOT NULL
- supplier_seq — BIGINT
- resid_number — VARCHAR(1500)
- resid_file_name — VARCHAR(255)
- resid_file_path — VARCHAR(400)
- separate_datetime — DATETIME — NOT NULL
member_supplier_member
- supplier_member_seq — BIGINT — Primary key — NOT NULL
- supplier_seq — BIGINT — NOT NULL
- supplier_member_division_code — VARCHAR(20)
- id — VARCHAR(320) — NOT NULL
- password — VARCHAR(1500) — NOT NULL
- password_salt — VARCHAR(1500) — NOT NULL
- pre_password — VARCHAR(1500)
- pre_password_salt — VARCHAR(1500)
- password_reset_flag — TINYINT — NOT NULL
- name — VARCHAR(320) — NOT NULL
- mail_address — VARCHAR(200) — NOT NULL
- mail_confirm_flag — TINYINT — NOT NULL
- birth_date — DATE — NOT NULL
- sex — VARCHAR(20) — NOT NULL
- foreigner_flag — TINYINT — NOT NULL
- telephone_no — VARCHAR(50)
- mobile_no — VARCHAR(50) — NOT NULL
- department_name — VARCHAR(200)
- level_division — VARCHAR(100)
- last_login_success_datetime — DATETIME
- last_password_change_datetime — DATETIME — NOT NULL
- last_password_extension_datetime — DATETIME
- regist_request_datetime — DATETIME — NOT NULL
- regist_approval_datetime — DATETIME
- member_status — VARCHAR(20) — NOT NULL
- dormant_flag — TINYINT — NOT NULL
- member_separate_seq — BIGINT
- dormant_datetime — DATETIME
- member_withdrawal_reason_code — VARCHAR(20)
- withdrawal_reason — VARCHAR(200)
- member_withdrawal_requester — VARCHAR(50)
- withdrawal_datetime — DATETIME
- input_emp_datetime — DATETIME
- input_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
- input_member_seq — BIGINT
- input_member_datetime — DATETIME
- update_member_seq — BIGINT
- update_member_datetime — DATETIME
member_supplier_member_return_history
- supplier_member_return_history_seq — BIGINT — Primary key — NOT NULL
- supplier_member_seq — BIGINT — Foreign key → member_supplier_member.supplier_member_seq — NOT NULL
- member_change_code — VARCHAR(20) — NOT NULL
- member_withdrawal_reason_code — VARCHAR(20)
- change_request_reason — VARCHAR(200)
- change_approval_reason — VARCHAR(200)
- input_member_seq — BIGINT
- input_member_datetime — DATETIME
- update_member_seq — BIGINT
- update_member_datetime — DATETIME
- input_emp_no — VARCHAR(255)
- input_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
member_supplier_member_separate
- supplier_member_separate_seq — BIGINT — Primary key — NOT NULL
- supplier_member_seq — BIGINT — NOT NULL
- name — VARCHAR(320) — NOT NULL
- mail_address — VARCHAR(200) — NOT NULL
- birth_date — DATE — NOT NULL
- sex — VARCHAR(20) — NOT NULL
- telephone_no — VARCHAR(50)
- mobile_no — VARCHAR(50) — NOT NULL
- department_name — VARCHAR(200)
- level_division — VARCHAR(100)
- separate_datetime — DATETIME — NOT NULL
member_supplier_portal_unused_pers_info
- member_supplier_portal_unused_pers_info_seq — BIGINT — Primary key — NOT NULL
- supplier_seq — BIGINT — NOT NULL
- birth_date — DATE
- sex — VARCHAR(20)
- input_emp_no — VARCHAR(255)
- input_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
member_supplier_rating_interface_log
- rating_interface_log_seq — BIGINT — Primary key — NOT NULL
- interface_type — VARCHAR(20) — NOT NULL
- success_flag — BOOLEAN — NOT NULL
- interface_datetime — DATETIME — NOT NULL
- interface_emp_no — VARCHAR(255) — NOT NULL
member_supplier_sap_approval
- supplier_sap_seq — BIGINT — Primary key — NOT NULL
- supplier_seq — BIGINT — NOT NULL
- sap_connect_status — VARCHAR(20) — NOT NULL
- sap_reg_type — VARCHAR(20)
- payment_req_date — DATE
- reg_date — DATE — NOT NULL
- member_division — VARCHAR(20) — NOT NULL
- business_division — VARCHAR(20)
- supplier_name — VARCHAR(200) — NOT NULL
- owner_name — VARCHAR(200)
- owner_foreigner_flag — TINYINT — NOT NULL
- main_member_seq — BIGINT
- business_no — VARCHAR(50)
- corporation_no — VARCHAR(50)
- business_item — VARCHAR(200)
- business_type — VARCHAR(200)
- post_no — VARCHAR(50)
- main_address — VARCHAR(500)
- sub_address — VARCHAR(500)
- telephone_no — VARCHAR(50) — NOT NULL
- nation_code — VARCHAR(20)
- portal_use_flag — TINYINT — NOT NULL
- portal_use_conversion_flag — TINYINT — NOT NULL
- sap_supplier_seq — VARCHAR(10)
- sap_reg_datetime — DATETIME
- employee_no — VARCHAR(255)
- business_file_name — VARCHAR(255)
- business_file_path — VARCHAR(400)
- comment — TEXT — EX
- currency_code — VARCHAR(20)
- art_insurance_flag — TINYINT — NOT NULL
- account_code — VARCHAR(10)
- payment_term — VARCHAR(10)
- payment_method — VARCHAR(10)
- approval_seq — BIGINT
- sap_result_status — VARCHAR(20)
- sap_result_message — VARCHAR(2000)
- input_emp_datetime — DATETIME
- input_emp_no — VARCHAR(255)
- update_emp_datetime — DATETIME
- update_emp_no — VARCHAR(255)
member_supplier_sap_approval_account_separate
- supplier_sap_approval_account_separate_seq — BIGINT — Primary key — NOT NULL
- supplier_sap_approval_separate_seq — BIGINT — Foreign key → member_supplier_sap_approval_separate.supplier_sap_approval_separate_seq — NOT NULL
- supplier_sap_account_seq — BIGINT — NOT NULL
- supplier_account_seq — BIGINT — NOT NULL
- bank_name — VARCHAR(200)
- account_no — VARCHAR(500)
- account_holder_name — VARCHAR(200) — NOT NULL
- swift_code — VARCHAR(20)
- bic — VARCHAR(100)
- iban — VARCHAR(100)
- account_copy_file_name — VARCHAR(255)
- account_copy_file_path — VARCHAR(400)
- separate_datetime — DATETIME — NOT NULL
member_supplier_sap_approval_separate
- supplier_sap_approval_separate_seq — BIGINT — Primary key — NOT NULL
- supplier_separate_seq — BIGINT — NOT NULL
- supplier_sap_seq — BIGINT — NOT NULL
- supplier_seq — BIGINT — NOT NULL
- supplier_name — VARCHAR(200) — NOT NULL
- owner_name — VARCHAR(200)
- post_no — VARCHAR(50)
- main_address — VARCHAR(500)
- sub_address — VARCHAR(500)
- telephone_no — VARCHAR(50) — NOT NULL
- business_file_name — VARCHAR(255)
- business_file_path — VARCHAR(400)
- separate_datetime — DATETIME — NOT NULL
member_terms_agree_history
- member_terms_agree_history_seq — BIGINT — Primary key — NOT NULL
- terms_seq — BIGINT — Foreign key → member_terms_agreement.terms_seq — NOT NULL
- supplier_member_seq — BIGINT — Foreign key → member_supplier_member.supplier_member_seq — NOT NULL
- agree_datetime — DATETIME — NOT NULL
member_terms_agreement
- terms_seq — BIGINT — Primary key — NOT NULL
- notice_date — DATE — NOT NULL
- act_date — DATE — NOT NULL
- terms_description — TEXT — NOT NULL
- terms_description_summary — TEXT — NOT NULL
- revision_consent_flag — TINYINT — NOT NULL
- save_status — VARCHAR(20) — NOT NULL
- input_emp_datetime — DATETIME — NOT NULL
- input_emp_no — VARCHAR(255) — NOT NULL
- update_emp_datetime — DATETIME — NOT NULL
- update_emp_no — VARCHAR(255) — NOT NULL
supplier_portal_use_convert_token
- portal_use_convert_token_seq — BIGINT — Primary key — NOT NULL
- supplier_seq — BIGINT — NOT NULL
- email_address — VARCHAR(200) — NOT NULL
- token — VARCHAR(200) — NOT NULL
- issue_datetime — DATETIME — NOT NULL
- token_due_datetime — DATETIME — NOT NULL
- token_success_flag — TINYINT — NOT NULL
- token_success_datetime — DATETIME
- input_emp_datetime — DATETIME — NOT NULL
- input_emp_no — VARCHAR(255) — NOT NULL
- update_emp_datetime — DATETIME — NOT NULL
- update_emp_no — VARCHAR(255) — NOT NULL