rendered paste bodygeneric=> \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