ERPS

Tables (32)

mst_authority

  • name — varchar(50) — Primary key — NOT NULL

mst_company_authority

  • authority_name — varchar(50) — Foreign key → mst_authority.name — NOT NULL
  • cmpy_cd — varchar(8) — Foreign key → sys_company.cmpy_cd — NOT NULL

mst_sys_user_authority

  • authority_name — varchar(50) — Foreign key → mst_authority.name — NOT NULL
  • user_id — int8 — Foreign key → sys_user.id — NOT NULL

mst_tenant_user_authority

  • authority_name — varchar(50) — Foreign key → mst_authority.name — NOT NULL
  • user_id — int8 — Foreign key → tenant_user.id — NOT NULL

sys_company

  • cmpy_cd — varchar(8) — Primary key — NOT NULL
  • cmpy_name — varchar(60)
  • biz_reg_no — varchar(10)
  • biz_crn_ssn — varchar(13)
  • biz_rpstv_name — varchar(60)
  • biz_address_1 — varchar(200)
  • biz_address_2 — varchar(200)
  • biz_tel_no — varchar(25)
  • db_conn_nm — varchar(20)
  • db_conn_url — varchar(1000)
  • db_conn_user — varchar(30)
  • db_conn_pwd — varchar(30)
  • entity — varchar(10)
  • mngr_name — varchar(60)
  • mngr_tel_no — varchar(20)
  • mngr_email_address — varchar(60)
  • mngr_user_id — varchar(10)
  • use_yn — varchar(1)
  • activation_key — varchar(20)
  • reset_key — varchar(20)
  • created_date — timestamp(6)
  • reset_date — timestamp(6)

sys_company_config

  • id — int8 — Primary key — NOT NULL
  • cmpy_cd — varchar(8) — Foreign key → sys_company.cmpy_cd — NOT NULL
  • work_time — int4
  • away_time — int4
  • storage_size — int4
  • used_storage_size — int4
  • limit_file_size — int4
  • limit_file_count — int4
  • use_file_sharing — bool
  • service_level — varchar(1) — (B: Basic, P: Premium)
  • use_approve_func — bool
  • use_privacy_policy — bool
  • api_key — varchar(64)
  • last_update_date — date

sys_company_media_policy

  • id — int8 — Primary key — NOT NULL
  • is_approve_used — bool
  • cmpy_cd — varchar(8) — Foreign key → sys_company.cmpy_cd — NOT NULL
  • sys_media_prototype_id — int8 — Foreign key → sys_media_policy_prototype.id — NOT NULL

sys_company_privacy_policy

  • id — int8 — Primary key — NOT NULL
  • is_approve_used — bool
  • cmpy_cd — varchar(8) — Foreign key → sys_company.cmpy_cd — NOT NULL
  • sys_privacy_prototype_id — int8 — Foreign key → sys_privacy_policy_prototype.id — NOT NULL

sys_global_config

  • id — int8 — Primary key — NOT NULL
  • work_time — int4
  • away_time — int4
  • storage_size — int4
  • used_storage_size — int4
  • limit_file_size — int4
  • limit_file_count — int4

sys_media_policy_prototype

  • id — int8 — Primary key — NOT NULL
  • name — varchar(256)
  • description — TEXT
  • policy_usb — varchar(64)
  • policy_cdrw — varchar(64)
  • policy_mtp — varchar(64)
  • policy_web_attach — varchar(64)
  • policy_outlook_attach — varchar(64)

sys_privacy_pattern_prototype

  • id — int8 — Primary key — NOT NULL
  • name — varchar(256)
  • description — TEXT
  • pattern — TEXT
  • keyword — TEXT
  • is_default — bool

sys_privacy_pattern_set_prototype

  • id — int8 — Primary key — NOT NULL
  • name — varchar(256)
  • description — TEXT
  • policy_logging_block — bool
  • pattern — TEXT
  • keyword — TEXT
  • sys_privacy_policy_prototype_id — int8 — Foreign key → sys_privacy_policy_prototype.id — NOT NULL
  • sys_privacy_pattern_prototype_id — int8 — Foreign key → sys_privacy_pattern_prototype.id — NOT NULL
  • is_default — bool

sys_privacy_policy_prototype

  • id — int8 — Primary key — NOT NULL
  • name — varchar(256)
  • description — TEXT

