User Tools

Site Tools


dev:contact

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dev:contact [2019/04/08 11:25]
neumannptb Created from the form at dev:schema
dev:contact [2019/04/08 11:33] (current)
neumannptb
Line 1: Line 1:
 === contact === === contact ===
 ^ name ^ type ^ comment ^ NOT NULL ^ primary key ^ foreign key ^ ^ name ^ type ^ comment ^ NOT NULL ^ primary key ^ foreign key ^
-NUMERICS ​| INTEGER | comment ​| X | X |  | +ID| INTEGER | unique customer ID | X | X |  | 
-FK INTEGER ​| X |  | [[ dev:​TABLENAME | TABLENAME.COLNAME ]] +NAME VARCHAR ​name and surname of contact person ​| X |  |  
-FLOATINGS ​FLOAT  |  |  |  | +PHONE VARCHAR ​phone number of contact person ​|  |  |  | 
-BOOL BOOLEAN ​|  ​| X |  |  | +FAX VARCHAR | fax number of contact person ​|  |  |  | 
-STRING ​| VARCHAR |  ​| X |  |  | +CELLPHONE ​| VARCHAR ​| cellphone number of contact person ​|  |  |  | 
-DATES DATE  |  |  |  | +EMAIL VARCHAR ​email of contact person ​|  |  |  | 
-| TIMESTAMPS | TIMESTAMP |  |  |  |  |+
    
 ~~DISCUSSION~~ ~~DISCUSSION~~
dev/contact.txt · Last modified: 2019/04/08 11:33 by neumannptb

Statement on Data Protection | Imprint