Dumped on 2008-05-20

Index of database - gnuherds

public

a1_alerts
e1_entities
e2_entityfreesoftwareexperiences
e3_nationalities
e4_entityjoblicenseat
e5_entityrequirecertifications
j1_joboffers
js_joboffersearches
la_academiclevels
lb_byperiod
lc_certifications
le_employability
lf_fieldprofiles
lg_knowledgelevel
lh_skills
li_skills
lk_contracttype
ll_languages
lm_timeunits
ln_experiencelevel
ln_nationalities
lo_countries
lp_professionalprofiles
ls_spokenlevel
lt_skillsettypes
lu_currencies
lw_writtenlevel
lx_productprofiles
lz_applicationstates
q1_qualifications
qs_qualificationsearches
r0_qualifications2joboffersjoins
r11_joboffer2fieldprofiles
r12_joboffer2professionalprofiles
r13_joboffer2productprofiles
r14_joboffer2skills
r15_joboffer2languages
r16_joboffer2certifications
r17_joboffer2nationalities
r21_qualification2fieldprofiles
r22_qualification2professionalprofiles
r23_qualification2productprofiles
r24_qualification2skills
r25_qualification2languages
r26_qualification2certifications
r27_qualification2academic

Table: a1_alerts

a1_alerts Structure
F-Key	Name	Type	Description
e1_entities.e1_id	a1_e1_id	integer	PRIMARY KEY
	a1_newjoboffer	boolean	NOT NULL DEFAULT true

Index - Schema public

Table: e1_entities

e1_entities Structure
Name	Type	Description
e1_id	serial	PRIMARY KEY
e1_email	character varying(60)	DEFAULT NULL::character varying
e1_password	character varying(512)	DEFAULT NULL::character varying
e1_trusted	boolean	NOT NULL DEFAULT false
e1_revoked	boolean	NOT NULL DEFAULT false
e1_entitytype	character varying(23)	NOT NULL
e1_skillsadmin	boolean	NOT NULL DEFAULT false
e1_locale	character(5)	NOT NULL DEFAULT 'en_US'::bpchar
e1_wantemail	character varying(60)
e1_lostpasswordmagic	character varying(512)	DEFAULT NULL::character varying
e1_registermagic	character varying(512)	DEFAULT NULL::character varying
e1_wantemailmagic	character varying(512)	DEFAULT NULL::character varying
e1_lostpasswordmagicexpire	timestamp without time zone	NOT NULL DEFAULT '2008-05-20 11:29:39.579915'::timestamp without time zone
e1_registermagicexpire	timestamp without time zone	NOT NULL DEFAULT '2008-05-20 11:29:39.579915'::timestamp without time zone
e1_wantemailmagicexpire	timestamp without time zone	NOT NULL DEFAULT '2008-05-20 11:29:39.579915'::timestamp without time zone
e1_activateaccountemail	boolean	NOT NULL DEFAULT true
e1_registeraccountduplicatedemail	boolean	NOT NULL DEFAULT true
e1_lostpasswordemail	boolean	NOT NULL DEFAULT true
e1_street	character varying(80)
e1_suite	character varying(10)
e1_city	character varying(30)
e1_stateprovince	character varying(30)
e1_postalcode	character varying(15)
e1_lo_country	character(2)
e1_birthyear	character varying(4)
e1_ipphoneorvideo	character varying(255)
e1_landline	character varying(30)
e1_mobilephone	character varying(30)
e1_blog	character varying(255)
e1_website	character varying(255)
e1_media	text
ep_firstname	character varying(20)
ep_lastname	character varying(20)
ep_middlename	character varying(20)
e1_publickey	character varying(255)
e1_vote	boolean
e1_reevaluate	boolean
ep_motivation	text
ec_companyname	character varying(30)
eo_organizationname	character varying(30)

e1_entities Constraints
Name	Constraint
e1_entities_e1_email_check	CHECK (((e1_email)::text <> ''::text))
e1_entities_e1_entitytype_check	CHECK (((e1_entitytype)::text <> ''::text))
e1_entities_e1_locale_check	CHECK ((e1_locale <> ''::bpchar))
e1_entities_e1_lostpasswordmagic_check	CHECK (((e1_lostpasswordmagic)::text <> ''::text))
e1_entities_e1_password_check	CHECK (((e1_password)::text <> ''::text))
e1_entities_e1_registermagic_check	CHECK (((e1_registermagic)::text <> ''::text))
e1_entities_e1_wantemailmagic_check	CHECK (((e1_wantemailmagic)::text <> ''::text))

