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))