taskify

Tables (6)

Post (Untitled2)

  • post_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.user_id — NOT NULL
  • title (Field) — varchar(50)
  • content (Field2) — varchar(255)
  • create_at (Field3) — timestamp
  • update_at (Field4) — timestamp
  • Field5

columns (column)

  • column_id (Key) — BIGINT — Primary key — NOT NULL
  • column_name (Field) — TEXT

history

  • history_id (Key) — BIGINT — Primary key — NOT NULL
  • history_author (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • history_type (Field2) — TEXT
  • history_data (Field3) — JSON
  • history_post (Field4) — TEXT
  • history_create_time (Field) — DATE

task

  • task_id (Key) — BIGINT — Primary key — NOT NULL
  • column_id (Key2) — BIGINT — Foreign key → columns.column_id — NOT NULL
  • task_author (Key3) — BIGINT — Foreign key → user.user_id — NOT NULL
  • task_title (Field) — TEXT
  • task_post (Field2) — TEXT
  • task_create_time (Field4) — DATE

user

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • username (Field) — VARCHAR
  • password (Field2) — VARCHAR

user (Untitled)

  • user_id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(50)
  • password (Field2) — varchar(64)
  • nickname (Field3) — varchar(20)
  • create_at (Field4) — timestamp