Meta_EMS

Tables (5)

account

  • id — VARCHAR(50) — Primary key — NOT NULL
  • passwd — VARCHAR(50)
  • create_date — DATE
  • activate — TINYINT(4)
  • emp_num — BIGINT(20)

employee

  • emp_num — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(50)
  • level — VARCHAR(50)
  • number — VARCHAR(50)
  • join_date — DATE
  • retire_date — DATE
  • INDEX — `emp_num`
  • INDEX — `name`

equipment

  • ctrl_num — VARCHAR(50) — Primary key — NOT NULL
  • prob_num — BIGINT(20) — Foreign key → problem.prob_num — NOT NULL
  • owner — VARCHAR(50)
  • model — VARCHAR(50)
  • purchase_date — DATE
  • use_location — VARCHAR(50)
  • project_name — VARCHAR(50)
  • INDEX — `ctrl_num`

problem

  • prob_num — BIGINT(20) — Primary key — NOT NULL
  • ctrl_num — VARCHAR(50)
  • prob_date — DATE

project

  • prob_num — BIGINT(20) — Foreign key → problem.prob_num — NOT NULL
  • ctrl_num — VARCHAR(50) — Foreign key → equipment.ctrl_num — NOT NULL
  • prob_num (prob_num2) — BIGINT(20) — Foreign key → equipment.prob_num — NOT NULL
  • project_name — VARCHAR(50)
  • address — VARCHAR(50)
  • start_date — DATE
  • end_date — DATE