sys_user

  • id — int8 — Primary key — NOT NULL
  • login — varchar(50) — NOT NULL
  • password_hash — varchar(60) — NOT NULL
  • first_name — varchar(50)
  • last_name — varchar(50)
  • email — varchar(191)
  • image_url — varchar(256)
  • activated — bool — NOT NULL
  • lang_key — varchar(10)
  • activation_key — varchar(20)
  • reset_key — varchar(20)
  • created_by — varchar(50) — NOT NULL
  • created_date — timestamp(6)
  • reset_date — timestamp(6)
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp(6)

sys_user_token

  • id — int8 — Primary key — NOT NULL
  • sys_user_id — int8 — Foreign key → sys_user.id — NOT NULL
  • token — varchar(256)
  • issue_time — timestamp(6)
  • login_type — varchar(64)
  • ip_addr — varchar(16)

tenant_company_status

  • id — int8 — Primary key — NOT NULL
  • cmpy_cd — varchar(8) — Foreign key → sys_company.cmpy_cd — NOT NULL
  • agent_count — int4
  • limit_license — int4
  • used_license — int4
  • default_policy_count — int4
  • except_policy_count — int4

tenant_dept_group

  • id — int8 — Primary key — NOT NULL
  • dept_code — varchar(128) — NOT NULL
  • dept_name — varchar(256)
  • using — boolean — (Y/N)
  • cmpy_cd — varchar(8) — Foreign key

tenant_external_receiver

  • id — int8 — Primary key — NOT NULL
  • name — varchar(128)
  • memo — TEXT
  • email_address — varchar(128)
  • tel_no — varchar(64)
  • enc_key — varchar(64)

tenant_file_share

  • id — int8 — Primary key — NOT NULL
  • approval_status — varchar(32) — REQUEST: request for approval, REJECT: rejection, APPOVE: approval, DETECT: cancellation due to detection of personal i…
  • permission — varchar(16) — (READONLY: read only, WRITE: edit)
  • type — varchar(255) — (INTERNAL: Internal, EXTERNAL: External)
  • request_start — timestamp(6)
  • request_end — timestamp(6) — Time to complete approval (rejection, cancellation, personal information detection)
  • request_memo — TEXT
  • finish_memo — TEXT
  • download_period — timestamp(6)
  • file_name — varchar(512)
  • file_size — varchar(16)
  • file_uri — varchar(512)
  • first_download_time — timestamp(6)
  • tenant_user_id — int8 — Foreign key → tenant_user.id
  • tenant_approval_line_id — varchar(64)
  • tenant_internal_receiver_id — int8 — NOT NULL
  • tenant_external_receiver_id — int8

tenant_log_media

  • id — int8 — Primary key — NOT NULL
  • time_stamp — timestamp(6)
  • user_name — varchar(64)
  • emp_no — varchar(64)
  • dept_name — varchar(128)
  • pos_cd — varchar(128)
  • rol_cd — varchar(128)
  • fun_cd — varchar(128)
  • usr_tp — varchar(128)
  • email_addr — varchar(128)
  • log_type — varchar(128) — onLine, offLine
  • log_media_type — varchar(128) — NOT NULL — USB,CDRW, SMARTPHONE, WEBATTACH, OUTLOOKATTACH
  • log_operation — varchar(32) — NOT NULL — READ|WRITE
  • log_allow_deny — varchar(32) — (A: allowed, D: blocked)
  • log_process — varchar(512)
  • log_file_name — varchar(512)
  • log_file_size — varchar(16)
  • tenant_user_id — int8 — Foreign key → tenant_user.id
  • tenant_media_policy_id — int8 — Foreign key → tenant_media_policy.id

tenant_log_privacy

  • id — int8 — Primary key — NOT NULL
  • time_stamp — timestamp(6)
  • user_name — varchar(64)
  • emp_no — varchar(64)
  • pos_cd — varchar(128)
  • rol_cd — varchar(128)
  • fun_cd — varchar(128)
  • usr_tp — varchar(128)
  • email_addr — varchar(128)
  • detect_count — INTEGER
  • log_allow_deny — varchar(32) — (A: allowed, D: blocked)
  • log_file_name — varchar(512)
  • log_file_size — varchar(16) — NOT NULL
  • tenant_user_id — int8 — Foreign key → tenant_user.id
  • tenant_file_share_id — int8 — Foreign key → tenant_file_share.id
  • tenant_privacy_pattern_set_id — int8 — Foreign key → tenant_privacy_pattern_set.id
  • dept_name — varchar(128) — NOT NULL

