p1

Tables (15)

animal_disease (보유질병)

  • disease_id (Key) — Primary key — NOT NULL
  • disease_name (Field)
  • disease_detail (Field2)
  • disease_vacc (Field3)

animal_species (CopyOfCopyOfUntitled11)

  • species_id (Key) — Primary key — NOT NULL
  • species_name (Field)
  • species_img (Field2)

animal_vacc (백신접종)

  • vacc_id (Key) — Primary key — NOT NULL
  • vacc_name (Field)
  • vacc_cycle (Field2)

designer (Untitled6)

  • designer_id (Key) — Primary key — NOT NULL
  • shop_id (Field2)
  • designer_name (Field)
  • designer_tel (Field3)
  • designer_auth_no (Field4)
  • designer_reg_date (Field5)
  • Field6

fom_mb (pom_mb)

  • mb_id (int(11)) — Primary key — NOT NULL
  • mb_name (Field8)
  • mb_password (Field)
  • mb_name (Field2)
  • mb_email (Field3)
  • mb_certify (Field6)
  • mb_tel1 (Field4)
  • mb_tel2 (Field5)
  • mb_payinfo (Field7) — F
  • mb_favorite (Field9) — F
  • Field10
  • Field11
  • Field12
  • Field13
  • Field14
  • Field15

mb_animal (Untitled)

  • mb_animal_id (int(11)) — 33333ijkjnkjnk — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • anm_id (Field)
  • anm_ spe·cies (Field2)
  • anm_name (Field3)
  • anm_sex (Field4)
  • anm_age (Field5)
  • anm_wgt (Field6)
  • anm_ neut (Field7)
  • anm_vacc (Field8) — Fk
  • anm_diss (Field9)
  • anm_auth (Field10)
  • anm_speci (Field11)

mb_favorite (Untitled8)

  • favorite_id (Key) — Primary key — NOT NULL
  • mb_id (Field)
  • shop_id (Field2)

mb_pay (Untitled4)

  • pay_id (Key) — Primary key — NOT NULL
  • mb_id (Field)
  • pay_name (Field2)
  • pay_password (Field3)
  • pay_card_no (Field4)
  • pay_acct_no (Field5)
  • Field6

mb_payment_history (Untitled2)

  • payment_id (Key) — Primary key — NOT NULL
  • mb_id (int(11)) — Foreign key → fom_mb.mb_id — NOT NULL
  • Field2

review (Untitled9)

  • review_id (Key) — Primary key — NOT NULL
  • shop_id (Field)
  • review_rating (Field2)

review_file (Untitled10)

  • review_file_id (Key) — Primary key — NOT NULL

services (Untitled3)

  • service_id (Key) — Primary key — NOT NULL
  • service_name (Field)
  • service_default_price (Field2)
  • Field3 — F
  • Field4

shop (Untitled5)

  • shop_id (Key) — Primary key — NOT NULL
  • shop_name (Field)
  • shop_bsns_no (Field2)
  • shop_addr (Field3)
  • shop_tel1 (Field4)
  • shop_tel2 (Field5)
  • shop_dsgnr_no (Field7) — FK
  • shop_service (Field8) — FK
  • shop_facility (Field9) — FK
  • shop_signin_date (Field6)
  • shop_img (Field10) — FK
  • shop_addr_longlang (Field11)
  • shop_bsns_hour (Field12)
  • shop_grade (Field13)

shop_file (Untitled7)

  • shop_file_id (Key) — Primary key — NOT NULL
  • Field

shop_history (Untitled11)

  • shop_history_id (Key) — Primary key — NOT NULL
  • designer_id (Field) — F
  • service_id (Field2) — F
  • Field3