SITE: Hyundai News USA · DB: reports_hyundai_usa

TABLES (19) with approx rows:
  detail_email_statistics  ~7198452
  detail_release_statistics  ~4874553
  detail_media_statistics  ~1518977
  detail_model_statistics  ~1087008
  media  ~23972
  category_media  ~18252
  release_media  ~10066
  media_model  ~6905
  releases  ~4795
  release_categories  ~2149
  models  ~1428
  emails  ~1358
  users  ~1298
  release_models  ~1227
  email_releases  ~1167
  categories  ~104
  migrations  ~26
  detail_blog_statistics  ~0
  blogs  ~0

== detail_email_statistics
  id  bigint unsigned  [PRI]
  campaign_id  bigint unsigned  [MUL]
  event  tinyint  [MUL]
  email  varchar(255)
  url  varchar(255)
  date_sent  timestamp
  date_event  timestamp
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== detail_release_statistics
  id  bigint unsigned  [PRI]
  release_id  int unsigned  [MUL]
  user_id  mediumint unsigned  [MUL]
  resource  tinyint  [MUL]
  action  tinyint  [MUL]
  ip_address  varchar(45)
  country  varchar(100)
  date_event  timestamp
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== detail_media_statistics
  id  bigint unsigned  [PRI]
  media_id  int unsigned  [MUL]
  user_id  mediumint unsigned  [MUL]
  action  tinyint  [MUL]
  ip_address  varchar(45)
  country  varchar(100)
  date_event  timestamp
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== detail_model_statistics
  id  bigint unsigned  [PRI]
  model_id  smallint unsigned  [MUL]
  user_id  mediumint unsigned  [MUL]
  action  tinyint  [MUL]
  ip_address  varchar(45)
  country  varchar(100)
  date_event  timestamp
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== media
  id  int unsigned  [PRI]
  name  varchar(255)
  type  tinyint  [MUL]
  locale  tinyint
  status  tinyint  [MUL]
  published  datetime
  viewed  mediumint
  downloaded  mediumint
  add_to_basket  mediumint
  remove_from_basket  mediumint
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp
  title  longtext

== category_media
  id  int unsigned  [PRI]
  media_id  int unsigned  [MUL]
  category_id  smallint unsigned  [MUL]

== release_media
  id  int unsigned  [PRI]
  release_id  int unsigned  [MUL]
  media_id  int unsigned  [MUL]

== media_model
  id  int unsigned  [PRI]
  media_id  int unsigned  [MUL]
  model_id  smallint unsigned  [MUL]

== releases
  id  int unsigned  [PRI]
  locale  int
  title  longtext
  status  tinyint  [MUL]
  published  datetime
  viewed  mediumint
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== release_categories
  id  int unsigned  [PRI]
  release_id  int unsigned  [MUL]
  category_id  smallint unsigned  [MUL]

== models
  id  smallint unsigned  [PRI]
  slug  varchar(255)
  locale  tinyint
  name  varchar(255)
  alternative_name  varchar(255)
  parent  int
  sort  mediumint
  status  tinyint  [MUL]
  published  datetime
  viewed  mediumint
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== emails
  id  int unsigned  [PRI]
  campaign_id  bigint unsigned  [MUL]
  resource  tinyint  [MUL]
  type  varchar(255)
  title  varchar(255)
  sent_date  timestamp
  opened  smallint unsigned
  click  smallint unsigned
  unsubscribe  smallint unsigned
  spam  smallint unsigned
  hard_bounce  smallint unsigned
  soft_bounce  smallint unsigned
  delivered  smallint unsigned
  initial_open  smallint unsigned
  recipients  smallint unsigned
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== users
  id  mediumint unsigned  [PRI]
  email  varchar(255)
  first_name  varchar(255)
  last_name  varchar(255)
  type  varchar(255)
  status  tinyint  [MUL]
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== release_models
  id  int unsigned  [PRI]
  release_id  int unsigned  [MUL]
  model_id  smallint unsigned  [MUL]

== email_releases
  id  bigint unsigned  [PRI]
  email_id  int unsigned  [MUL]
  release_id  int unsigned  [MUL]

== categories
  id  smallint unsigned  [PRI]
  slug  varchar(255)
  name  varchar(255)
  alternative_name  varchar(255)
  parent  int
  sort  mediumint
  status  tinyint  [MUL]
  published  datetime
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== migrations
  id  int unsigned  [PRI]
  migration  varchar(255)
  batch  int

== detail_blog_statistics
  id  bigint unsigned  [PRI]
  blog_id  int unsigned  [MUL]
  user_id  mediumint unsigned  [MUL]
  action  tinyint  [MUL]
  ip_address  varchar(45)
  country  varchar(100)
  date_event  timestamp
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

== blogs
  id  int unsigned  [PRI]
  locale  tinyint
  title  varchar(255)
  status  tinyint  [MUL]
  published  datetime
  viewed  mediumint
  created_at  timestamp
  updated_at  timestamp
  deleted_at  timestamp

ACTION CODES in detail_release_statistics:
[
 {
  "action": 1,
  "events": 5362336,
  "first": "2021-12-22T13:59:00.000Z",
  "last": "2026-08-18T23:09:16.000Z"
 }
]
