71891

Tables (24)

architect

  • duty_number — BIGINT — Foreign key → duty.duty_number — NOT NULL

bm

  • employee_number — BIGINT — Foreign key → employee.employee_number — NOT NULL

client_evaluation

  • 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) — NOT NULL

client_eveluation

  • evaluation_number — BIGINT — Foreign key — NOT NULL
  • project_number — BIGINT — Foreign key — NOT NULL
  • employee_number — BIGINT — Foreign key — NOT NULL
  • evaluation_class_number — BIGINT — Foreign key — 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 — BIGINT(11) — NOT NULL
  • skill_count — VARCHAR(45) — NOT NULL
  • skill_level — BIGINT(11) — NOT NULL

duty

  • duty_number — BIGINT — Primary key — NOT NULL

employee

  • employee_number — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • registration_number — VARCHAR(45) — NOT NULL
  • education — VARCHAR(45) — NOT NULL
  • id — VARCHAR(45)
  • password — VARCHAR(45)
  • role — ENUM('employee', 'manager') — NOT NULL

employee_evaluation

  • 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

employee_eveluation

  • evaluation_number — BIGINT — Foreign key — NOT NULL
  • project_number — BIGINT — Foreign key — NOT NULL
  • employee_number — BIGINT — Foreign key — NOT NULL
  • evaluation_class_number — BIGINT — Foreign key — 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 — BIGINT(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
  • duty_number — BIGINT — Foreign key → duty.duty_number — 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_evaluation

  • 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

pm_eveluation

  • evaluation_number — BIGINT — Foreign key — NOT NULL
  • project_number — BIGINT — Foreign key — NOT NULL
  • employee_number — BIGINT — Foreign key — NOT NULL
  • evaluation_class_number — BIGINT — Foreign key — 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('wait', 'running', 'end') — NOT NULL

rnd

  • employee_number — BIGINT — Foreign key → employee.employee_number — NOT NULL

skill

  • skill_number — BIGINT — Primary key — NOT NULL
  • employee_number — BIGINT — Foreign key → developer.employee_number — NOT NULL
  • name — VARCHAR(45)

tester

  • duty_number — BIGINT — Foreign key → duty.duty_number — NOT NULL