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)