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
UserActivityType
- user_activity_type_id — BIGINT
- name — VARCHAR(255)