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