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