asd
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