murphy

Tables (10)

CATEGORIES

  • id — CHAR(36) — Primary key — NOT NULL — UUID
  • issue_id — CHAR(36) — Foreign key → ISSUES.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • x_position — FLOAT — NOT NULL — Canvas X
  • y_position — FLOAT — NOT NULL — Canvas Y
  • width — FLOAT — NOT NULL
  • height — FLOAT — NOT NULL

COMMENT

  • id — CHAR(36) — Primary key — NOT NULL — dea_id CHAR(36) NOT NUL
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • id (id2) — CHAR(36) — Foreign key → IDEAS.id — NOT NULL — UUID
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • Key — Foreign key — NOT NULL

IDEAS

  • id — CHAR(36) — Primary key — NOT NULL — UUID
  • issue_id — CHAR(36) — Foreign key → ISSUES.id — NOT NULL
  • category_id — CHAR(36) — Foreign key → CATEGORIES.id — Nullable Before categorization
  • author_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • content — TEXT — NOT NULL
  • is_edited — BOOLEAN
  • x_position — FLOAT — NOT NULL — Post-it X
  • y_position — FLOAT — NOT NULL — Post-it Y
  • created_at — DATETIME
  • updated_at — DATETIME

ISSUES

  • id — CHAR(36) — Primary key — NOT NULL — UUID
  • topic_id — CHAR(36) — Foreign key → TOPICS.id — Nullable for Instant Issue
  • creator_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — OPEN, VOTING, CLOSED
  • created_at — DATETIME
  • closed_at — DATETIME

ISSUE_LINKS

  • source_issue_id — CHAR(36) — Foreign key → ISSUES.id — NOT NULL
  • target_issue_id — CHAR(36) — Foreign key → ISSUES.id — NOT NULL
  • created_at — DATETIME

PROJECTS

  • id — CHAR(36) — Primary key — NOT NULL — UUID
  • owner_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — DATETIME

PROJECT_MEMBERS

  • project_id — CHAR(36) — Foreign key → PROJECTS.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • role — VARCHAR(20) — ADMIN, MEMBER
  • joined_at — DATETIME

TOPICS

  • id — CHAR(36) — Primary key — NOT NULL — UUID
  • project_id — CHAR(36) — Foreign key → PROJECTS.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME

USERS

  • id — CHAR(36) — Primary key — NOT NULL — UUID
  • name (Field) — VARCHAR(30) — NOT NULL
  • email — VARCHAR(255) — NOT NULL — Nullable for guests
  • nickname — VARCHAR(100) — Real or Random Anonymous
  • provider — VARCHAR(50) — OAuth provider
  • created_at — DATETIME
  • Field2 — DATETIME

VOTES

  • id — CHAR(36) — Primary key — NOT NULL — UUID
  • idea_id — CHAR(36) — Foreign key → IDEAS.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • vote_type — VARCHAR(20) — NOT NULL — AGREE, DISAGREE
  • created_at — DATETIME
  • Key — Foreign key — NOT NULL