냥몽2

테이블 (10)

cat_kind (Untitled3)

  • desertion_no (Key) — 기본 키 — NOT NULL
  • abyssinian (Field)
  • american_shorthair (Field2)
  • bengal (Field3)
  • birman (Field4)
  • bombay (Field5)
  • british_shorthair (Field6)
  • cornish_rex (Field7)
  • devon_rex (Field8)
  • domestic (Field9)
  • maine_coon (Field10)
  • munchkin (Field11)
  • norwegian_forest_cat (Field12)
  • others (Field13)
  • persian (Field14)
  • ragdoll (Field15)
  • russian_blue (Field16)
  • scottish_fold (Field17)
  • siamese (Field18)
  • sphynx (Field19)
  • turkish_angora (Field20)
  • turkish_van (Field21)

cat_processing_table (Untitled15)

  • desertion_no (Key) — 기본 키 — NOT NULL
  • job_type (Field2)
  • status (Field)

color (Untitled4)

  • desertion_no (Key) — 기본 키 — NOT NULL
  • black (Field)
  • white (Field2)
  • gray (Field3)
  • brown (Field4)
  • orange (Field5)
  • yellow (Field6)

dog_kind (Untitled2)

  • desertion_no (Key) — VARCHAR — 기본 키 — NOT NULL
  • basset (Field) — FLOAT
  • beagle (Field2)
  • border_collie (Field3)
  • boston_bull (Field4)
  • boxer (Field5)
  • chihuahua (Field6)
  • chow (Field7)
  • cocker_spaniel (Field8)
  • doberman (Field9)
  • french_bulldog (Field10)
  • german_shepherd (Field11)
  • golden_retriever (Field12)
  • great_dane (Field13)
  • great_pyrenees (Field14)
  • italian_greyhound (Field15)
  • japanese_spaniel (Field16)
  • labrador_retriever (Field17)
  • ihasa (Field18)
  • malamute (Field19)
  • maltese (Field20)
  • miniature_pinscher (Field21)
  • miniature_schnauzer (Field22)
  • newfoundland (Field23)
  • old_english_sheepdog (Field24)
  • others (Field25)
  • papillon (Field26)
  • pekinese (Field27)
  • pomeranian (Field28)
  • poodle (Field29)
  • pug (Field30)
  • rottweiler (Field31)
  • saint_bernard (Field32)
  • samoyed (Field33)
  • shetland_sheepdog (Field34)
  • shih_tzu (Field35)
  • siberian_husky (Field36)
  • welsh_corgi (Field37)
  • west_highland_white_terrier (Field38)
  • yorkshire_terrier (Field39)

dog_processing_table (Untitled)

  • desertion_no (Key) — 기본 키 — NOT NULL
  • job_type (Field2)
  • status (Field)

동물병원 (Untitled17)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • service_name (Field) — VARCHAR
  • service_id (Field2) — VARCHAR
  • region_code (Field3) — VARCHAR
  • management_number (Field4) — VARCHAR
  • approval_date (Field5) — DATETIME
  • permit_cancel_date (Field6) — DATETIME
  • business_status_code (Field7) — VARCHAR
  • business_status_name (Field8) — VARCHAR
  • detailed_business_status_code (Field9) — VARCHAR
  • detailed_business_status_name (Field10) — VARCHAR
  • closure_date (Field11) — DATETIME
  • temporary_closure_start_Date (Field12) — DATETIME
  • temporary_closure_end_date (Field13) — DATETIME
  • reopening_date (Field14) — DATETIME
  • phone_number (Field15) — VARCHAR
  • site_area (Field16) — VARCHAR
  • postal_code (Field17) — VARCHAR
  • full_address (Field18) — VARCHAR
  • road_address (Field19) — VARCHAR
  • road_postal_code (Field20) — VARCHAR
  • business_name (Field21) — VARCHAR
  • last_modified (Field22) — DATETIME
  • data_update_type (Field23) — VARCHAR
  • data_update_date (Field24) — DATETIME
  • business_type (Field25) — VARCHAR
  • coordinate_x (Field26) — DECIMAL
  • coordinate_y (Field27) — DECIMAL
  • task_type (Field28) — VARCHAR
  • detailed_task_type (Field29) — VARCHAR
  • rights_holder_number (Field30) — VARCHAR
  • total_employees (Field31) — INT

