taskify
Tables (4)
cards
- card_id (PK) — INT — Primary key — NOT NULL
- card_title (Field) — VARCHAR(255)
- card_body (Field2) — TEXT
- card_status (Field3) — VARCHAR(255)
- created_date (Field4) — DATETIME
- updated_date (Field5) — DATETIME
- column_id (PK2) — INT — Foreign key → columns.column_id — NOT NULL
- user_id (PK3) — INT — Foreign key → users.user_id — NOT NULL
columns
- column_id (PK) — INT — Primary key — NOT NULL
- column__title (Field) — VARCHAR(255)
- column_order (Field2) — INT
- created_date (Field3) — DATETIME
- updated_date (Field4) — DATETIME
- user_id (PK2) — INT — Foreign key → users.user_id — NOT NULL
history (historys)
- history_id (PK) — INT — Primary key — NOT NULL
- action (Field) — VARCHAR(255)
- action_time (Field2) — DATETIME
- history_content (Field3) — TEXT
- user_id (PK2) — INT — Foreign key → users.user_id — NOT NULL
users
- user_id (PK) — INT — Primary key — NOT NULL
- username (Field) — VARCHAR(255)
- created_date (Field2) — DATETIME