특화 project

테이블 (7)

defect_analysis

  • id — BIGINT — 기본 키 — NOT NULL
  • object_detection_id — BIGINT — 외래 키 → object_detection.id — NOT NULL
  • analysis_details — ENUM('rusting', 'deformation', 'scratches', 'fracture', 'normal') — NOT NULL
  • timestamp — TIMESTAMP — NOT NULL
  • confidence — DOUBLE — NOT NULL — Stored up to two decimal places

image_test

  • id — bigint — 기본 키 — NOT NULL
  • file_name — varchar(255) — NOT NULL
  • file_type — varchar(255) — NOT NULL
  • file_uri — varchar(255) — NOT NULL

object_detection

  • id — BIGINT — 기본 키 — NOT NULL
  • scanners_id — BIGINT — 외래 키 → scanners.id — NOT NULL
  • object_url — VARCHAR(255)
  • completed_at — TIMESTAMP
  • detection_type — TINYINT — 1: Normal / 0: Defective

scanners

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → 사용자.id — NOT NULL
  • serial_number — BIGINT — NOT NULL
  • completed_at — TIMESTAMP
  • is_completed — TINYINT — 0: Not in use / 1: In use

권한 (authority)

  • authority_name — varchar(50) — 기본 키 — NOT NULL

사용자 (users)

  • id — bigint — 기본 키 — NOT NULL
  • activated — bit(1)
  • email — varchar(100) — NOT NULL
  • name — varchar(50)
  • nickname — varchar(100)
  • password — varchar(100) — NOT NULL
  • refresh_token — varchar(512)
  • phone_number — varchar(15) — NOT NULL

사용자 권한 (user_authority)

  • authority_name — varchar(50) — 외래 키 → 권한.authority_name — NOT NULL
  • user_id — bigint — 외래 키 → 사용자.id — NOT NULL