Table: Section

Overview

Company sections

|Field|Type|Null|Key|Default|Comment| |-----|----|-|:-:|-------|-------| |lID|int|||not set|Primary Key| |strName|varchar(50)|||empty|| |strDescription|text|||not set||

Tables referencing this Table

|Column|Referenced by|UPDATE|DELETE| |------|-------------|------|------| |lID|Employee . lSectionID|RESTRICT|RESTRICT|

Table Create Statement:

CREATE TABLE `Section` (
  `lID` int NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `strName` varchar(50) COLLATE utf8mb3_german2_ci NOT NULL DEFAULT '',
  `strDescription` text COLLATE utf8mb3_german2_ci NOT NULL,
  PRIMARY KEY (`lID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_german2_ci COMMENT='Company sections'