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)