반려동물 동반가능 문화시설 (Untitled18)

  • map_id (Key) — BIGINT — 기본 키 — NOT NULL
  • addr1 (Field) — VARCHAR
  • addr2 (Field2) — VARCHAR
  • address_code (Field3) — ADDRESSCODE
  • content_type (Field4) — CONTENTTYPE
  • image1 (Field5) — VARCHAR
  • image2 (Field6) — VARCHAR
  • mapx (Field7) — DECIMAL
  • mapy (Field8) — DECIMAL
  • tel (Field9) — VARCHAR
  • title (Field10) — VARCHAR
  • zip_code (Field11) — VARCHAR
  • content_id (Field12) — VARCHAR
  • create_at (Field13) — DATETIME
  • update_at (Field14) — DATETIME

반려동물 동반가능 시설 (Untitled16)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • facility_name (Field) — VARCHAR
  • category_one (Field2) — VARCHAR
  • category_two (Field3) — VARCHAR
  • category_three (Field4) — VARCHAR
  • sido (Field5) — VARCHAR
  • sigungu (Field6) — VARCHAR
  • legal_dong (Field7) — VARCHAR
  • liName (Field8) — VARCHAR
  • lnbrNo (Field9) — VARCHAR
  • road_name (Field10) — VARCHAR
  • building_no (Field11) — VARCHAR
  • mapx (Field12) — VARCHAR
  • mapy (Field13) — VARCHAR
  • zip_no (Field14) — VARCHAR
  • roadAddress (Field15) — VARCHAR
  • full_address (Field16) — VARCHAR
  • tel_num (Field17) — VARCHAR
  • url (Field18) — VARCHAR
  • rest_info (Field19) — VARCHAR
  • oper_time (Field20) — VARCHAR
  • parking (Field21) — VARCHAR
  • price (Field22) — VARCHAR
  • pet_with (Field23) — VARCHAR
  • pet_info (Field24) — VARCHAR
  • pet_size (Field25) — VARCHAR
  • pet_restict (Field26) — VARCHAR
  • in_place (Field27) — VARCHAR
  • out_place (Field28) — VARCHAR
  • info_desc (Field29) — VARCHAR
  • extra_fee (Field30) — VARCHAR
  • last_update (Field31) — DATETIME

반려동물 행사 (Untitled5)

  • festival_id (Key) — BIGINT — 기본 키 — NOT NULL
  • title (Field2) — VARCHAR
  • url (Field3) — VARCHAR
  • location (Field4) — VARCHAR
  • festival_date (Field5) — VARCHAR
  • festival_time (Field6) — VARCHAR
  • money (Field7) — VARCHAR
  • hash (Field8) — VARCHAR
  • image_path (Field9) — VARCHAR
  • reservation_date (Field10) — VARCHAR
  • updated_at (Field11) — DATETIME
  • created_at (Field12) — DATETIME
  • start_date (Field) — DATETIME
  • end_date (Field13) — DATETIME

유기 동물 (Untitled6)

  • dessertion_no (Key) — VARCHAR — 기본 키 — NOT NULL
  • rfid_cd (Field) — VARCHAR
  • happen_at (Field2) — VARCHAR
  • happenPlace (Field3) — VARCHAR
  • up_kind_no (Field4) — VARCHAR
  • kind_no (Field5) — VARCHAR
  • color_cd (Field6) — VARCHAR
  • age (Field7) — VARCHAR
  • weight (Field8) — VARCHAR
  • notice_sdt (Field9) — VARCHAR
  • notice_edt (Field10) — VARCHAR
  • popFile1 (Field11) — VARCHAR
  • popFile2 (Field12) — VARCHAR
  • process_state (Field13) — VARCHAR
  • sex_cd (Field14) — SEXCODE
  • neuter_yn (Field15) — NEUTERYN
  • special_mark (Field16) — VARCHAR
  • care_nm (Field17) — VARCHAR
  • care_tel (Field18) — VARCHAR
  • care_addr (Field19) — VARCHAR
  • care_owner_nm (Field20) — VARCHAR
  • org_nm (Field21) — VARCHAR
  • etc_bigo (Field22) — VARCHAR
  • create_at (Field23) — DATETIME
  • update_at (Field24) — DATETIME