units.md

units

Description

Table Definition

CREATE TABLE `units` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `organization_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_units_on_organization` (`organization_id`),
  CONSTRAINT `fk_units_on_organization` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	bigint		false	auto_increment	teams
name	varchar(255)		false
organization_id	bigint		false			organizations

Constraints

Name	Type	Definition
fk_units_on_organization	FOREIGN KEY	FOREIGN KEY (organization_id) REFERENCES organizations (id)
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
fk_units_on_organization	KEY fk_units_on_organization (organization_id) USING BTREE
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

---

Generated by tbls