ComePetHomeService
Tables (6)
Animal (emergency_alert)
- id — number — Primary key — NOT NULL — id
- enlistment_date (create_date) — datetime — NOT NULL — 알림 발신 생성 날짜
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- Field (location_id) — number — NOT NULL — 수신 지역 코드
- Field (location_name) — varchar{256} — NOT NULL
- Field (md101_sn) — number — NOT NULL
- Field (msg) — varchar(1024) — NOT NULL — 메세지 내용
- Field (send_platform) — varchar(256) — NOT NULL — 메세지 발신처
User (user)
- id — number — Primary key — NOT NULL
- user_id — varchar(32) — NOT NULL — 아이디
- access_token — varchar(256)
- refresh_token — varchar(256) — NOT NULL
- nickname — varchar(32) — NOT NULL
- image_url — varchar(256)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
animal_comment (emergency_alert_comment)
- id — Primary key — NOT NULL
- user_id — number — Foreign key → User.id — NOT NULL
- id (id2) — number — Foreign key → Animal.id — NOT NULL — id
- text — varchar(256) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
animal_like (message_like)
- id — number — Primary key — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- is_active — tinyint(1) — NOT NULL
- user_id — number — Foreign key → User.id — NOT NULL
- animal_id — number — Foreign key → Animal.id — NOT NULL — id
article
- id — number — Primary key — NOT NULL
- title — varchar(256) — NOT NULL
- contents — varchar(1024) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- view — number — NOT NULL
article_comment
- id — Primary key — NOT NULL
- user_id — number — Foreign key → User.id — NOT NULL
- id (id2) — number — Foreign key → article.id — NOT NULL
- text — varchar(256) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL