검사관리

테이블 (8)

InspectionDetail_table (Untitled2)

  • id — 기본 키 — NOT NULL
  • Inspection_id
  • Date (Field2)
  • Time (Field3)
  • Process_id (Field4)
  • DamdangJa_id (Field5)
  • Pass (Field11)
  • GangJeCheoLiYeoBu (Field8)
  • CheugJeongYeoBu (Field6)
  • MiCheugJeongSaYu (Field)
  • MiCheugJeongSaYuDetail (Field7)
  • HapGyulCheoLiYeoBu (Field9)
  • Bigo (Field10)
  • SunBun (Field12)

Inspection_table (Untitled)

  • id — 기본 키 — NOT NULL
  • Product_id (Field2) — 기본 키
  • BasicDate (Field)
  • XR (Field3)
  • Field4
  • Field5

InspectonResult_table (Untitled3)

  • Key — 기본 키 — NOT NULL
  • Inspection_id (Field)
  • InspectionDetail_id (Field2)
  • GumSaSpec_id (Field3)
  • Pass (Field4)
  • ColumnCount (Field5)
  • X1 (Field6)
  • X2 (Field7)
  • X3 (Field8)
  • Field9
  • Field10
  • Field11
  • Field12
  • Field13
  • Field14
  • Field15
  • Field16
  • Field17
  • X30 (Field18)

gumsaspec_table

  • id — INT(11) — 기본 키 — NOT NULL
  • Name — VARCHAR(50)
  • HangMokGuBun — TINYINT(4)
  • GyuGuk — VARCHAR(50)
  • Min — SMALLINT(6)
  • Max — SMALLINT(6)
  • GumSaSu — SMALLINT(6)
  • GumSaJuGi — VARCHAR(50)
  • GuBun — VARCHAR(50)
  • Measurement_id — INT(11) — 외래 키 → measurement_table.id
  • Product_id — INT(11) — 외래 키 → products_table.id
  • Process_id — INT(11) — 외래 키 → process_table.id
  • create_at — TIMESTAMP
  • update_at — TIMESTAMP
  • delete_at — TIMESTAMP
  • INDEX — `FK_gumsaspec_table_products_table`
  • INDEX — `FK_gumsaspec_table_process_table`
  • INDEX — `FK_gumsaspec_table_measurement_table`

measurement_table

  • id — INT(11) — 기본 키 — NOT NULL
  • Name — VARCHAR(50) — NOT NULL
  • GyuGuk — VARCHAR(50) — NOT NULL
  • GyoJungJuGi — SMALLINT(6) — NOT NULL
  • MiGyoJung — TINYINT(1)
  • RRJuGi — SMALLINT(6) — NOT NULL
  • MiGyoJungRR — TINYINT(1)
  • ModelNo — VARCHAR(50)
  • Manufacturer — VARCHAR(50)
  • GuMaeCheo — VARCHAR(50)
  • GuMaeDate — DATE
  • SaYoungSangTae — VARCHAR(50)
  • NextGyoJungYear — VARCHAR(50)
  • NextGyoJungMonth — VARCHAR(50)
  • NextRRYear — VARCHAR(50)
  • NextRRMonth — VARCHAR(50)
  • Picuure — BLOB
  • create_at — TIMESTAMP
  • update_at — TIMESTAMP
  • delete_at — TIMESTAMP

process_table

  • id — INT(11) — 기본 키 — NOT NULL
  • Order — TINYINT(4) — NOT NULL
  • Name — VARCHAR(50) — NOT NULL
  • Product_id — INT(11) — 외래 키 → products_table.id — NOT NULL
  • create_at — TIMESTAMP
  • update_at — TIMESTAMP
  • delete_at — TIMESTAMP
  • INDEX — `FK_process_table_products_table`

products_table

  • id — INT(11) — 기본 키 — NOT NULL
  • Name — VARCHAR(50) — NOT NULL
  • Type — VARCHAR(50) — NOT NULL
  • GyuGuk — VARCHAR(50) — NOT NULL
  • Status — VARCHAR(50) — NOT NULL
  • create_at — TIMESTAMP
  • update_at — TIMESTAMP
  • delete_at — TIMESTAMP

user_table

  • id — INT(11) — 기본 키 — NOT NULL
  • Login_id — VARCHAR(50)
  • Name — VARCHAR(50) — NOT NULL
  • Password — VARCHAR(50) — NOT NULL
  • Tel — VARCHAR(50) — NOT NULL
  • create_at — TIMESTAMP
  • update_at — TIMESTAMP
  • delete_at — TIMESTAMP