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