common
Tables (3)
Users
- id — INT — Primary key — NOT NULL
- 사용자이름 (userName) — VARCHAR(100) — NOT NULL
- 비밀번호 (password) — VARCHAR(100) — NOT NULL
- 성 (firstName) — VARCHAR(100) — NOT NULL
- 이름 (lastName) — VARCHAR(100) — NOT NULL
- 권한 (position) — VARCHAR(100) — NOT NULL
- 이메일 (email) — VARCHAR(100) — NOT NULL
- 프로필이미지 (profilePicture) — LONGBLOB
pcb
- pcb_id — INT — Primary key — NOT NULL
- 시리얼번호 (serial_number) — VARCHAR(50) — NOT NULL
- 검출일 (inspection_date) — DATETIME — NOT NULL
- 이물질수 (defect_count) — INT
pcb_defect
- pcd_defect_id (pcb_defect_id) — INT — Primary key — NOT NULL
- pcb_id — INT — Foreign key → pcb.pcb_id — NOT NULL
- x좌표 (x_position) — INT — NOT NULL
- y좌표 (y_position) — INT — NOT NULL
- 너비 (width) — DOUBLE — NOT NULL
- 높이 (height) — DOUBLE — NOT NULL