podoc:contact_info_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:contact_info_sql_table [2007/04/19 08:36] – Luud | podoc:contact_info_sql_table [2007/04/20 15:32] (current) – Luud | ||
---|---|---|---|
Line 15: | Line 15: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table contact_info ( |
- | address1 | + | identifier |
- | address2 | + | address1 |
- | city varchar(100), | + | address2 |
- | zipcode | + | city varchar(100), |
- | state | + | zipcode |
- | country | + | state |
- | phone | + | country |
- | email | + | phone |
- | url | + | email |
- | ); | + | url |
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | * country references [[country sql table|country]](identifier) | ||
+ | * state references [[state sql table|state]](identifier) | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[users sql table|users]](contact) references identifier | ||
=== Related sequences === | === Related sequences === | ||
Line 58: | Line 69: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table contact_info ( |
- | address1 | + | identifier |
- | address2 | + | address1 |
- | city varchar(100), | + | address2 |
- | zipcode | + | city varchar(100), |
- | state | + | zipcode |
- | country | + | state |
- | phone | + | country |
- | email | + | phone |
- | url | + | email |
- | ); | + | url |
+ | ); | ||
+ | </ | ||
== Data change history == | == Data change history == | ||
Line 75: | Line 88: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | < | + | < |
insert into contact_info values (1, '', | insert into contact_info values (1, '', | ||
</ | </ | ||
podoc/contact_info_sql_table.1176971819.txt.gz · Last modified: 2007/04/19 08:36 by Luud