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