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