OKR Ver2

Tables (23)

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)
  • status (Field6) — act, del
  • created (Field3)
  • modified (Field4)

okr_activities (okr 로그)

  • id (Field)
  • okr_id (id) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
  • activity_code (Field2)
  • activity_values (Field3)
  • created (Field4)

okr_bookmarks (북마크)

  • id (Key) — Primary key — NOT NULL
  • okr_mst_id (Field)
  • user_id (Field2)
  • ref_id (id2) — 1:okr_id — Foreign key → okrs.id — NOT NULL
  • created (Field3)

okr_checkins (진행상태 정보)

  • id — VARCHAR(20) — Primary key — NOT NULL
  • okr_id (id2) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
  • checkin_date (Field11)
  • 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_master (okr master 설정)

  • id — VARCHAR(20) — Primary key — NOT NULL
  • title (Key) — NOT NULL
  • set_sdt (Field2)
  • set_edt (Field3)
  • progress_sdt (Field) — 진행 시작일
  • progress_edt (Field6) — 진행 종료일
  • score_sdt (Field4) — score 시작일
  • score_edt (Field5) — score 종료일
  • is_current (Field7) — current 유무 true false
  • is_archive (Field8) — archive 유무 true false
  • status (Key3) — 1~2 (act, del) — 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_others (CopyOf북마크)

  • id (Key) — Primary key — NOT NULL
  • okr_mst_id (Field)
  • user_id (Field2)
  • other_id (id2) — 1:okr_id — Foreign key → okrs.id — NOT NULL
  • created (Field3)

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_manual (Field3) — progress 자동, on off 기능

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
  • user_id (Field4)
  • cont_id (id4) — 리뷰 내용 아이디 — Foreign key → contents.id — NOT NULL
  • review_status (Field) — 1:리뷰임시, 2:리뷰확정
  • appr_user_id (Field3) — 평가자 id
  • appr_cont_id (id5) — 평가 내용 아이디 — Foreign key → contents.id — NOT NULL
  • appr_status (Field2) — 1:평가임시, 2:평가확정
  • is_approved (Field5) — 최종 승인 여부

okr_reviews (리뷰 관리)

  • id — VARCHAR(20) — Primary key — NOT NULL
  • 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) — 1:리뷰,평가 진행가능, 2.평가만 가능, 3.완료

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_score (스코어 관리 테이블)

  • id — VARCHAR(20) — Primary key — NOT NULL
  • okr_id (id2) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
  • score (Field2) — 0~1
  • status (Field3) — 1~5(시작전, 리뷰, 확정 전, 완료,출력)
  • is_manual (Field6) — score 자동, on off 기능

okr_structure (Okr 구조)

  • okr_mst_id (id) — VARCHAR(20) — Foreign key → okr_master.id — NOT NULL
  • okr_id (id2) — VARCHAR(20) — Foreign key → okrs.id — NOT NULL
  • parent_id (Field)
  • previously_id (Field2)

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
  • 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
  • active (Key3) — 1:act / 2:dct / 3:del — NOT NULL
  • created (Field7) — 생성일
  • modified (Field8) — 수정일