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)