TEAMFLOW
Tables (8)
boards
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- background_color — VARCHAR(255)
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_user_id — INT — Foreign key → users.id — NOT NULL
boards_users
- id — INT — Primary key — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- board_id — INT — Foreign key → boards.id — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
cards
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_user_id — INT — Foreign key → users.id — NOT NULL
- column_id — INT — Foreign key → columns.id — NOT NULL
- color — VARCHAR(255)
- deadline — TIMESTAMP
- assigned_user_id — INT — Foreign key → users.id — NOT NULL
- order_num — INT
- from_column_id — INT
- to_column_id — INT
- status — ENUM
checklists
- id — INT — Primary key — NOT NULL
- item_name — VARCHAR(255)
- checked — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- card_id — INT — Foreign key → cards.id — NOT NULL
columns
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- order_num — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- board_id — INT — Foreign key → boards.id — NOT NULL
- status — ENUM
comments
- id — INT — Primary key — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — INT — Foreign key → users.id — NOT NULL
- card_id — INT — Foreign key → cards.id — NOT NULL
files
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- path — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- card_id — INT — Foreign key → cards.id — NOT NULL
users
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- password — VARCHAR(255)
- email — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP