18930919
Tables (21)
architect
- duty_number — BIGINT — Foreign key → duty.duty_number — NOT NULL
bm
- employee_number — BIGINT — Foreign key → employee.employee_number — NOT NULL
client_eveluation
- evaluation_number — BIGINT — Foreign key → evaluation.evaluation_number — NOT NULL
- project_number — BIGINT — Foreign key → evaluation.project_number — NOT NULL
- employee_number — BIGINT — Foreign key → evaluation.employee_number — NOT NULL
- evaluation_class_number — BIGINT — Foreign key → evaluation.evaluation_class_number — NOT NULL
- client — VARCHAR(45)
communication
- evaluation_class_number — BIGINT — Foreign key → evaluation_class.evaluation_class_number — NOT NULL
developer
- employee_number — BIGINT — Foreign key → employee.employee_number — NOT NULL
- career — INT(11)
- skill_count — VARCHAR(45)
- skill_level — INT(11)
duty
- duty_number — BIGINT — Primary key — NOT NULL
employee
- employee_number — BIGINT — Primary key — NOT NULL
- name — VARCHAR(45) — NOT NULL
- registration_number — BIGINT — NOT NULL
- education — VARCHAR(45) — NOT NULL
- id — VARCHAR(45)
- password — VARCHAR(45)
- role — ENUM('employee', 'manager') — NOT NULL
employee_eveluation
- evaluation_number — BIGINT — Foreign key → evaluation.evaluation_number — NOT NULL
- project_number — BIGINT — Foreign key → evaluation.project_number — NOT NULL
- employee_number — BIGINT — Foreign key → evaluation.employee_number — NOT NULL
- evaluation_class_number — BIGINT — Foreign key → evaluation.evaluation_class_number — NOT NULL
- employee_number2 — BIGINT — NOT NULL
evaluation
- evaluation_number — BIGINT — Primary key — NOT NULL
- project_number — BIGINT — Foreign key → join_project.project_number — NOT NULL
- employee_number — BIGINT — Foreign key → join_project.employee_number — NOT NULL
- evaluation_class_number — BIGINT — Foreign key → evaluation_class.evaluation_class_number — NOT NULL
- content — VARCHAR(45)
- point — INT(5)
evaluation_class
- evaluation_class_number — BIGINT — Primary key — NOT NULL
job_duty
- evaluation_class_number — BIGINT — Foreign key → evaluation_class.evaluation_class_number — NOT NULL
join_project
- project_number — BIGINT — Foreign key → project.project_number — NOT NULL
- employee_number — BIGINT — Foreign key → developer.employee_number — NOT NULL
- duyt_number — BIGINT — NOT NULL
- is_middle_join — BOOLEAN
- join_date — DATETIME
- out_date — DATETIME
marketer
- employee_number — BIGINT — Foreign key → employee.employee_number — NOT NULL
pl
- duty_number — BIGINT — Foreign key → duty.duty_number — NOT NULL
pm
- duty_number — BIGINT — Foreign key → duty.duty_number — NOT NULL
pm_eveluation
- evaluation_number — BIGINT — Foreign key → evaluation.evaluation_number — NOT NULL
- project_number — BIGINT — Foreign key → evaluation.project_number — NOT NULL
- employee_number — BIGINT — Foreign key → evaluation.employee_number — NOT NULL
- evaluation_class_number — BIGINT — Foreign key → evaluation.evaluation_class_number — NOT NULL
- duty_number — BIGINT — NOT NULL
programmer
- duty_number — BIGINT — Foreign key → duty.duty_number — NOT NULL
project
- project_number — BIGINT — Primary key — NOT NULL
- name — VARCHAR(45) — NOT NULL
- join_member — BIGINT — NOT NULL
- client — VARCHAR(45) — NOT NULL
- startday — DATETIME
- endday — DATETIME
- role — ENUM('employee', 'manager') — NOT NULL
rnd
- employee_number — BIGINT — Foreign key → employee.employee_number — NOT NULL
skill
- skill_number — BIGINT — Primary key — NOT NULL
- employee_number — BIGINT — NOT NULL
- name — VARCHAR(45)
tester
- duty_number — BIGINT — Foreign key → duty.duty_number — NOT NULL