Log in
Forgot your password?
The Dublin Core metadata element set
is a standard for cross-domain information resource description.
|
||
| Element | Description | Value |
|---|---|---|
| Identifier | resource ID | http://old.zope.org/Members/aeg/ZPostgresUtils |
| Title | resource name | PostgreSQL Database Utility |
| Description | resource summary | Depending on referential integrities ZPostgresUtils generates a database diagram.<br> At this time ZPostgresUtils is a ZClass based product.<br> It works with RDBMS PostgreSQL 7.0 or later.<br> <br> <b>Assuming you setup the following tables ...</b><br> <p> CREATE TABLE title (<br> titleid SERIAL NOT NULL,<br> title character varying(50))<br> <br> CREATE TABLE customer (<br> customerid SERIAL NOT NULL,<br> name character varying(75),<br> city character varying(50),<br> street character varying(75),<br> phone character varying(20),<br> fax character varying(20))<br> <br> CREATE TABLE orders (<br> orderid SERIAL NOT NULL,<br> customerid int4 NOT NULL REFERENCES customer (customerid) ON DELETE RESTRICT ON UPDATE CASCADE INITIALLY DEFERRED,<br> what character varying(60),<br> deadline date)<br> <br> CREATE TABLE invoice (<br> invoiceid SERIAL NOT NULL,<br> orderid int4 NOT NULL CONSTRAINT fororders REFERENCES orders (orderid) MATCH FULL ON DELETE RESTRICT ON UPDATE CASCADE,<br> amount float8)<br> </p> <b>... you will get this output:</b><br> <br> <B>Tables and Views with referential integrity definition<B> <table border=0 cellpadding=2><tr><td bgcolor=#ff0000 colspan=7><b>customer</b></td></tr><tr><td bgcolor=#ffc0c0 valign=top>customerid</td><td bgcolor=#c0ffc0 valign=top><table border=0 cellpadding=2 height="100%" width="100%"><tr><td bgcolor=#00ff00 colspan=5><b>orders</b></td></tr><tr><td bgcolor=#c0ffc0 valign=top>orderid</td><td bgcolor=#c0c0ff valign=top><table border=0 cellpadding=2 height="100%" width="100%"><tr><td bgcolor=#0000ff colspan=3><b>invoice</b></td></tr><tr><td bgcolor=#c0c0ff valign=top>invoiceid</td><td bgcolor=#c0c0ff valign=top>orderid</td><td bgcolor=#c0c0ff valign=top>amount</td></tr></table></td><td bgcolor=#c0ffc0 valign=top>customerid</td><td bgcolor=#c0ffc0 valign=top>what</td><td bgcolor=#c0ffc0 valign=top>deadline</td></tr></table></td><td bgcolor=#ffc0c0 valign=top>name</td><td bgcolor=#ffc0c0 valign=top>city</td><td bgcolor=#ffc0c0 valign=top>street</td><td bgcolor=#ffc0c0 valign=top>phone</td><td bgcolor=#ffc0c0 valign=top>fax</td></tr></table> <HR> <B>Tables and Views without any referential integrity definition<B> <table border=1><tr><th>Name</th><th>Type</th><th>Fields</th></tr> <tr><td>title</td><td>table</td><td>titleid,title,</td></tr> </table> <HR> <B>Referential integrities<B> <table border=1> <tr><td>Table</td><td>Source Table</td><td>Source Field</td><td>Destination Table</td><td>Destination Field</td><td>is Foreign Key</td><td> Descr.</td><td>Deferrable</td><td>Initially Deferred</td><td>Constraint Name</td><td>MATCH</td></tr> <tr><td>customer</td><td>customer</td><td>customerid</td><td>orders</td><td>customerid</td><td>0</td><td>ON DELETE RESTRICT</td><td>f</td><td>f</td><td> <unnamed></td><td>UNSPECIFIED</td></tr> <tr><td>customer</td><td>customer</td><td>customerid</td><td>orders</td><td>customerid</td><td>0</td><td>ON UPDATE CASCADE</td><td>t</td><td>t</td><td> <unnamed></td><td>UNSPECIFIED</td></tr> <tr><td>orders</td><td>orders</td><td>orderid</td><td>invoice</td><td>orderid</td><td>0</td><td>ON DELETE RESTRICT</td><td>f</td><td>f</td><td> fororders</td><td>FULL</td></tr> <tr><td>orders</td><td>orders</td><td>orderid</td><td>invoice</td><td>orderid</td><td>0</td><td>ON UPDATE CASCADE</td><td>f</td><td>f</td><td> fororders</td><td>FULL</td></tr> <tr><td>orders</td><td>customer</td><td>customerid</td><td>orders</td><td>customerid</td><td>1</td><td>FOREIGN KEY ... REFERENCES</td><td>t</td><td>t</td><td> <unnamed></td><td>UNSPECIFIED</td></tr> <tr><td>invoice</td><td>orders</td><td>orderid</td><td>invoice</td><td>orderid</td><td>1</td><td>FOREIGN KEY ... REFERENCES</td><td>f</td><td>f</td><td> fororders</td><td>FULL</td></tr> </table> |
| Creator | resource creator | ZopeOrgSite |
| Date | default date | 2000-12-22 17:30:23 |
| Format | resource format | text/html |
| Type | resource type | Software Package |
| Subject | resource keywords | External Access, Helpers, Statistics and Analysis |
| Contributors | resource collaborators | |
| Language | resource language | |
| Publisher | resource publisher | No publisher |
| Rights | resource copyright | |
|
||
| Element | Description | Value |
| CreationDate | date resource created | 2000-12-22 17:30:23 |
| ModificationDate | date resource last modified | 2000-12-22 17:30:23 |
| EffectiveDate | date resource becomes effective | None |
| ExpirationDate | date resource expires | None |
Backlinks:
via
Google
/
Technorati
RDF:
view RDF data