Tables referencing this one via Foreign Key Constraints:

a1_alerts

e2_entityfreesoftwareexperiences

e3_nationalities

e4_entityjoblicenseat

e5_entityrequirecertifications

j1_joboffers

js_joboffersearches

q1_qualifications

qs_qualificationsearches

r0_qualifications2joboffersjoins

Index - Schema public

Table: e2_entityfreesoftwareexperiences

e2_entityfreesoftwareexperiences Structure
F-Key	Name	Type	Description
	e2_id	serial	PRIMARY KEY
e1_entities.e1_id	e2_e1_id	integer	NOT NULL
	e2_project	character varying(30)
	e2_description	character varying(60)
	e2_uri	character varying(255)

Index - Schema public

Table: e3_nationalities

e3_nationalities Structure
F-Key	Name	Type	Description
e1_entities.e1_id	e3_e1_id	integer	NOT NULL
ln_nationalities.ln_lo_twoletter	e3_ln_id	character(2)	NOT NULL

Index - Schema public

Table: e4_entityjoblicenseat

e4_entityjoblicenseat Structure
F-Key	Name	Type	Description
e1_entities.e1_id	e4_e1_id	integer	NOT NULL
lo_countries.lo_twoletter	e4_lo_id	character(2)	NOT NULL

Index - Schema public

Table: e5_entityrequirecertifications

e5_entityrequirecertifications Structure
F-Key	Name	Type	Description
e1_entities.e1_id	e5_e1_id	integer	NOT NULL
lc_certifications.lc_name	e5_lc_name	character varying(30)	NOT NULL

Index - Schema public

Table: j1_joboffers

j1_joboffers Structure
F-Key	Name	Type	Description
	j1_id	serial	PRIMARY KEY
e1_entities.e1_id	j1_e1_id	integer	NOT NULL
	j1_completededition	boolean	DEFAULT false
	j1_employerjobofferreference	character varying(30)
	j1_offerdate	date
	j1_expirationdate	date
	j1_closed	boolean	DEFAULT false
	j1_hideemployer	boolean	DEFAULT false
	j1_allowpersonapplications	boolean	DEFAULT false
	j1_allowcompanyapplications	boolean	DEFAULT false
	j1_alloworganizationapplications	boolean	DEFAULT false
	j1_vacancies	character varying(3)
	j1_lk_contracttype	character varying(15)
	j1_wagerank	character varying(90)
	j1_commissionsincentives	character varying(255)
	j1_lu_currency	character(3)
	j1_lb_wagerankbyperiod	character varying(11)
	j1_estimatedeffort	character varying(90)
	j1_lm_timeunit	character varying(6)
	j1_deadline	date
	j1_laborday_schedule	character varying(255)
	j1_professionalexperiencesinceyear	character varying(4)
	j1_la_id	character varying(40)
	j1_freesoftwareprojects	character varying(60)
	j1_city	character varying(30)
	j1_stateprovince	character varying(30)
	j1_lo_country	character(2)
	j1_availabletotravel	boolean
	j1_lo_joblicenseat	character(2)
	j1_newjobofferalert	boolean	DEFAULT true

Tables referencing this one via Foreign Key Constraints:

r0_qualifications2joboffersjoins

r11_joboffer2fieldprofiles

r12_joboffer2professionalprofiles

r13_joboffer2productprofiles

r14_joboffer2skills

r15_joboffer2languages

r16_joboffer2certifications

r17_joboffer2nationalities

Index - Schema public

Table: js_joboffersearches

js_joboffersearches Structure
F-Key	Name	Type	Description
e1_entities.e1_id	js_e1_id	integer	NOT NULL
	js_sqlquery	text	NOT NULL
	js_description	text	NOT NULL

js_joboffersearches Constraints
Name	Constraint
js_joboffersearches_js_description_check	CHECK ((js_description <> ''::text))
js_joboffersearches_js_sqlquery_check	CHECK ((js_sqlquery <> ''::text))

Index - Schema public

Table: la_academiclevels

la_academiclevels Structure
F-Key	Name	Type	Description
	la_id	character varying(40)	PRIMARY KEY
	la_level	character(2)	UNIQUE NOT NULL

