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