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