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