검사관리
테이블 (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