bepet_test1
Tables (11)
CHAT_INFO
- CHAT_PK_ID — VARCHAR(50) — Primary key — NOT NULL
- DIAGNOSIS_ID — VARCHAR(50) — Foreign key → DIAGNOSIS.DIAGNOSIS_ID — NOT NULL
- CHAT_TIME — DATETIME
- CHAT_QUESTION — VARCHAR(50)
- CHAT_ANSWER — VARCHAR(50)
CHECKLIST_INFO
- CHECKLIST_ID — VARCHAR(50) — Primary key — NOT NULL
- CLINIC_SUBJECT_ID — VARCHAR(50) — Foreign key → CLINIC_SUBJECT.CLINIC_SUBJECT_ID — NOT NULL
- PET_TYPE — VARCHAR(50)
- QUESTION — VARCHAR(50)
CHECKLIST_OUTPUT_INFO
- CHECKLIST_OUTPUT_ID — VARCHAR(50) — Primary key — NOT NULL
- DIAGNOSIS_ID — VARCHAR(50) — Foreign key → DIAGNOSIS.DIAGNOSIS_ID — NOT NULL
- CHECKLIST_ID — VARCHAR(50) — Foreign key → CHECKLIST_INFO.CHECKLIST_ID — NOT NULL
- USER_ANSWER — VARCHAR(50)
CLINIC_SUBJECT
- CLINIC_SUBJECT_ID — VARCHAR(50) — Primary key — NOT NULL
- CLINIC_SUBJECT — VARCHAR(50)
DIAGNOSIS
- DIAGNOSIS_ID — VARCHAR(50) — Primary key — NOT NULL
- PET_ID — VARCHAR(50) — Foreign key → PET.PET_ID — NOT NULL
- DIAGNOSIS_IMAGE_ID — VARCHAR(50) — Foreign key → DIAGNOSIS_IMAGE.DIAGNOSIS_IMAGE_ID — NOT NULL
- DISEASE_ID — VARCHAR(50) — Foreign key → DISEASE_INFO.DISEASE_ID — NOT NULL
- PREDICT_SCORE — DECIMAL(2,0)
DIAGNOSIS_IMAGE
- DIAGNOSIS_IMAGE_ID — VARCHAR(50) — Primary key — NOT NULL
- IMAGE_PATH — VARCHAR(50)
- PREDICT_IMAGE_PATH — VARCHAR(50)
- PREDICT_LABELING_PATH — VARCHAR(50)
DISEASE_INFO
- DISEASE_ID — VARCHAR(50) — Primary key — NOT NULL
- CLINIC_SUBJECT_ID — VARCHAR(50) — Foreign key → CLINIC_SUBJECT.CLINIC_SUBJECT_ID — NOT NULL
- DISEASE_NAME — VARCHAR(50)
INQUERY_INFO
- 1대1 문의 ID (INQUERY_ID) — VARCHAR(50) — Primary key — NOT NULL
- USER_ID — VARCHAR(50) — Foreign key → USER_INFO.USER_ID — NOT NULL
- 제목 (INQUERY_TITLE) — VARCHAR(50)
- 내용 (INQUERY_CONTENT) — VARCHAR(50)
- 날짜 (INQUERY_DATE) — DATETIME
- 답변 (INQUERY_ANSWER) — VARCHAR(50)
NOTICE_INFO
- 공지사항 ID (NOTICE_ID) — VARCHAR(50) — Primary key — NOT NULL
- USER_ID — VARCHAR(50) — Foreign key → USER_INFO.USER_ID — NOT NULL
- 제목 (NOTICE_TITLE) — VARCHAR(50)
- 내용 (NOTICE_CONTENT) — VARCHAR(50)
- 날짜 (NOTICE_DATE) — DATETIME
PET
- PET_ID — VARCHAR(50) — Primary key — NOT NULL
- USER_ID — VARCHAR(50) — Foreign key → USER_INFO.USER_ID — NOT NULL
- PET_TYPE — VARCHAR(50)
- PET_BREED_NAME — VARCHAR(50)
- PET_BIRTH — DATETIME
- PET_SEX — VARCHAR(50)
USER_INFO
- USER_ID — VARCHAR(50) — Primary key — NOT NULL
- USER_NAME — VARCHAR(50)
- USER_PWD — VARCHAR(50)
- USER_SEX — VARCHAR(50)
- USER_BIRTH — DATETIME
- USER_EMAIL — VARCHAR(50)
- USER_PHONE — VARCHAR(50)
- USER_ADDRESS — VARCHAR(50)
- USER_AUTH — VARCHAR(255)