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)