scv
Tables (7)
boardcolumns
- id — bigint — Primary key — NOT NULL
- column_name — varchar(255) — NOT NULL
- position — bigint — NOT NULL
- board_id — bigint — NOT NULL
boardmembers
- board_id — bigint — Primary key — NOT NULL
- user_id — bigint — Primary key — NOT NULL
boards
- id — bigint — Primary key — NOT NULL
- color — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- board_name — varchar(255) — NOT NULL
- state — bit — NOT NULL
- owner_id — bigint — NOT NULL
cardmembers
- id — bigint — Primary key — NOT NULL
- card_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
cards
- id — bigint — Primary key — NOT NULL
- color — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- end_date — varchar(255) — NOT NULL
- start_date — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- column_id — bigint — NOT NULL
- owner_id — bigint — NOT NULL
comments
- id — bigint — Primary key — NOT NULL
- comment — varchar(255) — NOT NULL — archar(255) nul
- card_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- company — varchar(255) — NOT NULL
- department — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL