public.presencedetails

public.presencedetails

Description

Persence Code Lookup Data

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	varchar(50)		false			Primary Key
systempresence	varchar(255)		true			Presence System Presence Name
orgpresence	varchar(255)		true			Presence Organisation Presence Name
deactivated	bit(1)		true			Presence Active ?
type	varchar(50)		true			Presence Type
divisionid	varchar(50)		true			Division ID
updated	timestamp without time zone		true			Date Row Updated (UTC)

Constraints

Name	Type	Definition
presencedetails_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
presencedetails_pkey	CREATE UNIQUE INDEX presencedetails_pkey ON public.presencedetails USING btree (id)