ddd

Tables (12)

ANIMAL

  • ANIMAL_ID — NUMBER
  • TYPE — VARCHAR2(500 BYTE)
  • SEX — VARCHAR2(100 BYTE)
  • WEIGHT — NUMBER
  • AGE — NUMBER
  • NAME — VARCHAR2(300 BYTE)
  • NOTE — VARCHAR2(3000 BYTE)
  • LAST_TREAT_DATE — DATE
  • CREATED_DATE — DATE
  • UPDATED_DATE — DATE
  • USER_EMAIL — VARCHAR2(1000 BYTE) — Foreign key → ZALBAZO_USER.EMAIL

CATEGORY

  • CATEGORY_ID — NUMBER
  • NAME — VARCHAR2(100 BYTE)

CONTENT

  • CONTENT_ID — NUMBER
  • TITLE — VARCHAR2(1000 BYTE)
  • BODY — VARCHAR2(4000 BYTE)
  • CREATED_DATE — DATE
  • UPDATED_DATE — DATE
  • CATEGORY_ID — NUMBER — Foreign key → CATEGORY.CATEGORY_ID
  • USER_EMAIL — VARCHAR2(1000 BYTE) — Foreign key → ZALBAZO_USER.EMAIL

HOSPITAL

  • HOSPITAL_ID — NUMBER
  • NAME — VARCHAR2(1000 BYTE)
  • ADDRESS — VARCHAR2(3000 BYTE)
  • TREAT_START — VARCHAR2(20 BYTE)
  • TREAT_END — VARCHAR2(20 BYTE)
  • TEL — NUMBER
  • INFO — VARCHAR2(4000 BYTE)

HOSPITAL_QNA

  • HOSPITAL_QNA_ID — NUMBER
  • HOSPITAL_ID — NUMBER — Foreign key → HOSPITAL.HOSPITAL_ID
  • CONTENT_ID — NUMBER — Foreign key → CONTENT.CONTENT_ID

LABEL

  • CODE — NUMBER
  • NAME — VARCHAR2(100 BYTE)

PIC_LIB

  • UUID — VARCHAR2(100 BYTE)
  • UPLOAD_PATH — VARCHAR2(200 BYTE)
  • FILE_NAME — VARCHAR2(100 BYTE)

PIC_LIB_REL_CONTENT

  • UUID — VARCHAR2(100 BYTE)
  • CONTENT_ID — NUMBER

PIC_LIB_REL_HOSPITAL

  • UUID — VARCHAR2(100 BYTE)
  • HOSPITAL_ID — NUMBER

REPLY

  • REPLY_ID — NUMBER
  • BODY — VARCHAR2(3000 BYTE)
  • CREATED_DATE — DATE
  • UPDATED_DATE — DATE
  • USER_EMAIL — VARCHAR2(1000 BYTE) — Foreign key → ZALBAZO_USER.EMAIL
  • CONTENT_ID — NUMBER — Foreign key → CONTENT.CONTENT_ID

RESERVE

  • RESERVE_ID — NUMBER
  • NOTE — VARCHAR2(4000 BYTE)
  • DATE — DATE
  • ANIMAL_ID — NUMBER — Foreign key → ANIMAL.ANIMAL_ID
  • HOSPITAL_ID — NUMBER — Foreign key → HOSPITAL.HOSPITAL_ID
  • STATUS — VARCHAR2(100 BYTE)

ZALBAZO_USER

  • EMAIL — VARCHAR2(1000 BYTE)
  • PASSWORD — VARCHAR2(500 BYTE)
  • ROLE — VARCHAR2(100 BYTE)
  • TEL — NUMBER
  • ADDRESS — VARCHAR2(1000 BYTE)
  • NAME — VARCHAR2(500 BYTE)
  • JOIN_DATE — DATE
  • LAST_LOGIN — DATE