kakao_onboarding_erd_exam

테이블 (6)

리스크 (Untitled4)

  • Key (risk_id) — 기본 키 — NOT NULL
  • Field (parerent_rist_id)
  • Field (risk_rank_id)
  • Field (risk_name)
  • Field (risk_overview)
  • Field (enroll_date)
  • Field (alternative)
  • Field (resolve_date)
  • Field (resolve_content)

리스크 목록 (Untitled5)

  • Field (risk_id)
  • Field

요구사항 (Untitled6)

  • Key (requirement_id) — 기본 키 — NOT NULL
  • Field (project_id)
  • Field (apply_sector)
  • Field (confirmed_date)
  • Field (priority)
  • Field (register_date)
  • Field (inquire_department)
  • Field (inquire_username)

직원 (Untitled)

  • Key (employee_id) — 기본 키 — NOT NULL
  • Field (name)

팀원 (Untitled2)

  • Key (team_member_id) — 기본 키 — NOT NULL
  • Field (project_id)
  • Field (employee_id)
  • Field (join_date)
  • Field (withdraw_date)
  • Field (role)

프로젝트 (Untitled3)

  • Key (project_id) — 기본 키 — NOT NULL
  • Field (name)
  • Field (customer)
  • Field (start_date)
  • Field (end_date)
  • Field (order_amount)
  • Field (overview)