hyunjongERD
Tables (6)
Copy Of Artifact (CopyOf유물)
- artifactId (고유ID) — BIGINT — Primary key — NOT NULL
- userId (사용자 고유 ID) — UUID — NOT NULL
- name (유물 명칭) — VARCHAR
- material (재질) — VARCHAR
- era (시대) — VARCHAR
- conditionDesc (상태설명) — TEXT
- createdAt (생성일) — DATETIME
- userId (사용자 고유 ID2) — UUID — Foreign key → Copy Of User.userId — NOT NULL
Copy Of HITLReview (CopyOfHITL 검토)
- hitlId (검토ID) — UUID — Primary key — NOT NULL
- resultId (결과이미지ID) — UUID — NOT NULL
- decision (검토결과) — VARCHAR
- comment (검토의견) — TEXT
- createdAt (생성일) — DATETIME
- resultId (결과이미지ID2) — UUID — Foreign key → Copy Of XrayResult.resultId — NOT NULL
- userId (사용자 고유 ID) — UUID — Foreign key → Copy Of User.userId — NOT NULL
Copy Of User (CopyOf회원)
- userId (사용자 고유 ID) — UUID — Primary key — NOT NULL
- id (로그인 아이디) — VARCHAR
- password (패스워드) — VARCHAR
- name (실명) — VARCHAR
- age (나이) — INT
- email (이메일) — VARCHAR
- isAdmin (관리자 여부) — BOOLEAN
- isOperator (운영자 여부) — BOOLEAN
Copy Of XrayAnalysis (CopyOfX-RAY 분석 작업)
- xrayId (엑스레이ID) — UUID — Primary key — NOT NULL
- userId (사용자 고유 ID) — UUID — NOT NULL
- status (진행상태) — VARCHAR
- createdAt (생성일) — DATETIME
- artifactId (고유ID) — BIGINT — Foreign key → Copy Of Artifact.artifactId — NOT NULL
Copy Of XrayOriginal (CopyOfX-RAY 원본 이미지)
- originId (원본이미지ID) — UUID — Primary key — NOT NULL
- url (원본이미지url) — VARCHAR
- imageOrder (원본이미지순서) — INT
- createdAt (생성일) — DATETIME
- xrayId (엑스레이ID2) — UUID — Foreign key → Copy Of XrayAnalysis.xrayId — NOT NULL
Copy Of XrayResult (CopyOfX-RAY 결과 이미지)
- resultId (결과이미지ID) — UUID — Primary key — NOT NULL
- resultType (결과생성타입) — VARCHAR
- url (결과이미지url) — VARCHAR
- createdAt (생성일) — DATETIME
- xrayId (엑스레이ID2) — UUID — Foreign key → Copy Of XrayAnalysis.xrayId — NOT NULL