test

Tables (11)

ref_activity_id

  • activity_id — varchar — Primary key — NOT NULL — 행동
  • activity_nm — varchar — NOT NULL — 행동

ref_dept

  • dept_code — varchar — Primary key — NOT NULL — 부서
  • dept_nm — varchar — 부서

ref_method

  • method_code — varchar — Primary key — NOT NULL — 발주방식코드
  • method_name — varchar — 발주방식이름

ref_nation

  • nation_code — varchar — Primary key — NOT NULL — 지역코드
  • nation_name — varchar — 지역이름

ref_progress

  • progress_code — varchar — Primary key — NOT NULL — 진행상태(code)
  • progress_nm — varchar — 진행상태

ref_workscope

  • workscope_code — varchar — Primary key — NOT NULL — 업무범위코드
  • workscope_name — varchar — 업무범위이름

tb_category

  • category_id — varchar — Primary key — NOT NULL — 카테고리id
  • main — varchar — main
  • sub — varchar — sub
  • third — varchar — third

tb_file

  • ino — number — Primary key — NOT NULL — file
  • project_id — varchar — Foreign key → tb_project.project_id — NOT NULL — 프로젝트
  • user_id — varchar — 업로더
  • uploader_nm — varchar — 업로더
  • create_date — timestamp — 생성
  • modi_date — timestamp — 마지막
  • lev — int — 권한
  • meta — varchar — 메타정보(컬럼
  • gsim — boolean — GSIM

tb_log

  • log_id — int — Primary key — NOT NULL — 로그
  • ino — varchar — inode
  • activity_id — varchar — Foreign key → ref_activity_id.activity_id — NOT NULL — 행동
  • user_id — varchar — 행위자
  • user_nm — varchar — 행위자
  • user_position — varchar — 행위자
  • user_companu — varchar — 행위자
  • user_dept — varchar — 행위자
  • user_ip — varchar — 유저IP
  • project_id — varchar — 프로젝트
  • log_date — varchar — 로그
  • log_path — varchar — 행위

tb_permission

  • permission_id — varchar — Primary key — NOT NULL — 퍼미션
  • project_id — varchar — Foreign key → tb_project.project_id — NOT NULL — 프로젝트
  • user_id — varchar — NOT NULL — 유저
  • lev — varchar — 허용

tb_project

  • project_id — varchar — Primary key — NOT NULL — 프로젝트
  • folder_name — varchar — 약어
  • project_nm — varchar — 프로젝트
  • progress_code — varchar — Foreign key → ref_progress.progress_code — 진행상태(code)
  • dept_code — varchar — Foreign key → ref_dept.dept_code — 부서(
  • pm — varchar — pm사번
  • manager — varchar — 담당자
  • nation_code — varchar — Foreign key → ref_nation.nation_code — 지역코드
  • claimer — varchar — 수요처
  • order — varchar — 발주처
  • method_code — varchar — Foreign key → ref_method.method_code — 발주방식코드
  • workscope_code — varchar — Foreign key → ref_workscope.workscope_code — 업무범위코드
  • interrupt_reason — varchar — 과업중지사유
  • share_ratio — varchar — 지분율
  • organizer — varchar — 주관사
  • contractor — varchar — 공동도급사(지분율)
  • contract_date — timestamp — 계약일자
  • start_date — timestamp — 착수일자
  • origin_complete_date — timestamp — 당초준공일
  • change_complete_date — timestamp — 변경준공일
  • stop_date — timestamp — 중지기간
  • stop_date_end — timestamp — 중지기간
  • restart_date — timestamp — 재착수일
  • total_price — varchar — 총
  • collected_price — varchar — 수금액
  • category_id — varchar — Foreign key → tb_category.category_id — NOT NULL — 카테고리id