Table: Board

Overview

Board of the company

|Field|Type|Null|Key|Default|Comment| |-----|----|-|:-:|-------|-------| |lID|int|||not set|Primary Key| |strPosition|varchar(50)|||not set|| |lEmployeeID|int|||null|FK to Employee table|

References to other Tables

|Column|Reference to|UPDATE|DELETE| |------|------------|------|------| |lEmployeeID|Employee . lID|CASCADE|SET NULL|

Table Create Statement:

CREATE TABLE `Board` (
  `lID` int NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `strPosition` varchar(50) COLLATE utf8mb3_german2_ci NOT NULL,
  `lEmployeeID` int DEFAULT NULL COMMENT 'FK to Employee table',
  PRIMARY KEY (`lID`),
  KEY `lEmployeeID` (`lEmployeeID`),
  CONSTRAINT `Board_ibfk_1` FOREIGN KEY (`lEmployeeID`) REFERENCES `Employee` (`lID`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_german2_ci COMMENT='Board of the company'