la_academiclevels Constraints
Name	Constraint
la_academiclevels_la_level_check	CHECK ((la_level <> ''::bpchar))

Index - Schema public

Table: lb_byperiod

lb_byperiod Structure
F-Key	Name	Type	Description
	lb_id	character varying(11)	PRIMARY KEY

lb_byperiod Constraints
Name	Constraint
lb_byperiod_lb_id_check	CHECK (((lb_id)::text <> ''::text))

Index - Schema public

Table: lc_certifications

lc_certifications Structure
Name	Type	Description
lc_name	character varying(30)	PRIMARY KEY
lc_apply2person	boolean	NOT NULL DEFAULT false
lc_apply2company	boolean	NOT NULL DEFAULT false
lc_apply2organization	boolean	NOT NULL DEFAULT false

lc_certifications Constraints
Name	Constraint
lc_certifications_lc_name_check	CHECK (((lc_name)::text <> ''::text))

Tables referencing this one via Foreign Key Constraints:

e5_entityrequirecertifications

r16_joboffer2certifications

r26_qualification2certifications

Index - Schema public

Table: le_employability

le_employability Structure
F-Key	Name	Type	Description
	le_id	character varying(22)	PRIMARY KEY

le_employability Constraints
Name	Constraint
le_employability_le_id_check	CHECK (((le_id)::text <> ''::text))

Index - Schema public

Table: lf_fieldprofiles

lf_fieldprofiles Structure
F-Key	Name	Type	Description
	lf_id	character varying(17)	PRIMARY KEY

lf_fieldprofiles Constraints
Name	Constraint
lf_fieldprofiles_lf_id_check	CHECK (((lf_id)::text <> ''::text))

Tables referencing this one via Foreign Key Constraints:

r11_joboffer2fieldprofiles

r21_qualification2fieldprofiles

Index - Schema public

Table: lg_knowledgelevel

lg_knowledgelevel Structure
F-Key	Name	Type	Description
	lg_id	character varying(9)	PRIMARY KEY
	lg_level	character(2)	NOT NULL

lg_knowledgelevel Constraints
Name	Constraint
lg_knowledgelevel_lg_id_check	CHECK (((lg_id)::text <> ''::text))
lg_knowledgelevel_lg_level_check	CHECK ((lg_level <> ''::bpchar))

Tables referencing this one via Foreign Key Constraints:

r14_joboffer2skills

r24_qualification2skills

Index - Schema public

Table: lh_skills

lh_skills Structure
F-Key	Name	Type	Description
	lh_id	character varying(23)	PRIMARY KEY

lh_skills Constraints
Name	Constraint
lh_skills_lh_id_check	CHECK (((lh_id)::text <> ''::text))

Tables referencing this one via Foreign Key Constraints:

li_skills

Index - Schema public

Table: li_skills

li_skills Structure
F-Key	Name	Type	Description
	li_id	character varying(153)	PRIMARY KEY
lh_skills.lh_id	li_lh_id	character varying(23)	NOT NULL
	li_lt_id	character varying(35)
	li_licensename	character varying(128)
	li_licenseurl	character varying(255)
	li_classificationrationale	text

li_skills Constraints
Name	Constraint
li_skills_li_id_check	CHECK (((li_id)::text <> ''::text))

Tables referencing this one via Foreign Key Constraints:

r14_joboffer2skills

r24_qualification2skills

Index - Schema public

Table: lk_contracttype

lk_contracttype Structure
F-Key	Name	Type	Description
	lk_id	character varying(15)	PRIMARY KEY

lk_contracttype Constraints
Name	Constraint
lk_contracttype_lk_id_check	CHECK (((lk_id)::text <> ''::text))

Index - Schema public

Table: ll_languages

ll_languages Structure
F-Key	Name	Type	Description
	ll_twoletter	character(2)	PRIMARY KEY
	ll_name	character varying(20)	UNIQUE NOT NULL

ll_languages Constraints
Name	Constraint
ll_languages_ll_name_check	CHECK (((ll_name)::text <> ''::text))
ll_languages_ll_twoletter_check	CHECK ((ll_twoletter <> ''::bpchar))

Tables referencing this one via Foreign Key Constraints:

r15_joboffer2languages

r25_qualification2languages

Index - Schema public

Table: lm_timeunits

