SQL

CREATE TABLE `team_unit`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `org_id` INTEGER NULL,
  `team_id` INTEGER NULL,
  `type` INTEGER NULL,
  `access_mode` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
org_id INTEGER ✓ Rename | Drop
team_id INTEGER ✓ Rename | Drop
type INTEGER ✓ Rename | Drop
access_mode INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_team_unit_org_id org_id SQL 
CREATE INDEX `IDX_team_unit_org_id`
ON `team_unit` (`org_id`)
Drop
UQE_team_unit_s
  • team_id
  • type
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_team_unit_s`
ON `team_unit` (`team_id`,`type`)
Drop