1. Idea Database

This database is the starting point for all new concepts and improvements.

• Properties:
  • ~~Title: Name of the idea.~~
  • ~~Description: Detailed explanation.~~
  • ~~Status: Options like Brainstorming, Validating, Validated, Discarded.~~
  • ~~Category: Such as Feature, Improvement, Integration.~~
  • ~~Created On: Date the idea was added.~~
  • ~~Updated On: For tracking changes.~~
  • ~~Related Task: Link to tasks that originate from this idea.~~
  • ~~Related Decision: Link to decisions required for this idea.~~
• Views:
  • ~~Board View: Group by Status to manage progress.~~
  • ~~Table View: Detailed list of all ideas.~~
  • ~~Calendar View: Visual timeline of idea creation.~~

2. Decision Database

Houses all critical decisions that need to be made for ideas and tasks.

• Properties:
  • ~~Decision Required: Description of the decision to be made.~~
  • ~~Options: Text to list possible choices.~~
  • ~~Outcome: Pending, Decided.~~
  • ~~Impact: How this decision affects the project.~~
  • ~~Related Idea: Link to the related idea.~~
  • ~~Related Task: Link to the task that depends on this decision.~~
• Views:
  • ~~Table View: Overview of all decisions.~~
  • ~~Board View: Organized by Outcome to track progress.~~

3. Task Database

Lists every task that needs to be completed for the project.

• Properties:
  • Title: Task name.
  • Description: What needs to be done.
  • Status: To Do, In Progress, Completed.
  • Priority: High, Medium, Low.
  • Deadline: When the task needs to be completed.
  • Assigned To: Team member responsible.
  • Related Idea: Link to the originating idea.
  • Related Decision: Link to any decision affecting the task.
  • Related Feature: Link to features this task supports.
• Views:
  • Kanban Board: For status tracking.
  • Calendar View: Deadline tracking.
  • Table View: Detailed overview.

4. Feature Database

Contains a detailed breakdown of the project's features.

• Properties:
  • Feature Name: Name of the feature.
  • Description: Detailed description.
  • Status: Planned, In Development, Completed.
  • Related Tasks: Tasks that contribute to this feature.
  • Importance: Critical, Important, Optional.
• Views:
  • Board View: Group by Status.
  • Table View: Detailed feature list.

5. BIP Posts Database

Manages all posts related to Building in Public.

• Properties:
  • Post Title: Title of the post.
  • Content: Main content of the post.
  • Platform: Where it will be/was published (e.g., Twitter, LinkedIn).
  • Status: Draft, Published.
  • Publish Date: When the post goes live.
  • Related Ideas: Ideas discussed in the post.