tenant_log_process

  • id — int8 — Primary key — NOT NULL
  • timestamp — timestamp(6)
  • non_business — varchar(8)
  • process_name — varchar(512)
  • allow_deny — varchar(8)
  • process_hash — varchar(256)
  • process_size — int4
  • tenant_user_id — int8 — Foreign key → tenant_user.id

tenant_log_url

  • id — int8 — Primary key — NOT NULL
  • timestamp — timestamp(6)
  • non_business — varchar(8)
  • url — varchar(512)
  • allow_deny — varchar(8)
  • tenant_user_id — int8 — Foreign key → tenant_user.id

tenant_media_policy

  • id — int8 — Primary key — NOT NULL
  • cmpy_cd — varchar(8) — Foreign key → sys_company.cmpy_cd — NOT NULL
  • name — varchar(256)
  • description — TEXT
  • policy_usb — varchar(64)
  • policy_cdrw — varchar(64)
  • policy_mtp — varchar(64)
  • policy_web_attach — varchar(64)
  • policy_outlook_attach — varchar(64)
  • policy_type — INTERGER — NOT NULL — 0: none, 1: default, 2 except
  • sys_company_media_policy_id — INTERGER — NOT NULL

tenant_otp

  • id — int8 — Primary key — NOT NULL
  • expired_date — timestamp(6)
  • opt_code — varchar(8)
  • tenant_user_id — int8
  • tenant_file_share_id — int8 — Foreign key → tenant_file_share.id

tenant_privacy_pattern_set

  • id — int8 — Primary key — NOT NULL
  • sys_privacy_pattern_set_prototype_id — INTEGER — NOT NULL
  • name — varchar(256)
  • description — TEXT
  • pattern — TEXT
  • keywork — TEXT
  • tenant_privacy_policy_id — int8 — Foreign key → tenant_privacy_policy.id
  • is_logging — bool — NOT NULL
  • is_blocking — bool — NOT NULL

tenant_privacy_policy

  • id — int8 — Primary key — NOT NULL
  • cmpy_cd — varchar(8) — Foreign key → sys_company.cmpy_cd — NOT NULL
  • name — varchar(256)
  • description — TEXT
  • sys_company_privacy_policy_id — INTERGER — NOT NULL
  • policy_type — INTERGER — NOT NULL — 0: none, 1: default, 2 except

tenant_tna

  • id — int8 — Primary key — NOT NULL
  • date_time — timestamp(6)
  • day_of_week — varchar(16)
  • start_time — timestamp(6)
  • finish_time — timestamp(6)
  • is_vacation — varchar(16)
  • is_holiday — varchar(16)
  • tenant_user_id — int8 — Foreign key → tenant_user.id

tenant_user

  • id — int8 — Primary key — NOT NULL
  • tenant_dept_group_id — int8 — Foreign key → tenant_dept_group.id
  • cmpy_cd — varchar(8) — NOT NULL
  • user_id — varchar(128)
  • username — varchar(64)
  • user_type — varchar(4) — (01: Employee, 99: Other)
  • empno — varchar(64)
  • poscd — varchar(128)
  • rolcd — varchar(128)
  • funcd — varchar(128)
  • usrtp — varchar(64) — (A: System administrator, U: General user)
  • email_addr — varchar(128)
  • telno — varchar(32)
  • pwd — varchar(256) — NOT NULL
  • delegate_approval_userid — varchar(64)
  • delegate_approval_date_from — varchar(64)
  • delegate_approval_date_to — varchar(64)
  • heartbeat — timestamp(6)
  • agent_install — varchar(1)
  • memo — TEXT
  • image_url — varchar(256)
  • activated — bool — NOT NULL
  • lang_key — varchar(2)
  • activation_key — varchar(20)
  • reset_key — varchar(20)
  • created_date — timestamp(6)
  • reset_date — timestamp(6)

tenant_user_policy_status

  • id — int8 — Primary key — NOT NULL
  • tenant_user_id — int8 — Foreign key → tenant_user.id — NOT NULL
  • except_media — boolean
  • except_privacy — boolean
  • memo — TEXT

tenant_user_reg_key

  • id — int8 — Primary key — NOT NULL
  • tenant_user_id — int8 — Foreign key → tenant_user.id — NOT NULL
  • reg_key — varchar(6)
  • registed — varchar(1)

tenant_user_token

  • id — int8 — Primary key — NOT NULL
  • token — varchar(256)
  • issue_time — timestamp(6)
  • login_type — varchar(64)
  • ip_addr — varchar(16)
  • tenant_user_id — int8 — Foreign key → tenant_user.id