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) — 수정일