fordong
Tables (8)
banner (배너)
- id (Key) — Primary key — NOT NULL
- banner_img (Field)
- title_img (Field2)
- description (Field3)
- link_label (Field4)
- link_src (Field5)
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