냥몽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