コンテンツにスキップ

m_organization

概要

組織マスタ

テーブル定義 
CREATE TABLE `m_organization` (
  `org_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '組織ID',
  `company_id` bigint unsigned NOT NULL COMMENT '会社ID',
  `parent_org_id` bigint unsigned DEFAULT NULL COMMENT '上位組織ID',
  `org_code` varchar(20) COLLATE utf8mb4_ja_0900_as_cs_ks NOT NULL COMMENT '組織コード',
  `org_name` varchar(100) COLLATE utf8mb4_ja_0900_as_cs_ks NOT NULL COMMENT '組織名称',
  `valid_from` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '有効開始日時',
  `valid_to` datetime NOT NULL DEFAULT '9999-12-31 23:59:59' COMMENT '有効終了日時',
  `deleted_at` datetime DEFAULT NULL COMMENT '論理削除日時',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '登録日時',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日時',
  `version` int unsigned NOT NULL DEFAULT '1' COMMENT 'バージョン',
  PRIMARY KEY (`org_id`),
  KEY `company_id` (`company_id`),
  KEY `parent_org_id` (`parent_org_id`),
  CONSTRAINT `m_organization_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `m_company` (`company_id`),
  CONSTRAINT `m_organization_ibfk_2` FOREIGN KEY (`parent_org_id`) REFERENCES `m_organization` (`org_id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_ja_0900_as_cs_ks COMMENT='組織マスタ'

カラム一覧

# 名前 タイプ デフォルト値 Nullable Extra Definition 子テーブル 親テーブル コメント
1 org_id bigint unsigned false auto_increment m_employee m_organization 組織ID
2 company_id bigint unsigned false m_company 会社ID
3 parent_org_id bigint unsigned true m_organization 上位組織ID
4 org_code varchar(20) false 組織コード
5 org_name varchar(100) false 組織名称
6 valid_from datetime CURRENT_TIMESTAMP false DEFAULT_GENERATED 有効開始日時
7 valid_to datetime 9999-12-31 23:59:59 false 有効終了日時
8 deleted_at datetime true 論理削除日時
9 created_at datetime CURRENT_TIMESTAMP false DEFAULT_GENERATED 登録日時
10 updated_at datetime CURRENT_TIMESTAMP false DEFAULT_GENERATED on update CURRENT_TIMESTAMP 更新日時
11 version int unsigned 1 false バージョン

制約一覧

# 名前 タイプ 定義
1 m_organization_ibfk_1 FOREIGN KEY FOREIGN KEY (company_id) REFERENCES m_company (company_id)
2 m_organization_ibfk_2 FOREIGN KEY FOREIGN KEY (parent_org_id) REFERENCES m_organization (org_id)
3 PRIMARY PRIMARY KEY PRIMARY KEY (org_id)

INDEX一覧

# 名前 定義
1 company_id KEY company_id (company_id) USING BTREE
2 parent_org_id KEY parent_org_id (parent_org_id) USING BTREE
3 PRIMARY PRIMARY KEY (org_id) USING BTREE

ER図

er

Generated by tbls