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