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