podoc:label_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:label_sql_table [2007/04/19 08:49] – Luud | podoc:label_sql_table [2007/04/20 15:28] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table label ( -- labels, for printing |
- | users | + | identifier |
- | manufacturer | + | users |
- | name varchar(300), | + | manufacturer |
- | space_x | + | name varchar(300), |
- | space_y | + | space_x |
- | size_x | + | space_y |
- | size_y | + | size_x |
- | offset_x | + | size_y |
- | offset_y | + | offset_x |
- | columns | + | offset_y |
- | rows float, | + | columns |
- | paper | + | rows float, |
- | date_of_creation | + | paper |
- | last_modified_date timestamp | + | 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 === | ||
Line 59: | Line 72: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table label ( -- labels, for printing |
- | users | + | identifier |
- | manufacturer | + | users |
- | name varchar(300), | + | manufacturer |
- | space_x | + | name varchar(300), |
- | space_y | + | space_x |
- | size_x | + | space_y |
- | size_y | + | size_x |
- | offset_x | + | size_y |
- | offset_y | + | offset_x |
- | columns | + | offset_y |
- | rows float, | + | columns |
- | paper | + | rows float, |
- | date_of_creation | + | paper |
- | last_modified_date timestamp | + | date_of_creation |
- | ); | + | last_modified_date timestamp |
+ | ); | ||
+ | </ | ||
== Data change history == | == Data change history == | ||
Line 81: | Line 96: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | < | + | < |
insert into label values (nextval(' | insert into label values (nextval(' | ||
insert into label values (nextval(' | insert into label values (nextval(' |
podoc/label_sql_table.1176972582.txt.gz · Last modified: 2007/04/19 08:49 by Luud