ㅑㅓㅑㅓㅑ
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)