app_prog_path

-1 rows


Description

Stores details of the program paths

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_prog_path_id_seq'::regclass)
app_certif.expirypathid Defined in XML R
app_certif_completion.progpathid Defined in XML R
app_certif_completion_history.progpathid Defined in XML R
app_prog_courseset.progpathid Defined in XML R
programid int8 19 0
app_prog.id Defined in XML R
sortorder int8 19 1
name varchar 1333 √ ''::character varying
description text 2147483647 √ null
descriptionformat int2 5 √ null
nextpathid int8 19 √ null
activeperiod varchar 20 √ null
minimumactiveperiod varchar 20 √ null
windowperiod varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
app_progpath_id_pk Primary key Asc id
app_progpath_pro_ix Performance Asc programid

Relationships

Close relationships within degrees of separation