Objekt "Person" machen, 1. Teil Datenbanktabelle "Person" (Roger) und neuer Ausgabevorschlag

Tabelle Person
==============

CREATE TABLE Person (
  ID int(11) NOT NULL auto_increment,
  honorific enum('Herr','Frau') NOT NULL default 'Herr',
  firstname varchar(50) NOT NULL default '',
  surname varchar(50) NOT NULL default '',
  othername varchar(50) default NULL,
  affiliation_jobtitle varchar(50) default NULL,
  affiliation_orgname varchar(50) default NULL,
  affiliation_orgdiv varchar(50) default NULL,
  affiliation_address_street varchar(50) default NULL,
  affiliation_address_pob varchar(20) default NULL,
  affiliation_address_postcode int(5) default NULL,
  affiliation_address_city varchar(40) default NULL,
  affiliation_address_country varchar(40) NOT NULL default 'Schweiz',
  affiliation_address_phone varchar(20) default NULL,
  affiliation_address_fax varchar(20) default NULL,
  affiliation_address_email varchar(50) default NULL,
  affiliation_www varchar(100) default NULL,
  address_street varchar(50) NOT NULL default '',
  address_pob varchar(20) default NULL,
  address_postcode int(5) NOT NULL default '0',
  address_city varchar(40) NOT NULL default '',
  address_country varchar(40) NOT NULL default 'Schweiz',
  address_phone varchar(20) NOT NULL default '',
  address_mobile varchar(20) default NULL,
  address_mobile2 varchar(25) default NULL,
  address_fax varchar(20) default NULL,
  address_email varchar(50) default NULL,
  www varchar(100) default NULL,
  project varchar(100) NOT NULL default '',
  project_jobtitle varchar(100) NOT NULL default '',
  remark text,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  createdby varchar(50) NOT NULL default 'someone',
  changed timestamp(14) NOT NULL,
  changedby varchar(50) NOT NULL default 'someone',
  PRIMARY KEY  (ID),
  UNIQUE KEY ID (ID)
) TYPE=MyISAM;



Ausgabe
=======

$firstname $surname
$project_jobtitle

Büro: $affiliation_address_email
Privat: $address_email

$remark








--
roger fischer | bitflux GmbH | schöneggstrasse 5 | ch-8004 zürich
tel +41 1 240 56 72 | mobil +41 78 607 75 06 | fax +41 1 240 56 71
http://www.bitflux.ch | [email protected]

OSCOM - Open Source Content Management
http://www.oscom.org