pears.LeaveClasses

Contains list of types of leave (eg paid holiday - maternity leave etc) recorded in WeEmployLeave table.

• LeaveClass

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."LeaveClasses"
-- Table comment: Contains list of types of leave (eg paid holiday - maternity leave etc) recorded in WeEmployLeave table.
-- Statement count: 4
 
CREATE TABLE "pears"."LeaveClasses" (
    "LeaveClass"                     CHAR(6) NOT NULL
   ,"Description"                    CHAR(30) NOT NULL
   ,PRIMARY KEY ("LeaveClass" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."LeaveClasses"."LeaveClass" IS 
	'Leave Class code'
GO
 
 
COMMENT ON COLUMN "pears"."LeaveClasses"."Description" IS 
	'Leave Class Description'
GO
 
 
COMMENT ON TABLE "pears"."LeaveClasses" IS 
	'Contains list of types of leave (eg paid holiday - maternity leave etc) recorded in WeEmployLeave table.'
GO