add pjt

Tables (5)

department

  • department_id — BIGINT — Primary key — NOT NULL
  • dept_cd — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • closed_at — DATE

department_name_history

  • dept_name_hist_id — BIGINT — Primary key — NOT NULL
  • department_id — BIGINT — Foreign key → department.department_id — NOT NULL
  • dept_name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • created_at — DATETIME — NOT NULL

department_relation_history

  • relation_history_id — BIGINT — Primary key — NOT NULL
  • parent_department_id — BIGINT — Foreign key → department.department_id
  • child_department_id — BIGINT — Foreign key → department.department_id — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • created_at — DATETIME — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • member_code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • profile_image_path — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_department_history

  • member_department_history_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • department_id — BIGINT — Foreign key → department.department_id — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • created_at — DATETIME — NOT NULL