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'