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