SKIN GUARD

테이블 (3)

로그기록 (Untitled2)

  • 컬럼명(Column Name) (데이터 타입(Data Type)) — 제약조건(Constraint)
  • RECORD_ID (NUMBER) — PK
  • USER_ID (VARCHAR2(50)) — FK(USER 테이블 참조)
  • PREDICTION_DATE (TIMESTAMP) — DEFAULT SYSTIMESTAMP
  • IMAGE_URL (VARCHAR2(500))
  • PREDICTED_DISEASE (VARCHAR2(100))
  • PREDICTION_RATE (NUMBER(5, 2))

병원정보 (Untitled3)

  • 컬럼명(Column Name) (데이터 타입(Data Type)) — 제약조건(Constraint)
  • HOSPITAL_INFO (VARCHAR(40)) — PK
  • HOSPITAL_NAME (VARCHAR(50))
  • HOSPITAL_ADDRESS (VARCHAR(100))
  • HOSPITAL_TEL (NUMBER)

사용자 (Untitled)

  • 컬럼명(Column Name) (데이터 타입(Data Type)) — 제약조건(Constraint)
  • USER_ID (VARCHAR2(50)) — PK
  • PW (VARCHAR2(20))
  • NICKNAME (VARCHAR2(40))
  • EMAIL (VARCHAR(50))