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)