lm_timeunits Structure
F-Key	Name	Type	Description
	lm_id	character varying(6)	PRIMARY KEY

lm_timeunits Constraints
Name	Constraint
lm_timeunits_lm_id_check	CHECK (((lm_id)::text <> ''::text))

Index - Schema public

Table: ln_experiencelevel

ln_experiencelevel Structure
F-Key	Name	Type	Description
	ln_id	character varying(18)	PRIMARY KEY
	ln_level	character(2)	NOT NULL

ln_experiencelevel Constraints
Name	Constraint
ln_experiencelevel_ln_id_check	CHECK (((ln_id)::text <> ''::text))
ln_experiencelevel_ln_level_check	CHECK ((ln_level <> ''::bpchar))

Tables referencing this one via Foreign Key Constraints:

r14_joboffer2skills

r24_qualification2skills

Index - Schema public

Table: ln_nationalities

ln_nationalities Structure
F-Key	Name	Type	Description
lo_countries.lo_twoletter	ln_lo_twoletter	character(2)	UNIQUE NOT NULL
	ln_name	character varying(80)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

e3_nationalities

r17_joboffer2nationalities

Index - Schema public

Table: lo_countries

lo_countries Structure
Name	Type	Description
lo_twoletter	character(2)	PRIMARY KEY
lo_threeletter	character(3)	UNIQUE NOT NULL
lo_threedigit	character(3)	UNIQUE NOT NULL
lo_name	character varying(80)	NOT NULL
lo_adjective	character varying(80)
lo_description	character varying(100)

lo_countries Constraints
Name	Constraint
lo_countries_lo_threedigit_check	CHECK ((lo_threedigit <> ''::bpchar))
lo_countries_lo_threeletter_check	CHECK ((lo_threeletter <> ''::bpchar))
lo_countries_lo_twoletter_check	CHECK ((lo_twoletter <> ''::bpchar))

Tables referencing this one via Foreign Key Constraints:

e4_entityjoblicenseat

ln_nationalities

Index - Schema public

Table: lp_professionalprofiles

lp_professionalprofiles Structure
F-Key	Name	Type	Description
	lp_id	character varying(26)	PRIMARY KEY

lp_professionalprofiles Constraints
Name	Constraint
lp_professionalprofiles_lp_id_check	CHECK (((lp_id)::text <> ''::text))

Tables referencing this one via Foreign Key Constraints:

r12_joboffer2professionalprofiles

r22_qualification2professionalprofiles

Index - Schema public

Table: ls_spokenlevel

ls_spokenlevel Structure
F-Key	Name	Type	Description
	ls_id	character varying(20)	PRIMARY KEY
	ls_level	character(2)	NOT NULL

ls_spokenlevel Constraints
Name	Constraint
ls_spokenlevel_ls_id_check	CHECK (((ls_id)::text <> ''::text))
ls_spokenlevel_ls_level_check	CHECK ((ls_level <> ''::bpchar))

Tables referencing this one via Foreign Key Constraints:

r15_joboffer2languages

r25_qualification2languages

Index - Schema public

Table: lt_skillsettypes

lt_skillsettypes Structure
F-Key	Name	Type	Description
	lt_order	character(2)	UNIQUE NOT NULL
	lt_id	character varying(35)	PRIMARY KEY

lt_skillsettypes Constraints
Name	Constraint
lt_skillsettypes_lt_id_check	CHECK (((lt_id)::text <> ''::text))
lt_skillsettypes_lt_order_check	CHECK ((lt_order <> ''::bpchar))

Index - Schema public

Table: lu_currencies

lu_currencies Structure
Name	Type	Description
lu_threeletter	character(3)	PRIMARY KEY
lu_name	character varying(80)	UNIQUE NOT NULL
lu_pluralname	character varying(80)	UNIQUE NOT NULL
lu_countrylist	character varying(240)	NOT NULL
lu_refvalue	numeric(14,7)

lu_currencies Constraints
Name	Constraint
lu_currencies_lu_countrylist_check	CHECK (((lu_countrylist)::text <> ''::text))
lu_currencies_lu_name_check	CHECK (((lu_name)::text <> ''::text))
lu_currencies_lu_pluralname_check	CHECK (((lu_pluralname)::text <> ''::text))
lu_currencies_lu_threeletter_check	CHECK ((lu_threeletter <> ''::bpchar))

