test

Tables (14)

CUSTOMER

  • Cus_num — INT
  • Cus_name — VARCHAR(20) — NOT NULL

DEVELOPER

  • Emp_num — INT
  • Career — INT — NOT NULL
  • Tech_grade — INT — NOT NULL

EMPLOYEE

  • Emp_num — INT — NOT NULL
  • Emp_name — VARCHAR(20) — NOT NULL
  • Resident_num — VARCHAR(14) — NOT NULL
  • Id — VARCHAR(20) — NOT NULL
  • Pw — VARCHAR(20) — NOT NULL
  • Final_edu — VARCHAR(20) — NOT NULL

EVALUATE

  • Evaluate_num — INT
  • Eval_target — INT — NOT NULL
  • Project_num — INT — NOT NULL

EVALUATE_CLASSFICATION

  • Evaluate_num — INT
  • Commu_eval — INT — NOT NULL
  • Commu_content — VARCHAR(50) — NOT NULL
  • Avil_work_eval — INT — NOT NULL
  • Avil_work_content — VARCHAR(50) — NOT NULL

EVALUATE_CUSTOM

  • Evaluate_num — INT
  • Evaluater — INT — NOT NULL

EVALUATE_PARTNER

  • Evaluate_num — INT
  • Evaluater — INT — NOT NULL

EVALUATE_PM

  • Evaluate_num — INT
  • Evaluater — INT — NOT NULL

JOB

  • Job_num — INT — NOT NULL
  • Job_name — VARCHAR(20) — NOT NULL

MANAGE

  • Emp_num — INT
  • Athority — INT — NOT NULL

MARKETING

  • Emp_num — INT
  • Marketing_field — VARCHAR(20) — NOT NULL

PROJECT

  • Project_num — INT
  • Project_name — VARCHAR(20) — NOT NULL
  • Start_date — DATE — NOT NULL
  • End_Date — DATE — NOT NULL
  • Customer — INT — NOT NULL

PROJECT_DEVELOPER

  • Project_num — INT — NOT NULL
  • Emp_num — INT — NOT NULL
  • Job_num — INT — NOT NULL
  • Start_date — DATE — NOT NULL
  • End_date — DATE — NOT NULL
  • Exp_skill — VARCHAR(20) — NOT NULL

RND

  • Emp_num — INT
  • Rnd_Field — VARCHAR(20) — NOT NULL