final_project
Tables (7)
First_information (first_information)
- id (PK) — INTEGER — Primary key — NOT NULL
- MachineId (FK) — INTEGER — Foreign key → Machine.id — NOT NULL
- parts_status (Field) — STRING — NOT NULL
- parts_life (Field2) — INTEGER — NOT NULL
- counts (Field3) — INTEGER — NOT NULL
Machine (machine)
- id (Key) — INTEGER — Primary key — NOT NULL
- machine_name (Field) — INTEGER — NOT NULL — unique
- machine_status (Field2) — STRING — NOT NULL — (true : 운행 / false : 정지)
- machine_image (Field3) — STRING — NOT NULL
Second_information (second_information)
- id (PK) — INTEGER — Primary key — NOT NULL
- MachineId (FK) — INTEGER — Foreign key → Machine.id — NOT NULL
- parts_status (Field) — STRING — NOT NULL
- parts_life (Field2) — STRING — NOT NULL
Software_history (software_history)
- id (PK) — INTEGER — Primary key — NOT NULL
- MachindId (FK) — INTEGER — Foreign key → Machine.id — NOT NULL
- parts_type (Field) — INTEGER — NOT NULL
- software_version (Field2) — STRING — NOT NULL
- detail (Field3) — STRING
Test_result (test_result)
- id (PK) — INTEGER — Primary key — NOT NULL
- MachineId (FK) — INTEGER — Foreign key → Machine.id — NOT NULL
- serial_number (Field) — INTEGER — NOT NULL
- final_result (Field2) — STRING — NOT NULL
Third_information (third_information)
- id (PK) — INTEGER — Primary key — NOT NULL
- MachineId (FK) — INTEGER — Foreign key → Machine.id — NOT NULL
- parts_status (Field) — STRING — NOT NULL
- parts_life (Field2) — STRING — NOT NULL
User (user)
- id (Key) — INTEGER — Primary key — NOT NULL
- employee_number (Field) — INTEGER — NOT NULL
- email (Field2) — STRING — NOT NULL
- name (Field3) — STRING — NOT NULL
- password (Field4) — INTEGER — NOT NULL
- authorization (Field5) — STRING — NOT NULL — 'worker', 'admin'