fordong

Tables (8)

banner (배너)

  • id (Key) — Primary key — NOT NULL
  • banner_img (Field)
  • title_img (Field2)
  • description (Field3)
  • link_label (Field4)
  • link_src (Field5)

class (Untitled)

    owner (견주)

    • id (Key) — Primary key — NOT NULL
    • name (Field)
    • phone (Field2)
    • gender (Field3)
    • age (Field4)
    • region_detail_id (Key2) — Foreign key → region_detail.id — NOT NULL

    pet (반려견)

    • id (Key) — Primary key — NOT NULL
    • name (Field)
    • type (Field2)
    • age (Field3)
    • sex (Field4)
    • isNeutering (Field5)
    • owner_id (Key2) — Foreign key → owner.id — NOT NULL

    region (법정동 시/시군구)

    • id (Key) — Primary key — NOT NULL
    • city_code (Field)
    • city (Field2)
    • sgg_code (Field5)
    • sgg (Field3)
    • application_cnt (Field4)

    region_detail (법정동 읍면동)

    • id (Key) — Primary key — NOT NULL
    • code (Field)
    • umd (Field2)
    • region_id (Key2) — Foreign key → region.id — NOT NULL

    review (클래스 리뷰)

    • id (Key) — Primary key — NOT NULL
    • content (Field)
    • owner_id (Key2) — Foreign key → owner.id — NOT NULL

    review_image (리뷰 이미지)

    • id (Key) — Primary key — NOT NULL
    • src (Field)
    • review_id (Key2) — Foreign key → review.id — NOT NULL