All pastes #566508 Raw Edit

Something

public text v1 · immutable
·published 2007-06-14 14:01 UTC
rendered paste body
generic=> \d *_old      
                                               Table «public.currency_old»
  Colonne   |          Type          |                         Modificateurs                         
------------+------------------------+---------------------------------------------------------------
 idcurrency | integer                | not null default nextval('currency_idcurrency_seq'::regclass)
 iso        | character varying(5)   | 
 name       | character varying(255) | 
Index :
    «currency_pk» PRIMARY KEY, btree (idcurrency)

                                                  Table «public.incoterm_old»
     Colonne      |         Type          |                         Modificateurs                         
------------------+-----------------------+---------------------------------------------------------------
 idincoterm       | integer               | not null default nextval('incoterm_idincoterm_seq'::regclass)
 nomincoterm      | character varying(20) | 
 idpythonincoterm | character varying(20) | 
Index :
    «incoterm_pk» PRIMARY KEY, btree (idincoterm)

                                                     Table «public.structure_old»
       Colonne        |          Type          |                          Modificateurs                          
----------------------+------------------------+-----------------------------------------------------------------
 idstructure          | integer                | not null default nextval('structure_idstructure_seq'::regclass)
 adresse_idadresse    | integer                | not null
 adressinfo_idlibelle | integer                | not null
 vatcode              | character varying(255) | 
 rcs                  | character varying(255) | 
 siret                | character varying(255) | 
 legalform            | character varying(255) | 
 ape                  | character varying(255) | 
 freeinput_idlibelle  | integer                | not null
 name                 | character varying(20)  | 
 phone                | character varying(20)  | 
 fax                  | character varying(20)  | 
 websiteurl           | character varying(255) | 
 email                | character varying(45)  | 
 logo                 | character varying(255) | 
 footer_idlibelle     | integer                | not null
Index :
    «structure_pk» PRIMARY KEY, btree (idstructure)
    «structure_fkindex1» btree (adresse_idadresse)
Contraintes de clés secondaires :
    «rel_69» FOREIGN KEY (adresse_idadresse) REFERENCES adresse(idadresse)

                                      Table «public.vat_old»
      Colonne      |  Type   |                    Modificateurs                    
-------------------+---------+-----------------------------------------------------
 idvat             | integer | not null default nextval('vat_idvat_seq'::regclass)
 libelle_idlibelle | integer | not null