temp
Tables (17)
animal
- animal_id — NUMBER — Primary key — NOT NULL
- type — VARCHAR2(500 BYTE)
- sex — VARCHAR2(100 BYTE)
- weight — NUMBER
- age — NUMBER
- aname — 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.user_email — NOT NULL
care_animal
- care_animal_id — NUMBER — Primary key — NOT NULL
- hospital_id — NUMBER — Foreign key → hospital.hospital_id — NOT NULL
- animal_id — NUMBER — Foreign key → animal.animal_id — NOT NULL
category
- category_id — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(100 BYTE)
content
- content_id — NUMBER — Primary key — NOT NULL
- title — VARCHAR2(1000 BYTE)
- body — VARCHAR2(4000 BYTE)
- created_date — DATE
- updated_date — DATE
- category_id — NUMBER — Foreign key → category.category_id — NOT NULL
- user_email — VARCHAR2(1000 BYTE) — Foreign key → zalbazo_user.user_email — NOT NULL
faq
- faq_id — NUMBER — NOT NULL
- question — VARCHAR2(4000 BYTE)
- answer — VARCHAR2(4000 BYTE)
favorite_hospital
- f_hospital_id — NUMBER — Primary key — NOT NULL
- user_email — VARCHAR2(1000 BYTE) — Foreign key → zalbazo_user.user_email — NOT NULL
- hospital_id — NUMBER — Foreign key → hospital.hospital_id — NOT NULL
hospital
- hospital_id — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(1000 BYTE)
- address — VARCHAR2(3000 BYTE)
- treat_start — VARCHAR2(20 BYTE)
- treat_end — VARCHAR2(20 BYTE)
- tel — VARCHAR2(20 BYTE)
- info — VARCHAR2(4000 BYTE)
hospital_label
- label_code — NUMBER — Foreign key → label.code — NOT NULL
- hospital_id — NUMBER — Foreign key → hospital.hospital_id — NOT NULL
hospital_qna
- hospital_qna_id — NUMBER — Primary key — NOT NULL
- hospital_id — NUMBER — Foreign key → hospital.hospital_id — NOT NULL
- content_id — NUMBER — Foreign key → content.content_id — NOT NULL
- qna_type — VARCHAR2(10 BYTE)
- c_group — NUMBER
label
- code — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(100 BYTE)
pic_lib
- uuid — VARCHAR2(100 BYTE) — Primary key — NOT NULL
- upload_path — VARCHAR2(200 BYTE) — NOT NULL
- file_name — VARCHAR2(100 BYTE) — NOT NULL
pic_lib_rel_content
- uuid — VARCHAR2(100 BYTE) — Foreign key → pic_lib.uuid — NOT NULL
- content_id — NUMBER — Foreign key → content.content_id — NOT NULL
pic_lib_rel_hospital
- uuid — VARCHAR2(100 BYTE) — Foreign key → pic_lib.uuid — NOT NULL
- hospital_id — NUMBER — Foreign key → hospital.hospital_id — NOT NULL
reply
- reply_id — NUMBER — Primary key — NOT NULL
- body — VARCHAR2(3000 BYTE)
- created_date — DATE
- updated_date — DATE
- user_email — VARCHAR2(1000 BYTE) — Foreign key → zalbazo_user.user_email — NOT NULL
- content_id — NUMBER — Foreign key → content.content_id — NOT NULL
reserve
- reserve_id — NUMBER — Primary key — NOT NULL
- note — VARCHAR2(4000 BYTE)
- rdate — DATE
- animal_id — NUMBER — Foreign key → animal.animal_id — NOT NULL
- hospital_id — NUMBER — Foreign key → hospital.hospital_id — NOT NULL
- status — VARCHAR2(100 BYTE)
- user_email — VARCHAR2(1000 BYTE) — Foreign key → zalbazo_user.user_email — NOT NULL
review
- review_id — NUMBER — Primary key — NOT NULL
- hospital_id — NUMBER — Foreign key → hospital.hospital_id — NOT NULL
- content_id — NUMBER — Foreign key → content.content_id — NOT NULL
- star_point — NUMBER
zalbazo_user
- user_email — VARCHAR2(1000 BYTE) — Primary key — NOT NULL
- password — VARCHAR2(500 BYTE) — NOT NULL
- role — VARCHAR2(100 BYTE)
- tel — VARCHAR2(20 BYTE)
- address — VARCHAR2(1000 BYTE)
- name — VARCHAR2(500 BYTE)
- join_date — DATE
- last_login — DATE
- enabled — VARCHAR2(20 BYTE)
- email_auth_key — VARCHAR2(50 BYTE)
- hospital_id — NUMBER — Foreign key → hospital.hospital_id