Index - Schema public

Table: lw_writtenlevel

lw_writtenlevel Structure
F-Key	Name	Type	Description
	lw_id	character varying(20)	PRIMARY KEY
	lw_level	character(2)	NOT NULL

lw_writtenlevel Constraints
Name	Constraint
lw_writtenlevel_lw_id_check	CHECK (((lw_id)::text <> ''::text))
lw_writtenlevel_lw_level_check	CHECK ((lw_level <> ''::bpchar))

Tables referencing this one via Foreign Key Constraints:

r15_joboffer2languages

r25_qualification2languages

Index - Schema public

Table: lx_productprofiles

lx_productprofiles Structure
F-Key	Name	Type	Description
	lx_id	character varying(8)	PRIMARY KEY

lx_productprofiles Constraints
Name	Constraint
lx_productprofiles_lx_id_check	CHECK (((lx_id)::text <> ''::text))

Tables referencing this one via Foreign Key Constraints:

r13_joboffer2productprofiles

r23_qualification2productprofiles

Index - Schema public

Table: lz_applicationstates

lz_applicationstates Structure
F-Key	Name	Type	Description
	lz_id	character varying(10)	PRIMARY KEY

lz_applicationstates Constraints
Name	Constraint
lz_applicationstates_lz_id_check	CHECK (((lz_id)::text <> ''::text))

Tables referencing this one via Foreign Key Constraints:

r0_qualifications2joboffersjoins

Index - Schema public

Table: q1_qualifications

q1_qualifications Structure
F-Key	Name	Type	Description
e1_entities.e1_id	q1_e1_id	integer	PRIMARY KEY
	q1_completededition	boolean	DEFAULT false
	q1_professionalexperiencesinceyear	character varying(4)
	qp_lk_desiredcontracttype	character varying(15)
	qp_desiredwagerank	character varying(90)
	qp_lu_wagerankcurrency	character(3)
	qp_lb_wagerankbyperiod	character varying(11)
	qp_currentemployability	character varying(22)
	qp_availabletotravel	boolean
	qp_availabletochangeresidence	boolean

Tables referencing this one via Foreign Key Constraints:

r21_qualification2fieldprofiles

r22_qualification2professionalprofiles

r23_qualification2productprofiles

r24_qualification2skills

r25_qualification2languages

r26_qualification2certifications

r27_qualification2academic

Index - Schema public

Table: qs_qualificationsearches

qs_qualificationsearches Structure
F-Key	Name	Type	Description
e1_entities.e1_id	qs_e1_id	integer	NOT NULL
	qs_sqlquery	text	NOT NULL
	qs_description	text	NOT NULL

qs_qualificationsearches Constraints
Name	Constraint
qs_qualificationsearches_qs_description_check	CHECK ((qs_description <> ''::text))
qs_qualificationsearches_qs_sqlquery_check	CHECK ((qs_sqlquery <> ''::text))

Index - Schema public

Table: r0_qualifications2joboffersjoins

r0_qualifications2joboffersjoins Structure
F-Key	Name	Type	Description
j1_joboffers.j1_id	r0_j1_id	integer	PRIMARY KEY
lz_applicationstates.lz_id	r0_state	character varying(10)	NOT NULL
e1_entities.e1_id	r0_e1_id	integer	PRIMARY KEY

Index - Schema public

Table: r11_joboffer2fieldprofiles

r11_joboffer2fieldprofiles Structure
F-Key	Name	Type	Description
j1_joboffers.j1_id	r11_j1_id	integer	NOT NULL
lf_fieldprofiles.lf_id	r11_lf_id	character varying(17)	NOT NULL

Index - Schema public

Table: r12_joboffer2professionalprofiles

r12_joboffer2professionalprofiles Structure
F-Key	Name	Type	Description
j1_joboffers.j1_id	r12_j1_id	integer	NOT NULL
lp_professionalprofiles.lp_id	r12_lp_id	character varying(26)	NOT NULL

Index - Schema public

Table: r13_joboffer2productprofiles

r13_joboffer2productprofiles Structure
F-Key	Name	Type	Description
j1_joboffers.j1_id	r13_j1_id	integer	NOT NULL
lx_productprofiles.lx_id	r13_lx_id	character varying(8)	NOT NULL

Index - Schema public

Table: r14_joboffer2skills

