test

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_number (employee_number2) — BIGINT — Foreign key → developer.employee_number — 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
  • duty_number (duyt_number) — BIGINT — Foreign key → duty.duty_number — NOT NULL
  • is_middle_join — BOOLEAN
  • join_date — DATETIME
  • out_date — DATETIME

maketer (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 — Foreign key → pm.duty_number — 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 — Foreign key → developer.employee_number — NOT NULL
  • name — VARCHAR(45)

tester

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