Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Api: Admin communication system #1582

Open
daleighan opened this issue Mar 6, 2020 · 1 comment
Open

Api: Admin communication system #1582

daleighan opened this issue Mar 6, 2020 · 1 comment

Comments

@daleighan
Copy link
Contributor

daleighan commented Mar 6, 2020

This will be a part on user profiles that allows for the tracking of e-mail and text communications. It should also allow the resending of communications. There will also be a web branch for this.
What it will need:

  1. A new user_coms table
  2. Store all outgoing texts/emails in this table
  3. An interface that shows the history of emails sent out to a user and allows sending them again. It may eventually have various ways of sorting users
  4. An interface that shows a text messaging thread with the user
@daleighan
Copy link
Contributor Author

daleighan commented Mar 9, 2020

create table user_communications (
  id int(11) NOT NULL AUTO_INCREMENT,
  user_id int(11) NOT NULL,
  creator_id int(11),
  type enum('sms', 'email') NOT NULL,
  content text NOT NULL,
  created_at datetime NOT NULL,
  updated_at datetime NOT NULL,
  deleted_at datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
);
alter table cars add column airtable_data text default null after comments;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant