OKR Ver3
Tables (24)
comments (코멘트)
- id — VARCHAR(20) — Primary key — NOT NULL
- okr_id (id2) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- cont_id (id3) — VARCHAR(20) — Foreign key → contents.id — NOT NULL
- user_Id (Field5)
- created (Field3)
- modified (Field4)
contents (Contents)
- id — VARCHAR(20) — Primary key — NOT NULL
- cont_type (Field) — 1:comment, 2:review
- body_text (Field2)
- body_blockskit (Field5)
- is_active (Field6) — act, del
- created (Field3)
- modified (Field4)
okr_activities (okr 로그)
- id (Key) — Primary key — NOT NULL
- okr_id (id) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- user_id (Field4)
- noti_temp_code (Field2)
- noti_values (Field3)
- created (Field5)
okr_bookmark (북마크)
- id (Key) — Pk — Primary key — NOT NULL
- cmp_id (Field) — company id
- okr_mst_id (Field2) — okr master id
- user_id (Field3) — User Id
- ref_id (id2) — 1:okr_id — Foreign key → okrs.id — NOT NULL
- ref_type (Field4) — 참조 type (1.okrs, 2.dashboard...)
- created (Field5)
okr_checkins (진행상태 정보)
- id — VARCHAR(20) — Primary key — NOT NULL
- okr_id (id2) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- progress (Field2) — 0~100
- status (Field3) — 1:ns,2:ot,3:bh,4:ar,5:cs
- note (Field4) — 노트(코멘트)
- value (Field10) — 현재값
- type (Field9) — 값 특징
- start (Field7) — 시작값
- target (Field8) — 목표값
- is_manual (Field5) — 수동입력 유무
- created (Field) — 생성일 (index 만들기)
- updated (Field6)
okr_cmp_mst (회사 날자 목록)
- cmp_id (id2) — VARCHAR(20) — Foreign key → okr_company.id — NOT NULL
- com_type (Field) — 1~2 (swit company, okr company)
- okr_mst_id (id) — VARCHAR(20) — Foreign key → okr_master.id — NOT NULL
okr_cmp_user_rol (okr user 권한)
- cmp_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Primary key — NOT NULL
- is_manager (Field5)
- is_editor (Field2)
- created (Field3)
- updated (Field4)
okr_comp_teams (회사 팀 목록)
- okr_comp_id (id2) — VARCHAR(20) — Foreign key → okr_company.id — NOT NULL
- okr_team_id (id) — VARCHAR(20) — Foreign key → okr_teams.id — NOT NULL
okr_comp_users (회사 등록 유저)
- okr_comp_id (id) — VARCHAR(20) — Foreign key → okr_company.id — NOT NULL
- user_id (Field)
okr_company (회사 정보)
- id — VARCHAR(20) — Primary key — NOT NULL
- name (Key) — NOT NULL
- status (Key2) — NOT NULL
- Invite (Field2)
- created_swit_user_id (Field)
- created (Field3)
okr_counter (수량 관리 테이블)
- okr_id (id) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- count_type (Field) — 1:view, 2.bookmark, 3.checkin, 4.score....
- count (Field2) — bookmark count
okr_master (okr master 설정)
- id — VARCHAR(20) — Primary key — NOT NULL
- cmp_id (Field10)
- title (Key) — NOT NULL
- set_sdt (Field2)
- set_edt (Field3)
- progress_sdt (Field) — 진행 시작일
- progress_edt (Field6) — 진행 종료일
- score_sdt (Field4) — score 시작일
- score_edt (Field5) — score 종료일
- timezone (Field9)
- is_current (Field7) — current 유무 true false
- is_freeze (Field11) — 생성 삭제 변경 가능 유무 true false
- is_archive (Field8) — archive 유무 true false
- is_active (Key3) — active 유무 true false — NOT NULL
okr_mentions (멘션)
- id — VARCHAR(20) — Primary key — NOT NULL
- okr_id (id2) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- user_id (Field)
okr_progress_matrix (진척률)
- okr_id (id2) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- type (Field) — 입력타입 (1,2,3,4,5...)
- start (Field2)
- target (Field5)
- is_noti (Field4) — 자동 rollup시 notification 전송 유무(o만 설정 가능)
- is_manual (Field3) — progress 자동, on off 기능
okr_reference (누가누가 참조하나 (미사용))
- id (Key) — Primary key — NOT NULL
- okr_id (id) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- okr_mst_id (Field2)
- user_id (Field) — 체크인 횟수
okr_reference (okr 참조 데이터)
- okr_id (id) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- ref_type (Field3)
- ref_id (Field) — key value
okr_review_dtl (리뷰 상세 테이블)
- id — VARCHAR(20) — Primary key — NOT NULL
- okr_review_id (id3) — VARCHAR(20) — Foreign key → okr_reviews.id — NOT NULL
- okr_id (id2) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
- review_user_id (Field4)
- review_cont_id (id4) — 리뷰 내용 아이디 — Foreign key → contents.id — NOT NULL
- review_status (Field) — figma B-32 오른쪽 참조
- appr_user_id (Field3) — 평가자 id
- appr_cont_id (id5) — 평가 내용 아이디 — Foreign key → contents.id — NOT NULL
- appr_status (Field2) — figma B-32 오른쪽 참조
- display_seq (Field5) — 조회 순서
okr_reviews (리뷰 관리)
- id — VARCHAR(20) — Primary key — NOT NULL
- cmp_id (Field5)
- okr_mst_id (id2) — VARCHAR(20) — Foreign key → okr_master.id — NOT NULL
- category (Field3) — 1:company,2:user
- user_id (Field4) — 리뷰 대상자
- appr_user_id (Field2) — 평가자
- status (Field) — figma B-32 오른쪽 참조
okr_rhythm (Okr 알람)
- okr_mst_id (id) — VARCHAR(20) — Foreign key → okr_master.id — NOT NULL
- user_id (Field)
- cycle (Field4) — 1~7 (일~토)
- time (Field5)
okr_sort (sort)
- user_id (Key) — User Id — Primary key — NOT NULL
- cmp_id (Key2) — company id — Primary key — NOT NULL
- okr_mst_id (Key3) — okr master id — Primary key — NOT NULL
- type (Key4) — 10:okr others,11:folder for okr others — Primary key — NOT NULL
- folder_id (Key5) — folder id — Primary key — NOT NULL
- sorted_ids (Field) — 정렬된 아이디들 [{type:"user",id:"12345679"},{type:"team",id:"12345679"},{type:"folder",id:"12345679"},....]
- created (Field2)
- modified (Field3)
okr_team_members (팀 멤버)
- id — VARCHAR(20) — Primary key — NOT NULL
- okr_team_id (id2) — VARCHAR(20) — Foreign key → okr_teams.id — NOT NULL
- user_id (Field)
- status (Key3) — NOT NULL
okr_team_orgs (팀간 조직도)
- okr_team_id (id2) — VARCHAR(20) — Foreign key → okr_teams.id — NOT NULL
- parent_id (Field)
- status (Key3) — NOT NULL
okr_teams (마스터 관련 팀)
- id — VARCHAR(20) — Primary key — NOT NULL
- name (Field)
okrs (o - kr)
- id — VARCHAR(20) — Primary key — NOT NULL
- cmp_id (Field17)
- okr_mst_id (id2) — VARCHAR(20) — Foreign key → okr_master.id — NOT NULL
- parent_id (Field15)
- previously_id (Field16)
- title (Key) — NOT NULL
- category (Field11) — 1:company,2:user
- type (Field) — 1:O,2:KR
- okr_sdt (Field4) — 시작일
- okr_edt (Field5) — 종료일
- assignee (Field3) — 담당자 (swit_user_id)
- priority (Field6) — 1 ~ 5
- progress (Field9) — 0~100 (진척률)
- status (Field2) — 1:ns,2:ot,3:bh,4:ar,5:cs
- score (Field10) — 0~1
- approval (Field12) — 0:not score, 1:scoring, 2:approval
- is_valid (Field13) — 1.valid, 2~5 Not valid
- is_active (Key3) — active 유무 true false — NOT NULL
- last_checkin_date (Field14)
- created (Field7) — 생성일
- modified (Field8) — 수정일