# 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.