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 regPetHist

Field Type Attributes Null Default Extra Action
uid  smallint(6)    No  0    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)    Yes      Change Drop Primary Index Unique
workPhone  char(14)    No      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
contactMethod  char(1)    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
last2Desc  char(100)    Yes      Change Drop Primary Index Unique
petName  char(20)    Yes      Change Drop Primary Index Unique
petDominantBreed  char(20)    Yes      Change Drop Primary Index Unique
petColor  char(20)    Yes      Change Drop Primary Index Unique
petWeight  char(12)    Yes      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
extra  char(20)    Yes      Change Drop Primary Index Unique
imageNum  smallint(6)    Yes      Change Drop Primary Index Unique
vetClinicName  char(20)    Yes      Change Drop Primary Index Unique
vetPhone  char(14)    Yes      Change Drop Primary Index Unique
regDate  date    Yes      Change Drop Primary Index Unique
debitLast  int(11)    Yes      Change Drop Primary Index Unique
creditLast  int(11)    Yes      Change Drop Primary Index Unique
cumBalance  int(11)    Yes      Change Drop Primary Index Unique
comments  char(150)    Yes      Change Drop Primary Index Unique
adminName  char(20)    Yes      Change Drop Primary Index Unique
statusFinancialy  char(2)    Yes      Change Drop Primary Index Unique
statusStray  char(7)    Yes      Change Drop Primary Index Unique
linkToFirstPetRecord  smallint(6)    Yes      Change Drop Primary Index Unique
linkToNextPetRecord  smallint(6)    Yes      Change Drop Primary Index Unique
petBirth  char(8)    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)    Yes      Change Drop Primary Index Unique

Keyname Unique Field Action
PRIMARY Yes uid Drop
lastName No lastName Drop
lastName No ownerName Drop
stateProvince No stateProvince Drop
workPhone No workPhone 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