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