hm1

Tables (14)

Hashtag

  • hashtag_id — BIGINT
  • name — VARCHAR(255)

Location

  • location_id — BIGINT
  • name — VARCHAR(255)
  • parent_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

Log

  • log_id — BIGINT
  • user_id — BIGINT
  • activity_type_id — BIGINT
  • activity_details — JSON
  • ip — VARCHAR(45)
  • created_at — DATETIME

Magazine

  • magazine_id — BIGINT
  • organization_id — BIGINT
  • title — VARCHAR(255)
  • description — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

MagazineBookmark

  • magazine_bookmark_id — BIGINT
  • magazine_id — BIGINT
  • user_id — BIGINT

MagazineHashtag

  • magazine_id — BIGINT
  • hashtag_id — BIGINT

MagazineImage

  • magazine_photo_id — BIGINT
  • magazine_id — BIGINT
  • image_url — VARCHAR(255)

MagazineLike

  • magazine_like_id — BIGINT
  • magazine_id — BIGINT
  • user_id — BIGINT

Organization

  • organization_id — BIGINT
  • name — VARCHAR(255)
  • photo_url — VARCHAR(255)
  • homepage_url — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

Policy

  • policy_id — BIGINT
  • location_id — BIGINT
  • description — VARCHAR(255)
  • policy_url — VARCHAR(255)
  • policy_category_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

PolicyAlert

  • policy_alert_id — BIGINT
  • user_id — BIGINT
  • policy_id — BIGINT
  • sent_at — DATETIME

PolicyCategory

  • policy_category_id — BIGINT
  • name — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

User

  • user_id — BIGINT

UserActivityType

  • user_activity_type_id — BIGINT
  • name — VARCHAR(255)