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