pitpet

Tables (3)

dogs (견종)

  • id (아이디) — Primary key — NOT NULL
  • name (견종명) — VARCHAR

grades (등급)

  • id (아이디) — Primary key — NOT NULL
  • insurances_id (보험 아이디) — Foreign key → dogs.id — NOT NULL
  • dogs_id (견종 아이디) — Foreign key → insurances.id — NOT NULL
  • grade (등급) — ENUM
  • rate (갱신율)
  • price (월 가격)

insurances (보험사)

  • id (아이디) — Primary key — NOT NULL
  • name (보험사명) — VARCHAR