podoc:country_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:country_sql_table [2007/04/13 09:34] – Luud | podoc:country_sql_table [2007/04/20 13:40] (current) – Luud | ||
---|---|---|---|
Line 6: | Line 6: | ||
=== Description === | === Description === | ||
+ | |||
+ | A list of all countries in the world. | ||
=== Purpose === | === Purpose === | ||
+ | |||
+ | Referential integrity. | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table country ( |
- | code varchar(5), | + | identifier |
- | value | + | code varchar(5), |
- | ); | + | value |
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | None. | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[contact_info sql table|contact_info]](country) references identifier | ||
+ | * [[location sql table|location]](country) references identifier | ||
=== Related sequences === | === Related sequences === | ||
Line 22: | Line 37: | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | None. | ||
=== Related views === | === Related views === | ||
+ | |||
+ | None. | ||
=== History === | === History === | ||
Line 41: | Line 62: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table country ( |
- | code varchar(5), | + | identifier |
- | value | + | code varchar(5), |
- | ); | + | value |
+ | ); | ||
+ | </ | ||
== Data change history == | == Data change history == | ||
Line 51: | Line 74: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | < | + | < |
insert into country values (nextval(' | insert into country values (nextval(' | ||
insert into country values (nextval(' | insert into country values (nextval(' |
podoc/country_sql_table.txt · Last modified: 2007/04/20 13:40 by Luud