dohands-dozon
Tables (13)
career (직무그룹)
- name (Key) — Primary key — NOT NULL
- create-date (Field)
exp-history-week (주차 부여 경험치)
- user-exp-id (사번) — Primary key — NOT NULL
- week (1)
- exp (80)
- create-date (2024-01-01)
- id (Key2) — Foreign key → user-exp.id — NOT NULL
exp-history-year (년도별 경험치 기록(년도바뀔때))
- user-exp-id (사번) — Primary key — NOT NULL
- id (Key) — Foreign key → user-exp.id — NOT NULL
- year (2024)
- exp (5,000)
exp-type (레벨별 경험치)
- level (F1-I) — Primary key
- exp (24,000)
hr-evaluation (인사 평가)
- grade (S등급) — Primary key — NOT NULL
- exp (6,500)
leader-quests (리더부여 퀘스트 목록)
- id (Key) — Primary key — NOT NULL
- number (2024010101) — Foreign key → user.number — NOT NULL
- quest-name (리더부여 퀘스트명)
- project-name (달성 내용)
- exp (Field4)
- content (Field)
month-quests (직무별 월별 퀘스트 종류)
- id (Key) — Primary key — NOT NULL
- month (Field)
- week (Field2)
- date (Field3)
- day (Field4)
- price (Field5)
- labor-costs (인건비)
- design-fee (설계용역비)
- employee-salaries (직원급여)
- retirement-benefits (퇴직급여)
- social-insurance (4대보험료)
post (게시판)
- id (Key) — Primary key — NOT NULL
- title (Field)
- content (Field2)
- number (2024010101) — Foreign key → user.number — NOT NULL
sword-project (전사 퀘스트 목록)
- Key — Primary key — NOT NULL
- date (01-02)
- project-name (Field2)
- exp (Field3)
- content (Field)
- number (2024010101) — Foreign key → user.number — NOT NULL
user (유저 정보)
- number (2024010101) — Primary key — NOT NULL
- name (김강민)
- join-date (2023-01-01)
- id (minsukim)
- password (1111)
- new-password (Field8)
- exp (136,000)
- level (F1-I) — Foreign key → exp-type.level
- team (음성 1센터) — Foreign key → user-team.name — NOT NULL
- career (직무 그룹) — Foreign key → career.name — NOT NULL
- user-type (사용자,리더,관리자)
user-exp (올해 사용자의 경험치)
- id (Key) — Primary key — NOT NULL
- total-exp (136,000)
- role-quests (직무별 퀘스트 경험치)
- leader-quests (리더부여 퀘스트 경험치)
- company-project (전사 프로젝트 경험치)
- number (사번(PFK)) — Foreign key → user.number — NOT NULL
- first-evaluation (상반기 인사평가) — Foreign key → hr-evaluation.grade — NOT NULL
- second-evaluation (하반기 인사평가) — Foreign key → hr-evaluation.grade — NOT NULL
- year (2024)
user-team (소속)
- name (음성 1센터) — Primary key — NOT NULL
- update-date (2024-01-01)
week-quests (직무별 주별 퀘스트 종류)
- id (Key) — Primary key — NOT NULL
- max (5.1)
- medium (4.3)
- week (Field3)
- productivity (3.495)