naveBoostCamp-taskify
Tables (4)
Card (card)
- id — int — Primary key — NOT NULL — auto Increase
- title — varchar(20)
- content — varchar(255)
- created_at — timestamp
- updated_at — timestamp
- column_id — int — Foreign key → Column.id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
Column (column)
- id — int — Primary key — NOT NULL
- title — varchar(20)
History (history)
- id — int — Primary key — NOT NULL
- action — varchar(10)
- title — varchar(20)
- prev_column — varchar(20)
- current_column — varchar(20)
- created_at — timestamp
- user_id — int — Foreign key → User.id — NOT NULL
User (user)
- id — int — Primary key — NOT NULL
- name — varchar(10)
- profile_img — varchar(255)