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