Make your own free website on Tripod.com

This is the Data Dictionary for Corvine Projects

List of relations
SchemaNameTypeOwnerExplanation
publicdeparttablepostgresA list of Departments, usually within a corporation
publicempltablepostgresList of employees and their details
publicentnumsequencepostgresA sequence to ensure each entry number is unique
publicentprojtablepostgresTo keep a list of projects against each entry
publicentriestablepostgresThe list of entries
publicfstablepostgresA list of entries found against the user who made the query. This way you can query once and produce several different reports based on the exact same records.
publicprojectstablepostgresA list of projects
publicprojnumsequencepostgresA sequence to ensure each project number is unique.
publicremindtablepostgresThis has not been used, but was intended for reminders. As a result no explanation will be given on the fields of this table.
publicsuperusertablepostgresThis stores the superuser(s). This table can only be edited through the console and comes pre populated with the user "citaduck"
publicuserprojtablepostgresWhich users belong to each project.
publicusrstablepostgresList of users.
(12 rows)

Now each table will be taken in turn.

Table "public.depart"
ColumnTypeModifiersExplanation
deptintegernot nullThis is an index number for each department.
departmenttextThis is the name of the department.
Indexes:
"depart_pkey" PRIMARY KEY, btree (dept)



Table "public.empl"
ColumnTypeModifiersExplanation
empcharacter(8)not nullUniquely identify each employee
empnametextThe name of the employee
emailtextEmployees email address
supercharacter(8)The employees supervisors emp number
lvelintegerWhat level this employee normally reports at. The lower the number the higher the ranking.
deptintegerThe department index number that the employee belongs to.
jobtitletextThe job title of the employee
Indexes:
"empl_pkey" PRIMARY KEY, btree (emp)



Table "public.entproj"
ColumnTypeModifiersExplanation
entprojintegernot nullThe entry number referring to the entrey field on the table entries
projectintegernot nullThe Project number referring to the proj field in the table projects
Indexes:
"entproj_pkey" PRIMARY KEY, btree (entproj, project)



Table "public.entries"
ColumnTypeModifiersExplanation
sdatedatedefault date(('now'::text)::timestamp without time zone)This is the start date of the activity.
edatedatedefault date(('now'::text)::timestamp without time zone)This is the end date of the activity
stimetime without time zonedefault "time"(('now'::text)::timestamp without time zone)The start time of the activity, script default to 8:30
etimetime without time zonedefault "time"(('now'::text)::timestamp without time zone)End Time of the activity, script default to 8:30
entreyintegernot null default nextval(('entnum'::text)::regclass)The number of the entry.
enturltextAn internet address for the entry. This appears as a link on the end date of the reports.
phototextA web address for a photo for the entry. This appears as a graphic on the reports.
wordstextA description of the activity that took place.
empcharacter(8)The employee number for this entry. This matches the emp field from the table empl
userscharacter(20)The user who made the entry. This refers to the users field from the table usrs.
deptintegerThe department for the entry. This refers to the dept field from the table depart
lvelintegerThe reporting level for the entry. If important use a low number.
amountdouble precisionAny monetary value associated with this entry.
remindintegerIf not zero this entry becomes a reminder which will be displayed on the Main Menu screen. The value here is the number of days beforehand before you are reminded.
Indexes:
"entries_pkey" PRIMARY KEY, btree (entrey)
"dept_entries_idx" btree (dept)
"edate_entries_idx" btree (edate)
"emp_entries_idx" btree (emp)
"enturl_entries_idx" btree (enturl)
"lvel_entries_idx" btree (lvel)
"photo_entries_idx" btree (photo)
"remind_entries_ndx" btree (remind)
"sdate_entries_idx" btree (sdate)
"users_entries_idx" btree (users)
"words_entries_idx" btree (words)



Table "public.fs"
ColumnTypeModifiersExplanation
userscharacter(20)not nullThe user who found the entry. This corresponds to the users field from the table entries and the users field from the table usrs.
entreyintegernot nullThe entry that has been found.
Indexes:
"fs_pkey" PRIMARY KEY, btree (users, entrey)



Table "public.projects"
ColumnTypeModifiersExplanation
projintegernot null default nextval(('projnum'::text)::regclass)Project Number
projnametextQuick Description of the project
projurltextAn internet address for a more complete description of the project
empcharacter(8)The main employee associated with the project. This corresponds t the emp field from the table empl
Indexes:
"projects_pkey" PRIMARY KEY, btree (proj)



Table "public.superuser"
ColumnTypeModifiersExplanation
userscharacter(20)not nullThis corresponds to the field users in the table usrs. If a user is listed in here then he is a super user.
Indexes:
"superuser_pkey" PRIMARY KEY, btree (users)



Table "public.userproj"
ColumnTypeModifiersExplanation
userscharacter(20)not nullWhich users are attached to a project. This field corresponds to the users field in the table usrs.
projintegernot nullThe project number. This corresponds to the proj field in the table projects.
Indexes:
"userproj_pkey" PRIMARY KEY, btree (users, proj)



Table "public.usrs"
ColumnTypeModifiersExplanation
userscharacter(20)not nullUniquely identify each user.
passwdcharacter(20)The password for the user.
usernametextUsername
empcharacter(8)If the user is an employee then the employees emp number.
Indexes:
"usrs_pkey" PRIMARY KEY, btree (users)

Return to Corvine Projects.