r14_joboffer2skills Structure
F-Key	Name	Type	Description
j1_joboffers.j1_id	r14_j1_id	integer	NOT NULL
li_skills.li_id	r14_li_id	character varying(153)	NOT NULL
lg_knowledgelevel.lg_id	r14_lg_id	character varying(9)	NOT NULL
ln_experiencelevel.ln_id	r14_ln_id	character varying(18)	NOT NULL

Index - Schema public

Table: r15_joboffer2languages

r15_joboffer2languages Structure
F-Key	Name	Type	Description
j1_joboffers.j1_id	r15_j1_id	integer	NOT NULL
ll_languages.ll_name	r15_ll_name	character varying(20)	NOT NULL
ls_spokenlevel.ls_id	r15_ls_id	character varying(20)	NOT NULL
lw_writtenlevel.lw_id	r15_lw_id	character varying(20)	NOT NULL

Index - Schema public

Table: r16_joboffer2certifications

r16_joboffer2certifications Structure
F-Key	Name	Type	Description
j1_joboffers.j1_id	r16_j1_id	integer	NOT NULL
lc_certifications.lc_name	r16_lc_name	character varying(30)	NOT NULL

Index - Schema public

Table: r17_joboffer2nationalities

r17_joboffer2nationalities Structure
F-Key	Name	Type	Description
j1_joboffers.j1_id	r17_j1_id	integer	NOT NULL
ln_nationalities.ln_lo_twoletter	r17_ln_id	character(2)	NOT NULL

Index - Schema public

Table: r21_qualification2fieldprofiles

r21_qualification2fieldprofiles Structure
F-Key	Name	Type	Description
q1_qualifications.q1_e1_id	r21_q1_e1_id	integer	NOT NULL
lf_fieldprofiles.lf_id	r21_lf_id	character varying(17)	NOT NULL

Index - Schema public

Table: r22_qualification2professionalprofiles

r22_qualification2professionalprofiles Structure
F-Key	Name	Type	Description
q1_qualifications.q1_e1_id	r22_q1_e1_id	integer	NOT NULL
lp_professionalprofiles.lp_id	r22_lp_id	character varying(26)	NOT NULL

Index - Schema public

Table: r23_qualification2productprofiles

r23_qualification2productprofiles Structure
F-Key	Name	Type	Description
q1_qualifications.q1_e1_id	r23_q1_e1_id	integer	NOT NULL
lx_productprofiles.lx_id	r23_lx_id	character varying(8)	NOT NULL

Index - Schema public

Table: r24_qualification2skills

r24_qualification2skills Structure
F-Key	Name	Type	Description
q1_qualifications.q1_e1_id	r24_q1_e1_id	integer	NOT NULL
li_skills.li_id	r24_li_id	character varying(153)	NOT NULL
lg_knowledgelevel.lg_id	r24_lg_id	character varying(9)	NOT NULL
ln_experiencelevel.ln_id	r24_ln_id	character varying(18)	NOT NULL

Index - Schema public

Table: r25_qualification2languages

r25_qualification2languages Structure
F-Key	Name	Type	Description
q1_qualifications.q1_e1_id	r25_q1_e1_id	integer	NOT NULL
ll_languages.ll_name	r25_ll_name	character varying(20)	NOT NULL
ls_spokenlevel.ls_id	r25_ls_id	character varying(20)	NOT NULL
lw_writtenlevel.lw_id	r25_lw_id	character varying(20)	NOT NULL

Index - Schema public

Table: r26_qualification2certifications

r26_qualification2certifications Structure
F-Key	Name	Type	Description
q1_qualifications.q1_e1_id	r26_q1_e1_id	integer	NOT NULL
lc_certifications.lc_name	r26_lc_name	character varying(30)	NOT NULL
	r26_state	character varying(15)	NOT NULL DEFAULT 'Pending'::character varying

Index - Schema public

Table: r27_qualification2academic

r27_qualification2academic Structure
F-Key	Name	Type	Description
q1_qualifications.q1_e1_id	r27_q1_e1_id	integer	NOT NULL
	r27_degree	character varying(80)
	r27_la_id	character varying(40)
	r27_degreegranted	character varying(3)
	r27_startdate	date
	r27_finishdate	date
	r27_institution	character varying(80)
	r27_institutionuri	character varying(255)
	r27_shortcomment	character varying(80)

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict