neo dev

Tables (15)

nems_account

  • account_uuid — UUID — Primary key — NOT NULL
  • user_uuid — UUID — Foreign key → nems_user.user_uuid — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • user_pw — VARCHAR(255) — NOT NULL
  • user_role_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • account_status_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • last_login_dttm — TIMESTAMP
  • login_fail_cnt — SMALLINT — NOT NULL
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_code

  • cd — VARCHAR(20) — Primary key — NOT NULL
  • cd_gr_id — VARCHAR(20) — Foreign key → nems_code_group.cd_gr_id — NOT NULL
  • cd_nm — VARCHAR(30) — NOT NULL
  • cd_desc — VARCHAR(255)
  • sort_order — SMALLINT — NOT NULL
  • usage_count — INTEGER — NOT NULL
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_code_group

  • cd_gr_id — VARCHAR(20) — Primary key — NOT NULL
  • cd_gr_nm — VARCHAR(50) — NOT NULL
  • cd_gr_desc — VARCHAR(255)
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_eqp

  • eqp_uuid — UUID — Primary key — NOT NULL
  • eqp_mgnt_no — VARCHAR(20) — NOT NULL
  • eqp_type_cd — VARCHAR(20) — NOT NULL
  • eqp_name — VARCHAR(150)
  • eqp_model — VARCHAR(100) — NOT NULL
  • eqp_sn — VARCHAR(50)
  • eqp_scrn_size — VARCHAR(10)
  • eqp_mfr_cd — VARCHAR(20)
  • eqp_mfr_dt — DATE
  • eqp_cpu — VARCHAR(50)
  • eqp_ram — VARCHAR(10)
  • eqp_hdd_ssd — VARCHAR(10)
  • eqp_os_cd — VARCHAR(20)
  • eqp_os_ver — VARCHAR(20)
  • eqp_imei — VARCHAR(30)
  • eqp_wifi_mac — VARCHAR(20)
  • eqp_usim_yn — BOOLEAN — NOT NULL
  • eqp_telecom_cd — VARCHAR(20)
  • eqp_tel — VARCHAR(15)
  • eqp_pw — VARCHAR(50)
  • eqp_desc — VARCHAR(255)
  • eqp_status_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_eqp_dispose

  • dispose_uuid — UUID — Primary key — NOT NULL
  • eqp_uuid — UUID — Foreign key → nems_eqp.eqp_uuid — NOT NULL
  • dispose_dt — DATE — NOT NULL
  • dispose_reason_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • processed_user_uuid — UUID — Foreign key → nems_user.user_uuid — NOT NULL
  • rmrk — VARCHAR(255)
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_eqp_pur

  • eqp_uuid — UUID — Foreign key → nems_eqp.eqp_uuid — NOT NULL
  • eqp_pur_dt — DATE — NOT NULL
  • eqp_vendor_cd — VARCHAR(20) — NOT NULL
  • eqp_pur_amt — INTEGER — NOT NULL
  • eqp_proof_cd — VARCHAR(20) — NOT NULL
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_eqp_use

  • eqp_use_id — SERIAL — Primary key — NOT NULL
  • eqp_uuid — UUID — Foreign key → nems_eqp.eqp_uuid — NOT NULL
  • project_id — UUID — Foreign key → nems_prj.prj_uuid
  • user_uuid — UUID — Foreign key → nems_user.user_uuid
  • eqp_use_type_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • str_dt — DATE — NOT NULL
  • end_dt — DATE
  • rmrk — VARCHAR(255)
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_prj

  • prj_uuid — UUID — Primary key — NOT NULL
  • client_uuid — UUID — Foreign key → nems_prj_client.client_uuid — NOT NULL
  • prj_name — VARCHAR(150) — NOT NULL
  • prj_cont_dt — DATE — NOT NULL
  • prj_start_dt — DATE — NOT NULL
  • prj_end_dt — DATE — NOT NULL
  • prj_loc — VARCHAR(150)
  • prj_status_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • prj_mgr — VARCHAR(20)
  • prj_contract_amt — DECIMAL(15, 0)
  • prj_bill_rate_upfront — SMALLINT
  • prj_bill_rate_progress — SMALLINT
  • prj_bill_rate_balance — SMALLINT
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_prj_bill

  • bill_type_cd — VARCHAR(20) — Primary key — NOT NULL
  • prj_uuid — UUID — Foreign key → nems_prj.prj_uuid — NOT NULL
  • bill_dt — DATE — NOT NULL
  • bill_amt — DECIMAL(15, 0) — NOT NULL
  • dps_dt — DATE
  • dps_amt — DECIMAL(15, 0)
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_prj_client

  • client_uuid — UUID — Primary key — NOT NULL
  • client_name — VARCHAR(100) — NOT NULL
  • client_tel — VARCHAR(50)
  • client_email — VARCHAR(100)
  • client_addr — VARCHAR(255)
  • client_addr_dtls — VARCHAR(255)
  • client_biz_no — VARCHAR(30)
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_prj_doc

  • prj_doc_uuid — UUID — Primary key — NOT NULL
  • prj_uuid — UUID — Foreign key → nems_prj.prj_uuid — NOT NULL
  • doc_type_cd — VARCHAR(20) — NOT NULL
  • doc_file_name — VARCHAR(255) — NOT NULL
  • doc_file_url — VARCHAR(255) — NOT NULL
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_prj_mbr

  • mbr_id — SERIAL — Primary key — NOT NULL
  • prj_uuid — UUID — Foreign key → nems_prj.prj_uuid — NOT NULL
  • mbr_type_cd — VARCHAR(20) — NOT NULL
  • mbr_role_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • mbr_pos_cd — VARCHAR(20) — NOT NULL
  • mbr_rank_cd — VARCHAR(20) — NOT NULL
  • mbr_assign_task_cd — VARCHAR(20) — NOT NULL
  • mbr_user_uuid — UUID — Foreign key → nems_user.user_uuid — NOT NULL
  • mbr_prj_str_dt — TIMESTAMP
  • mbr_prj_end_dt — TIMESTAMP
  • mbr_desc — VARCHAR(255)
  • mbr_sort_order — INTEGER — NOT NULL
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_user

  • user_uuid — UUID — Primary key — NOT NULL
  • user_name — VARCHAR(100) — NOT NULL
  • user_email — VARCHAR(100)
  • user_tel — VARCHAR(20) — NOT NULL
  • user_gender_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • user_birth — DATE
  • user_zipcode — VARCHAR(10)
  • user_addr — VARCHAR(255)
  • user_addr_dtls — VARCHAR(255)
  • user_dept_cd — VARCHAR(20) — NOT NULL
  • user_pos_cd — VARCHAR(20) — NOT NULL
  • user_hire_date — DATE
  • user_emp_type_cd — VARCHAR(20) — NOT NULL
  • user_status_cd — VARCHAR(20) — Foreign key → nems_code.cd — NOT NULL
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_user_career

  • career_id — SERIAL — Primary key — NOT NULL
  • user_uuid — UUID — Foreign key → nems_user.user_uuid — NOT NULL
  • career_company_nm — VARCHAR(100) — NOT NULL
  • career_pos_cd — VARCHAR(20)
  • career_str_dt — DATE
  • career_end_dt — DATE
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

nems_user_edu

  • edu_id — SERIAL — Primary key — NOT NULL
  • user_uuid — UUID — Foreign key → nems_user.user_uuid — NOT NULL
  • school_nm — VARCHAR(100) — NOT NULL
  • major — VARCHAR(100)
  • degree_cd — VARCHAR(20) — Foreign key → nems_code.cd
  • edu_loc — VARCHAR(100)
  • edu_str_dt — DATE
  • edu_end_dt — DATE
  • crt_dttm — TIMESTAMP — NOT NULL
  • crt_user_uuid — UUID — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL
  • upd_user_uuid — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL