GTOne_자산&인력관리

테이블 (10)

asset

  • id — BIGINT — 기본 키 — NOT NULL
  • asset_code — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • model — VARCHAR(200)
  • acquisition_type — VARCHAR(50) — NOT NULL
  • rental_vendor — VARCHAR(100)
  • rental_expire_dt — DATE
  • status — VARCHAR(50) — NOT NULL
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

asset_assignment

  • id — BIGINT — 기본 키 — NOT NULL
  • asset_id — BIGINT — 외래 키 → asset.id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • project_id — BIGINT — 외래 키 → project.id
  • assigned_dt — DATE — NOT NULL
  • returned_dt — DATE
  • note — TEXT
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

backlog

  • id — BIGINT — 기본 키 — NOT NULL
  • project_id — BIGINT — 외래 키 → project.id — NOT NULL
  • wbs_id — BIGINT — 외래 키 → wbs_item.id
  • type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — TEXT
  • priority — VARCHAR(50)
  • status — VARCHAR(50)
  • assignee_id — BIGINT
  • due_dt — DATE
  • target_version — VARCHAR(100)
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

backlog_comment

  • id — BIGINT — 기본 키 — NOT NULL
  • backlog_id — BIGINT — 외래 키 → backlog.id — NOT NULL
  • author_id — BIGINT — NOT NULL
  • body — TEXT — NOT NULL
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

member

  • id — BIGINT — 기본 키 — NOT NULL
  • emp_no — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • team — VARCHAR(100)
  • position — VARCHAR(100)
  • status — VARCHAR(50)
  • system_role — VARCHAR(50)
  • password — VARCHAR(255)
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

member_skill

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • skill — VARCHAR(100) — NOT NULL
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

project

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • client — VARCHAR(200) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • description — TEXT
  • start_dt — DATE
  • end_dt — DATE
  • status — VARCHAR(50) — NOT NULL
  • pm_id — BIGINT
  • task_mgmt_enabled — BOOLEAN — NOT NULL
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

project_assignment

  • id — BIGINT — 기본 키 — NOT NULL
  • project_id — BIGINT — 외래 키 → project.id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • role — VARCHAR(100)
  • alloc_rate — DECIMAL(5,2)
  • join_dt — DATE
  • leave_dt — DATE
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

task

  • id — BIGINT — 기본 키 — NOT NULL
  • project_id — BIGINT — 외래 키 → project.id — NOT NULL
  • wbs_id — BIGINT — 외래 키 → wbs_item.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • assignee_id — BIGINT
  • status — VARCHAR(50) — NOT NULL
  • plan_effort — DECIMAL(10,2)
  • act_effort — DECIMAL(10,2)
  • backlog_id — BIGINT — 외래 키 → backlog.id
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME

wbs_item

  • id — BIGINT — 기본 키 — NOT NULL
  • project_id — BIGINT — 외래 키 → project.id — NOT NULL
  • parent_id — BIGINT
  • code — VARCHAR(100) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • owner_id — BIGINT
  • plan_start — DATE
  • plan_end — DATE
  • act_start — DATE
  • act_end — DATE
  • progress — INT
  • plan_effort — DECIMAL(10,2)
  • act_effort — DECIMAL(10,2)
  • act_effort_source — VARCHAR(50) — NOT NULL
  • deliverable — VARCHAR(200)
  • is_milestone — BOOLEAN
  • sort_order — INT
  • del_yn — CHAR(1)
  • created_at — DATETIME
  • updated_at — DATETIME