bepet_test2
Tables (9)
CHAT_INFO
- CHAT_ID — VARCHAR(50) — Primary key — NOT NULL
- DIAGNOSIS_ID — VARCHAR(50) — Foreign key → DIAGNOSIS_INFO.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
- DISEASE_TYPE_ID (DISEASE_TYPE_ID_PK) — VARCHAR(50) — Foreign key → DISEASE_TYPE_INFO.DISEASE_TYPE_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_INFO.DIAGNOSIS_ID — NOT NULL
- CHECKLIST_ID — VARCHAR(50) — Foreign key → CHECKLIST_INFO.CHECKLIST_ID — NOT NULL
- USER_ANSWER — VARCHAR(50)
DIAGNOSIS_INFO
- DIAGNOSIS_ID — VARCHAR(50) — Primary key — NOT NULL
- PET_ID — VARCHAR(50) — Foreign key → PET_INFO.PET_ID — NOT NULL
- DISEASE_TYPE_ID (DISEASE_TYPE_ID_PK) — VARCHAR(50) — Foreign key → DISEASE_TYPE_INFO.DISEASE_TYPE_ID — NOT NULL
- IMAGE_PATH — VARCHAR(50)
- PREDICT_LABEL_PATH — VARCHAR(50)
- PREDICT_SCORE — DECIMAL(2,0)
DISEASE_TYPE_INFO
- DISEASE_TYPE_ID (DISEASE_TYPE_ID_PK) — VARCHAR(50) — Primary key — NOT NULL
- DISEASE_TYPE — VARCHAR(50)
- DISEASE_TYPE_ID (DISEASE_TYPE_ID_FK) — VARCHAR(50) — Foreign key → DISEASE_TYPE_INFO.DISEASE_TYPE_ID
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_INFO
- 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)