podoc:label_sql_table
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
podoc:label_sql_table [2007/04/12 12:17] – created Luud | podoc:label_sql_table [2007/04/20 15:28] (current) – Luud | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database Table Description ===== | + | ===== Database Table Description |
=== Name === | === Name === | ||
+ | |||
+ | label | ||
=== Description === | === Description === | ||
Line 8: | Line 10: | ||
=== Schema === | === Schema === | ||
+ | |||
+ | <code sql> | ||
+ | create table label ( -- labels, for printing | ||
+ | identifier | ||
+ | users | ||
+ | manufacturer | ||
+ | name varchar(300), | ||
+ | space_x | ||
+ | space_y | ||
+ | size_x | ||
+ | size_y | ||
+ | offset_x | ||
+ | offset_y | ||
+ | columns | ||
+ | rows float, | ||
+ | paper | ||
+ | date_of_creation | ||
+ | last_modified_date timestamp | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | * manufacturer references [[manufacturer sql table|manufacturer]](identifier) | ||
+ | * paper references [[paper sql table|paper]](identifier) | ||
+ | * users references [[users sql table|users]](identifier) | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[preferences sql table|preferences]](label) references identifier | ||
+ | * [[system_preferences sql table|system_preferences]](new_user_label) references identifier | ||
=== Related sequences === | === Related sequences === | ||
+ | |||
+ | * [[label_id_sequence sql sequence|label_id_sequence]] | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | * [[label_idx sql index|label_idx]] | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | None. | ||
+ | |||
+ | === Related views === | ||
+ | |||
+ | None. | ||
=== History === | === History === | ||
Line 25: | Line 68: | ||
Still in use | Still in use | ||
- | == Change | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | ... | + | create table label ( -- labels, for printing |
- | ); | + | identifier |
+ | users | ||
+ | manufacturer | ||
+ | name varchar(300), | ||
+ | space_x | ||
+ | space_y | ||
+ | size_x | ||
+ | size_y | ||
+ | offset_x | ||
+ | offset_y | ||
+ | columns | ||
+ | rows float, | ||
+ | paper | ||
+ | date_of_creation | ||
+ | last_modified_date timestamp | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | == Data change history == | ||
+ | |||
+ | = Version 2.5 = | ||
+ | |||
+ | <code sql> | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nExtval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | |||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | insert into label values (nextval(' | ||
+ | </ |
podoc/label_sql_table.1176380272.txt.gz · Last modified: 2007/04/12 12:17 by Luud