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