Commentary on development for checklist as a task is available here in these scrollable notes:
We're going to make it an educational experience
@TXTWRK, where you can learn how we all did it...
CHECKLIST AS TASKS...
I have two tables that I need updating and some new tables making, do not include the foreign keys too.
post_checklist (checklist_id, post_id, checklist_name, date_created, member_id, ...add new columns: items_count, items_complete, applicant_count, user_count)
post_checklist_items (item_id, checklist_id, item_name, checklist_group_name, item_objective, date_made, date_completed, complete, ...add: member_id, post_id, item_existing_data, sourcing (1 or 0), user_count, user_type (var like Volunteer or Paid), reply_count, replies_count (reply to replies), topics_count, topics_count_active, pinned_reply_count, pinned_replies_count, communications (Active or Paused))
post_checklist_user (id, applicant_id, item_id, apply_date, user_id, message, status, isread, message_utc, checklist_id, checklist_admin, applicant_admin, item_admin, reply, reply_acknowledge, reply_pin, reply_hide, reply_topic)
post_checklist_topic (topic_id, item_id, user_id, topic_name, date_utc, updated_by_id, removed (0 or 1), removed_by_id)
post_check_replying (id, reply_id, replies_id, r_number, topic_id, date_utc, pinned (0 or 1), pinned_by_id, pinned_date, hidden (0 or 1), hidden_by_id, hidden_date, reply_count, acknowledge_count, pinned_count, hide_count)
post_check_acknowledging (id, reply_id, replies_id (one of the other), acknowledge_status (0 or 1), date_utc, date_utc_updated)
Notes
Needs
Contributions
Timetable
Intel
To Dos
🗖 VIEW
🗖 VIEW
🗖 VIEW
