members.md

members

Description

Table Definition

CREATE TABLE `members` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `organization_id` bigint DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `is_administrator` tinyint(1) NOT NULL,
  `last_login` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_MEMBER_ON_ORGANIZATIONS` (`organization_id`),
  CONSTRAINT `FK_MEMBER_ON_ORGANIZATIONS` 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	games leagues
organization_id	bigint		true			organizations
email	varchar(255)		false
password	varchar(255)		false
is_administrator	tinyint(1)		false
last_login	datetime		true

Constraints

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

Indexes

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

Relations

---

Generated by tbls