Field Structure for Database Tables


1. Structure for Table NAME

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 ALT_NAME

Character

200

Aliases of Commentator

3 BIRTHCITY

Character

30

Birthplace

4 BIRTHREGIO

Character

30

Region of birthplace

5 BIRTHCOUNT

Character

30

Country of birthplace

6 BIAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

7 BIDTENUMB1

Numeric

4

Exact year of birth or terminus post quem

8 BIAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

9 BIDTENUMB2

Numeric

4

Terminus ante quo for birth date

10 FLAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

11 FLDTENUMB1

Numeric

4

Exact flourishing date or terminus post quem

12 FLAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

13 FLDTENUMB2

Numeric

4

Terminus ante quo for flourishing date

14 DEATHPLACE

Character

30

Place of death

15 DEAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

16DEDTENUMB1

Numeric

4

Exact death date or terminus post quem

17 DEAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

18 DEDTENUMB

Numeric

4

Terminus ante quo for death date

19 CLASS_LEV

Character

67

Social class

20 CLASS_COMM

Character

67

Comment field for social class

21 MISC_COMME

Character

200

Comments field for commentator table

22 FAM_PROF

Character

30

Profession of the commentator's family

 

2. Structure for Lookup Table ALIAS

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 ALT_NAME

Character

67

Aliases of Commentator

 

3. Structure for Table SENTDBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 INTEL_PROD

Character

67

Category of intellectual product

3 SENT_DOCS

Character

67

Intellectual product name

4 SENT_LOC

Character

67

Location of production

5 SENT_COUNT

Character

30

Country of production

6 SEAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

7 SEDTENUMB1

Numeric

4

Exact date of production or terminus post quem

8 SEAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

9 SEDTENUMB2

Numeric

4

Terminus ante quo of production

10 SENT_COMME

Character

67

Comment field for Intellectual Products table

11 INCIPIT

Character

67

Incipit of text

 

4. Structure for Table LECTDBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 LECTURE

Character

67

Text upon which lectures given

3 FACULTY

Character

67

Faculty in which lectures given

4 LECT_LOC

Character

67

Location of lectures

5 LECT_COUNT

Character

30

Country of location

6 LEAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

7 LEDTENUMB1

Numeric

4

Exact date of lecture or terminus post quem

8 LEAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

9 LEDTENUMB2

Numeric

4

Terminus ante quo of lecture

10 LECT_COMME

Character

67

Comment field for lectures table

 

5. Structure for Table EDUDBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 EDU_LEVEL

Character

67

Educational level attained

3 EDU_LOC

Character

67

Location of educational attainment

4 EDU_FACULT

Character

30

Faculty/School in which educational attainment attained

5 EDU_COUNTR

Character

30

Country of location

6 EDAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

7 EDDTENUMB1

Numeric

4

Exact date of attainment or terminus post quem

8 EDAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

9 EDDTENUMB2

Numeric

4

Terminus ante quo for date of attainment

10 EDAPRXDTE3

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

11 EDDTENUMB3

Numeric

4

Exact terminal date for educational level or terminus post quem

12 EDAPRXDTE4

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

13 EDDTENUMB4

Numeric

4

Terminus ante quo for terminal date of attainment

14 EDU_YEARS

Numeric

2

Number of years in this educational level

15 EDU_COMMEN

Character

67

Comment field for educational table

 

6. Structure for Table ECCDBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 ECC_RANK

Character

30

Ecclesiastical rank

3 ECC_LOC

Character

67

Location of ecclesiastical position

4 ECC_COUNTR

Character

30

Country of ecclesiastical position

5 ECAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

6 ECDTENUMB1

Numeric

4

Exact date of attaining ecclesiastic rank or terminus post quem

7 ECAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

8 ECDTENUMB2

Numeric

4

Terminus ante quo for attainment of ecclesiastical rank

9 ECAPRXDTE3

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

10 ECDTENUMB3

Numeric

4

Exact terminal date ecclesiastical rank or terminus post quem

11 ECAPRXDTE4

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

12 ECDTENUMB4

Numeric

4

Terminus ante quo for terminal date of ecclesiastical rank

13 ECC_COMMEN

Character

67

Comment field for ecclesiastical table

 

7. Structure for Table ORDDBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 OR_LEVEL

Character

30

Religious order

3 OR_LOC

Character

67

Location of entrance into order

4 OR_COUNTRY

Character

30

Country of location

5 ORAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

6 ORDTENUMB1

Numeric

4

Exact date of entrance into Order or terminus post quem

7 ORAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

8 ORDTENUMB2

Numeric

4

Terminus ante quo of entrance into Order

9 OR_COMMENT

Character

67

Comment field for Orders table

 

8. Structure for Table PRODBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 PRO_CAREER

Character

67

Professional position

3 PRO_LOC

Character

67

Location of attaining professional position

4 PRO_COUNTR

Character

30

Country of location

5 PRAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

6 PRDTENUMB1

Numeric

4

Exact date of attaining professional position or terminus post quem

7 PRAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

8 PRDTENUMB2

Numeric

4

Terminus ante quo for attainment of professional position

9 PRAPRXDTE3

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

10 PRDTENUMB3

Numeric

4

Exact terminal date of professional position or terminus post quem

11 PRAPRXDTE4

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

12 PRDTENUMB4

Numeric

4

Terminus ante quo for terminal date of professional position

13 PRO_COMMEN

Character

67

Comment field for professional table

 

9. Structure for Table RELADBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 INTEL_RELA

Character

67

Category of relationship between commentator and other individual

3 RELA_NAME

Character

67

Name of related individual

4 RELA_NAME_BIRTHCITY

Character

50

Birth city of Related Individual

5 RELA_NAME_BIRTHCOUNTR

Character

50

Birth country of Related Individual

6 RELA_LOC

Character

67

Location of relationship

7 RELA_COUNT

Character

30

Country of location

8 REAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

9 REDTENUMB1

Numeric

4

Exact date of intellectual relationship or terminus post quem

10 REAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

11 REDTENUMB2

Numeric

4

Terminus ante quo of intellectual relationship

12 RELA_COMME

Character

67

Comment field for Orders table

 

10. Structure for Table VOYDBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 VOY_PURPOS

Character

67

Purpose of geographical movement

3 VOY_LOC

Character

67

Destination

4 VOY_COUNTR

Character

30

Country of destination

5 VOY_YEARS

Numeric

2

Duration of sojourn

6 VOAPRXDTE1

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

7 VODTENUMB1

Numeric

4

Exact date of departure or terminus post quem

8 VOAPRXDTE2

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

9 VODTENUMB2

Numeric

4

Terminus ante quo of departure date

10 VOAPRXDTE3

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

11 VODTENUMB3

Numeric

4

Exact date of arrival at destination or terminus post quem

12 VOAPRXDTE4

Character

1

Accepts characters 'a' (ante), 'p' (post), and 'c' (circa)

13 VODTENUMB4

Numeric

4

Terminus ante quo of arrival date

14 VOY_COMMEN

Character

67

Comment field for Voyages table

15 DEP_LOC

Character

67

Departure point of voyage

16 DEP_COUNTR

Character

30

Country of departure

 

11. Structure for Table BIBLIDBF

Field Name

Type

Width

Function

1 SUBJ_NAME

Character

67

Name of Commentator

2 NOTES

Memo

10

Memo field collecting bibliography