kanban
Tables (33)
attachments
- id — int(10) — NOT NULL
- name — varchar(191) — NOT NULL
- file_path — varchar(191) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
boards
- id — int(10) — NOT NULL
- boardId — int(11) — NOT NULL
- totalTaskFilter — int(11) — NOT NULL
- tasksDoneFilter — int(11) — NOT NULL
- slug — varchar(191) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
charts
- id — int(10) — NOT NULL
- boardId — int(11) — NOT NULL
- sprintname — varchar(191) — NOT NULL
- slug — varchar(191) — NOT NULL
- storyPointsTotal — double(5,1) — NOT NULL
- tasksTotal — double(5,1) — NOT NULL
- tasksDone — double(5,1) — NOT NULL
- storyPointsDone — double(5,1) — NOT NULL
- startDate — date — NOT NULL
- endDate — date — NOT NULL
- sprintDay — date — NOT NULL
- created_at — timestamp
- updated_at — timestamp
coding_standards
- id — bigint(20) — Primary key — NOT NULL
- codestand_name — varchar(255) — NOT NULL
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
defect_features
- id — bigint(20) — NOT NULL
- title — varchar(191) — NOT NULL
- desc — varchar(191) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
failed_jobs
- id — bigint(20) — Primary key — NOT NULL
- uuid — varchar(255) — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
feedback
- id — bigint(20) — Primary key — NOT NULL
- feedback_type — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
mappings
- id — bigint(20) — NOT NULL
- ustory_id — int(11) — NOT NULL
- type_NFR — int(11) — NOT NULL
- id_NFR — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
migrations
- id — int(10) — Primary key — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int(11) — NOT NULL
oauth_access_tokens
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → users.id — NOT NULL
- client_id — bigint(20) — NOT NULL
- name — varchar(191)
- scopes — text
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- expires_at — datetime
oauth_auth_codes
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → users.id — NOT NULL
- client_id — bigint(20) — NOT NULL
- scopes — text
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
oauth_clients
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → users.id — NOT NULL
- name — varchar(191) — NOT NULL
- secret — varchar(100)
- provider — varchar(191)
- redirect — text — NOT NULL
- personal_access_client — tinyint(1) — NOT NULL
- password_client — tinyint(1) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_personal_access_clients
- id — bigint(20) — NOT NULL
- client_id — bigint(20) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_refresh_tokens
- id — varchar(100) — NOT NULL
- access_token_id — varchar(100) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
password_reset_tokens
- email — varchar(255) — Primary key — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
password_resets
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
performance_features
- id — bigint(20) — Primary key — NOT NULL
- perfeature_name — varchar(255) — NOT NULL
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
personal_access_tokens
- id — bigint(20) — Primary key — NOT NULL
- tokenable_type — varchar(255) — NOT NULL
- tokenable_id — bigint(20) — NOT NULL
- name — varchar(255) — NOT NULL
- token — varchar(64) — NOT NULL
- abilities — text
- last_used_at — timestamp
- expires_at — timestamp
- created_at — timestamp
- updated_at — timestamp
priorities
- prio_id — bigint(20) — NOT NULL
- prio_name — varchar(191) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
product_features
- id — bigint(20) — NOT NULL
- profeature_name — varchar(191) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
project_sessions
- id — bigint(20) — Primary key — NOT NULL
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
projects
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → users.id — NOT NULL
- proj_name — varchar(255) — NOT NULL
- proj_desc — varchar(255) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- created_at — timestamp
- updated_at — timestamp
roles
- id — bigint(20) — Primary key — NOT NULL
- role_name — varchar(255) — NOT NULL
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
security_features
- id — bigint(20) — Primary key — NOT NULL
- secfeature_name — varchar(255) — NOT NULL
- secfeature_desc — varchar(255) — NOT NULL
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
sessions
- id — varchar(255) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → users.id — NOT NULL
- ip_address — varchar(45)
- user_agent — text
- payload — longtext — NOT NULL
- last_activity — int(11) — NOT NULL
sprint
- sprint_id — bigint(20) — NOT NULL
- sprint_name — varchar(191) — NOT NULL
- sprint_desc — varchar(191) — NOT NULL
- start_sprint — date — NOT NULL
- end_sprint — date — NOT NULL
- proj_name — varchar(191) — NOT NULL
- users_name — varchar(191)
- created_at — timestamp
- updated_at — timestamp
sprints
- id — bigint(20) — Primary key — NOT NULL
- sprint_name — varchar(255) — NOT NULL
- sprint_desc — varchar(255) — NOT NULL
- start_sprint — date — NOT NULL
- end_sprint — date — NOT NULL
- proj_name — varchar(255)
- users_name — varchar(255) — NOT NULL
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
statuses
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- slug — varchar(255) — NOT NULL
- order — smallint(6) — NOT NULL
- user_id — int(10) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
tasks
- id — bigint(20) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- start_date — date
- end_date — date
- order — int(11)
- user_id — int(11)
- status_id — int(11)
- u_id — varchar(255)
- sprint_id — varchar(255)
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
teammappings
- teammapping_id — int(10) — NOT NULL
- username — varchar(191) — NOT NULL
- role_name — varchar(191) — NOT NULL
- team_name — varchar(191) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
teams
- id — bigint(20) — Primary key — NOT NULL
- team_name — varchar(255) — NOT NULL
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
user_stories
- id — bigint(20) — Primary key — NOT NULL
- user_story — varchar(255) — NOT NULL
- desc_story — varchar(255) — NOT NULL
- due_day — varchar(255) — NOT NULL
- prio_story — varchar(255)
- title — varchar(255)
- sprint_id — varchar(255)
- perfeature_id — varchar(255)
- secfeature_id — varchar(255)
- project_id — int(11)
- created_at — timestamp
- updated_at — timestamp
users
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- email_verified_at — timestamp
- password — varchar(255) — NOT NULL
- two_factor_secret — text
- two_factor_recovery_codes — text
- two_factor_confirmed_at — timestamp
- remember_token — varchar(100)
- current_team_id — bigint(20)
- profile_photo_path — varchar(2048)
- created_at — timestamp
- updated_at — timestamp
- facebook_id — varchar(255)
- twitter_id — varchar(255)