MNRader

Tables (6)

Animal

  • id — BIGINT — Primary key — NOT NULL — Auto Increasement
  • breed_id — BIGINT — Foreign key → Breed.id — NOT NULL — Auto Increasement
  • user_id — BIGINT — Foreign key → User.id — NOT NULL — Auto Increasement
  • region_id — BIGINT — Foreign key → Region.id — NOT NULL
  • status — INT — NOT NULL — LOST(1), PROTECTED(2), SIGHTING(3),NONE(4)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • address — varchar(200) — NOT NULL — 전체 주소
  • gender — INT — NOT NULL — MALE(1), FEMAIL(2), UNKNOWN(3)
  • occurredAt — TIMESTAMP — NOT NULL
  • phone — varchar(30) — NOT NULL — 등록인 전화번호
  • name — varchar(30) — NOT NULL — 등록인 이름
  • detail — TEXT
  • image (Field) — TEXT

Animal_User

  • id — BIGINT — Primary key — NOT NULL — Auto Increasement
  • breed_id — BIGINT — Foreign key → Breed.id — NOT NULL — Auto Increasement
  • user_id — BIGINT — Foreign key → User.id — NOT NULL — Auto Increasement
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • gender — INT — NOT NULL — MALE(1), FEMAIL(2), UNKNOWN(3)
  • detail — TEXT
  • image (Field) — TEXT
  • age — INT — NOT NULL
  • name — varchar(40) — NOT NULL — 동물 이름

Breed

  • id — BIGINT — Primary key — NOT NULL
  • animal_type (Field) — INT — NOT NULL — DOG(1), CAT(2), OTHER(3)
  • breed — varchar(50) — NOT NULL

Region

  • id — BIGINT — Primary key — NOT NULL
  • city — varchar(200) — NOT NULL — 시/도

Scrap

  • id — BIGINT — Primary key — NOT NULL — Auto Increasement
  • user_id — BIGINT — Foreign key → User.id — NOT NULL — Auto Increasement
  • animal_id — BIGINT — Foreign key → Animal.id — NOT NULL — Auto Increasement

User

  • id — BIGINT — Primary key — NOT NULL — Auto Increasement
  • region_id — BIGINT — Foreign key → Region.id — NOT NULL
  • status — INT — NOT NULL — ACTIVE(1), INACTIVE(2), SUSPEND(3)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • email — varchar(254) — NOT NULL
  • password — varchar(200) — NOT NULL
  • refresh_token — VARCHAR(512)
  • fcm_token — VARCHAR(512)