# Database Tables Structure # Articles #### **Articles Database Table Structure** The following details the structure of the **Articles** table of the database.

Name	Type	Attribute	NULL	Default
art\_id	int(11)	UNSIGNED	No	None
art\_title\_sort	varchar(128)		No	None
art\_title	varchar(256)		No	None
art\_date	varchar(11)		Yes	NULL
art\_category	varchar(128)		Yes	NULL
art\_source	varchar(128)		Yes	NULL
art\_author	varchar(64)		Yes	NULL
art\_position	varchar(64)		Yes	NULL
art\_contributor	varchar(128)		Yes	NULL
art\_prevnext	varchar(9)		Yes	NULL
art\_ext\_link	varchar(256)		Yes	NULL
art\_styles	mediumtext		Yes
art\_text	mediumtext		Yes
art\_lat	varchar(20)		Yes	NULL
art\_lon	varchar(21)		Yes	NULL
art\_timestamp	timestamp	on update CURRENT\_TIMESTAMP	No	1/28/2024 1:42

The elements of the *Articles* table are as follows... 1. **Name** - Identifies the name of the element. 2. **Type** - Identifies the type of element and the length. - int(xx) - integer of length xx. - varchar(xxx) - variable length text of length xxx (Max length of 3000 characters). - mediumtext - Text with max length of 16,777,215 bytes (16MB) - timestamp - current date-time of record update. 3. **Attribute** - Identifies the any attribute of the element. 4. **NULL** - Identifies whether the element can be NULL. 5. **Default** - Identifies the default of the element. # Memorials ### **Memorials Table Structure** The *Memorials* table structure is as follows...

Name	Type	Attribute	NULL	Default
per\_id	int(11)	AUTO\_INCREMENT	No	None
per\_cem\_id	int(11)		No	0
per\_name\_full	varchar(1024)		Yes	NULL
per\_name\_last	varchar(45)		No	None
per\_name\_first	varchar(45)		Yes	NULL
per\_name\_middle	varchar(45)		Yes	NULL
per\_name\_maiden	varchar(45)		Yes	NULL
per\_name\_prior	varchar(50)		Yes	NULL
per\_name\_prefix	varchar(45)		Yes	NULL
per\_name\_suffix	varchar(45)		Yes	NULL
per\_name\_nickname	varchar(45)		Yes	NULL
per\_date\_birth	varchar(45)		Yes	NULL
per\_date\_marriage	varchar(45)		Yes	NULL
per\_date\_death	varchar(45)		Yes	NULL
per\_date\_burial	varchar(45)		Yes	NULL
per\_place\_birth	varchar(96)		Yes	NULL
per\_place\_marriage	varchar(96)		Yes	NULL
per\_place\_death	varchar(96)		Yes	NULL
per\_plot\_burial	varchar(256)		Yes	NULL
per\_plot\_lat	varchar(9)		Yes	NULL
per\_plot\_lon	varchar(10)		Yes	NULL
per\_text\_obit	text		Yes
per\_text\_death\_cert	text		Yes
per\_img\_tmbstn	varchar(255)		Yes	NULL
per\_img\_tmbdtl	varchar(255)		Yes	NULL
per\_img\_ftstn	varchar(255)		Yes	NULL
per\_img\_plot	varchar(255)		Yes	NULL
per\_img\_person	varchar(255)		Yes	NULL
per\_img\_mil	varchar(255)		Yes	NULL
per\_img\_obit	varchar(255)		Yes	NULL
per\_img\_bio	varchar(255)		Yes	NULL
per\_img\_funcd	varchar(255)		Yes	NULL
per\_img\_credits	varchar(256)		Yes	NULL
per\_vet\_notes	text		Yes
per\_vet\_inscription	text		Yes
per\_vet\_text	varchar(255)		Yes	NULL
per\_inscription	text		Yes
per\_note\_research	text		Yes
per\_addl\_text	text		Yes
per\_bio\_id	varchar(14)		Yes	NULL
per\_parents	text		Yes
per\_siblings	text		Yes
per\_spouse	text		Yes
per\_children	text		Yes
per\_rep\_tx	char(1)		No	N
per\_timestamp	timestamp	ON UPDATE CURRENT\_TIMESTAMP	No	12/7/2010 23:58

The elements of the *Memorials* table are as follows... 1. **Name** - Identifies the name of the element. 2. **Type** - Identifies the type of element and the length. - int(xx) - integer of length xx. - varchar(xxx) - variable length text of length xxx (Max length of 3000 characters). - text - Text with max length of 65,535 characters (64Kb) - char(x) - characters of length x. - timestamp - current date-time of record update. 3. **Attribute** - Identifies the attribute of the element. 4. **NULL** - Identifies whether the element can be NULL. 5. **Default** - Identifies the default of the element.