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