StarDesigns.net
EMPLOYMENT | NEWS | SITE MAP | ABOUT US | CONTACT US



DESIGN
HOSTING
SPECIALTIES
MARKETING

Domain Name Search
www.

.com .net .org

HOME

professional web design, web hosting, internet marketing, online marketing

Database petsDB - table regPet

Field Type Attributes Null Default Extra Action
uid  smallint(6)    No  0  auto_increment  Change Drop Primary Index Unique
ownerName  char(20)    No      Change Drop Primary Index Unique
middleInitial  char(1)    Yes      Change Drop Primary Index Unique
lastName  char(30)    No      Change Drop Primary Index Unique
addressP1  char(100)    Yes      Change Drop Primary Index Unique
addressP2  char(100)    Yes      Change Drop Primary Index Unique
country  char(15)    Yes      Change Drop Primary Index Unique
stateProvince  char(2)    No      Change Drop Primary Index Unique
homePhone  char(14)    No      Change Drop Primary Index Unique
workPhone  char(14)    Yes      Change Drop Primary Index Unique
workFax  char(14)    Yes      Change Drop Primary Index Unique
cellPhone  char(14)    Yes      Change Drop Primary Index Unique
emailNormal  char(70)    Yes      Change Drop Primary Index Unique
emailSecondary  char(70)    Yes      Change Drop Primary Index Unique
birthday  smallint(4)    Yes      Change Drop Primary Index Unique
owner2Name  char(20)    Yes      Change Drop Primary Index Unique
middle2Initial  char(1)    Yes      Change Drop Primary Index Unique
last2Name  char(30)    Yes      Change Drop Primary Index Unique
petName  char(20)    No      Change Drop Primary Index Unique
petDominantBreed  char(20)    Yes      Change Drop Primary Index Unique
petColor  char(20)    No      Change Drop Primary Index Unique
petCharacteristics  char(20)    Yes      Change Drop Primary Index Unique
petMedConditions  char(20)    Yes      Change Drop Primary Index Unique
licenseNum  int(11)    Yes      Change Drop Primary Index Unique
microchipId  char(20)    Yes      Change Drop Primary Index Unique
tattoo  char(20)    Yes      Change Drop Primary Index Unique
otherPetId  char(40)    Yes      Change Drop Primary Index Unique
petCollarTag  char(20)    Yes      Change Drop Primary Index Unique
imageNum  smallint(6)    No  0    Change Drop Primary Index Unique
vetClinicName  char(20)    Yes      Change Drop Primary Index Unique
vetPhone  char(14)    Yes      Change Drop Primary Index Unique
updOwnerDate  date    Yes      Change Drop Primary Index Unique
expDate  date    Yes      Change Drop Primary Index Unique
updOperDate  date    Yes      Change Drop Primary Index Unique
comments  char(150)    Yes      Change Drop Primary Index Unique
operName  char(20)    Yes      Change Drop Primary Index Unique
statusFinancialy  char(2)    Yes      Change Drop Primary Index Unique
statusStray  char(1)    No  n    Change Drop Primary Index Unique
linkToFirstPetRecord  smallint(6)    Yes      Change Drop Primary Index Unique
linkToNextPetRecord  smallint(6)    No  0    Change Drop Primary Index Unique
petBirth  char(4)    Yes      Change Drop Primary Index Unique
insuranceCompany  char(50)    Yes      Change Drop Primary Index Unique
policyNumber  char(30)    Yes      Change Drop Primary Index Unique
operatorAV  char(1)    No      Change Drop Primary Index Unique
homeFax  char(14)    Yes      Change Drop Primary Index Unique
cb_homePhone  char(1)    No  0    Change Drop Primary Index Unique
cb_workPhone  char(1)    No  0    Change Drop Primary Index Unique
cb_workFax  char(1)    No  0    Change Drop Primary Index Unique
cb_homeFax  char(1)    No  0    Change Drop Primary Index Unique
cb_cellPhone  char(1)    No  0    Change Drop Primary Index Unique
cb_emailNormal  char(1)    No  0    Change Drop Primary Index Unique
home2Phone  char(14)    Yes      Change Drop Primary Index Unique
work2Phone  char(14)    Yes      Change Drop Primary Index Unique
work2Fax  char(14)    Yes      Change Drop Primary Index Unique
home2Fax  char(14)    Yes      Change Drop Primary Index Unique
cell2Phone  char(14)    Yes      Change Drop Primary Index Unique
cb_home2Phone  char(1)    No  0    Change Drop Primary Index Unique
cb_work2Phone  char(1)    No  0    Change Drop Primary Index Unique
cb_work2Fax  char(1)    No  0    Change Drop Primary Index Unique
cb_home2Fax  char(1)    No  0    Change Drop Primary Index Unique
cb_cell2Phone  char(1)    No  0    Change Drop Primary Index Unique
cb_emailSecondary  char(1)    No  0    Change Drop Primary Index Unique
licenseLoc  char(30)    Yes      Change Drop Primary Index Unique
petSize  char(10)    No      Change Drop Primary Index Unique
county  char(30)    Yes      Change Drop Primary Index Unique
petSpecies  char(20)    No      Change Drop Primary Index Unique
petSex  char(1)    No      Change Drop Primary Index Unique
dLimit  char(4)    Yes      Change Drop Primary Index Unique
vetStreet  char(50)    Yes      Change Drop Primary Index Unique
vetCity  char(30)    Yes      Change Drop Primary Index Unique
vetStateProvince  char(2)    Yes      Change Drop Primary Index Unique
cb_dLimit  char(1)    Yes      Change Drop Primary Index Unique
petName2  char(20)    Yes      Change Drop Primary Index Unique
zipCode  char(7)    No      Change Drop Primary Index Unique
vetZipCode  char(7)    No      Change Drop Primary Index Unique

Keyname Unique Field Action
PRIMARY Yes uid Drop
lastName No lastName Drop
lastName No ownerName Drop
state No stateProvince Drop
[Documentation]
  • Browse
  • Select
  • Insert
  • Add new field:
  • Insert textfiles into table
  • View dump (schema) of table
    Structure only Add 'drop table'
    Structure and data send
    CSV data terminated by
  • Rename table to:
  • Copy table to:

    Structure only Structure and data


Back

© 2000 Stardesigns.net
Contact us: info@stardesigns.net