특화 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