X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fcsql.xml;h=47491ffe4fa44857334530ddd3e68054cfd01bd3;hb=e02d79979cb676b5e8d96b16456922afe77f4f74;hp=d0d09fa4c76caaa7efab2ccecd36dd4d1a59eac1;hpb=595658021ebaf450894bb143a346e409b55e02af;p=clsql.git diff --git a/doc/csql.xml b/doc/csql.xml index d0d09fa..47491ff 100644 --- a/doc/csql.xml +++ b/doc/csql.xml @@ -135,20 +135,16 @@ -CREATE TABLE EMPLOYEE ( - emplid NOT NULL number(38), - first_name NOT NULL varchar2(30), - last_name NOT NULL varchar2(30), - emall varchar2(100), - companyid NOT NULL number(38), - managerid number(38) -) - -CREATE TABLE COMPANY ( - companyid NOT NULL number(38), - name NOT NULL varchar2(100), - presidentid NOT NULL number(38) -) +CREATE TABLE EMPLOYEE ( emplid NOT NULL number(38), + first_name NOT NULL varchar2(30), + last_name NOT NULL varchar2(30), + email varchar2(100), + companyid NOT NULL number(38), + managerid number(38)) + +CREATE TABLE COMPANY ( companyid NOT NULL number(38), + name NOT NULL varchar2(100), + presidentid NOT NULL number(38)) @@ -189,7 +185,7 @@ mapped into a database). They would be defined as follows: (clsql:def-view-class company () ((companyid - :db-type :key + :db-kind :key :db-constraints :not-null :type integer :initarg :companyid) @@ -303,7 +299,7 @@ mapped into a database). They would be defined as follows: In an &sql; only application, the EMPLOYEE and COMPANY tables can be queried to determine things -like, "Who is Vladamir's manager?", What company does Josef work +like, "Who is Vladamir's manager?", "What company does Josef work for?", and "What employees work for Widgets Inc.". This is done by joining tables with an &sql; query.