Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +-------------------+--------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-------------------+--------------+------+-----+---------+-------+
- | firstName | varchar(25) | NO | | NULL | |
- | middleInitial | char(2) | YES | | NULL | |
- | lastName | varchar(30) | NO | | NULL | |
- | suffixDescription | varchar(5) | YES | | NULL | |
- | titleDescription | varchar(5) | YES | | NULL | |
- | nickname | varchar(15) | YES | | NULL | |
- | jobTitle | varchar(35) | YES | | NULL | |
- | hireDate | date | YES | | NULL | |
- | petDepartment | varchar(40) | YES | | NULL | |
- | email | varchar(40) | NO | | NULL | |
- | phoneNumber | varchar(25) | NO | PRI | | |
- | phoneType | varchar(10) | NO | | NULL | |
- | IMaddress | varchar(30) | YES | | NULL | |
- | MySpaceURL | varchar(50) | YES | | NULL | |
- | petYouTubeVideo | varchar(50) | YES | | NULL | |
- | SecondLifePlayer | tinyint(1) | YES | | NULL | |
- | notes | varchar(255) | YES | | NULL | |
- | petStoreName | varchar(30) | YES | | NULL | |
- | street1 | varchar(50) | YES | | NULL | |
- | street2 | varchar(50) | YES | | NULL | |
- | city | varchar(25) | YES | | NULL | |
- | stateOrProvince | varchar(15) | YES | | NULL | |
- | zipOrPostalCode | varchar(10) | YES | | NULL | |
- | countryOrRegion | varchar(15) | YES | | NULL | |
- | storeURL | varchar(40) | YES | | NULL | |
- | suffixID | int(11) | YES | | NULL | |
- | titleID | int(11) | YES | | NULL | |
- | petStoreID | varchar(15) | NO | | NULL | |
- | buddyID | varchar(10) | NO | PRI | NULL | |
- | phoneTypeID | int(11) | NO | | NULL | |
- +-------------------+--------------+------+-----+---------+-------+
- 30 rows in set (0.00 sec)
Add Comment
Please, Sign In to add comment