ㅑㅓㅑㅓㅑ

Tables (7)

animal_status (Untitled)

  • animal_id (Key) — INT — Primary key — NOT NULL
  • shelter_id — INT — Foreign key → shelter_fianl.shelter_id — NOT NULL
  • region (Field) — TEXT
  • register_date (Field2) — TEXT
  • register_end_date (Field3) — TEXT
  • breed (Field4) — TEXT
  • breedcode (Field5) — TEXT
  • color (Field6) — TEXT
  • years (Field7) — TEXT
  • weight (Field8) — TEXT
  • gender (Field9) — TEXT
  • shelter_name (Field10)

favorites (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • animal_id (Key2) — INT — Foreign key → animal_status.animal_id — NOT NULL
  • user_id (Field) — INT
  • created_at (Field2)
  • id (Key3) — INT — Foreign key → users.id — NOT NULL

hospital_final (Untitled2)

  • hospital_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — TEXT
  • phone (Field2) — TEXT
  • region (Field3) — TEXT
  • lat (Field4) — REAL
  • lon (Field5)

pharmacy_final (Untitled3)

  • pharmacy_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — TEXT
  • address (Field2) — TEXT
  • phone (Field3) — TEXT
  • region (Field4) — TEXT
  • lat (Field5) — REAL
  • lon (Field6) — REAL

shelter_fianl (shelter_final)

  • shelter_id — INT — Primary key — NOT NULL
  • name — TEXT
  • address (Field) — TEXT
  • phone (Field2) — TEXT
  • capacity (Field3) — INT

sqlite_sequence (Untitled5)

  • name (Field) — TEXT
  • seq (Field2) — INT

users (Untitled6)

  • id (Key) — INT — Primary key — NOT NULL
  • email (Field) — TEXT
  • password_hash (Field2)
  • name (Field3) — TEXT
  • is_admin (Field4)
  • created_at (Field5)