archive_requests

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
name VARCHAR 100 null
address VARCHAR 200 √ NULL
address2 VARCHAR 200 √ NULL
city VARCHAR 200 √ NULL
state VARCHAR 200 √ NULL
zip VARCHAR 12 √ NULL
country VARCHAR 50 √ NULL
phone VARCHAR 20 √ NULL
alternatePhone VARCHAR 20 √ NULL
email VARCHAR 100 √ NULL
format LONGTEXT 2147483647 √ NULL
purpose LONGTEXT 2147483647 √ NULL
pid VARCHAR 50 √ NULL
dateRequested INT 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
archive_requests_s_pk Primary key Asc id
name Performance Asc name
pid Performance Asc pid
PRIMARY Must be unique Asc id

Relationships

Close relationships within degrees of separation