Changes

Jump to: navigation, search

Dbms workshop

1,431 bytes added, 18:33, 20 May 2014
/* Creation de table */
=== Creation de table ===
 
<pre>
ffh=# \d
List of relations
Schema | Name | Type | Owner
--------+------------------------------+----------+-------
public | langue | table | fixme
public | langue_langue_id_seq | sequence | fixme
public | member | table | fixme
public | member_member_id_seq | sequence | fixme
public | motclef | table | fixme
public | motclef_motclef_id_seq | sequence | fixme
public | nourriture | table | fixme
public | nourriture_nourriture_id_seq | sequence | fixme
public | produit | table | fixme
public | produit_produit_id_seq | sequence | fixme
(10 rows)
 
ffh=# \d langue
Table "public.langue"
Column | Type | Modifiers
----------------+---------+------------------------------------------------------------
langue_id | integer | not null default nextval('langue_langue_id_seq'::regclass)
langue_libelle | text | not null
Indexes:
"langue_pkey" PRIMARY KEY, btree (langue_id)
Referenced by:
TABLE "member" CONSTRAINT "member_langue_id_fkey" FOREIGN KEY (langue_id) REFERENCES langue(langue_id)
TABLE "motclef" CONSTRAINT "motclef_langue_id_fkey" FOREIGN KEY (langue_id) REFERENCES langue(langue_id)
 
</pre>
154
edits