1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| create table BATI4 (
N_FICHE char(5) not null,
DATE_ datetime not null,
NOM char(100) not null,
DISTRICT char(255) not null,
ILOT char(200) not null,
ADR char(255) not null,
TYPE_CONSTR char(255) not null,
USAGE char(255) not null,
TYPE_STR char(255) not null,
TYPE_STR_DET char(255) null,
DATE_CONST char(15) not null,
SS char(3) not null,
NB_SS int null,
RDC char(3) not null,
NB_RDC int null,
VIDE_SANT char(3) not null,
DIM_STR_X double not null,
DIM_STR_Y double not null,
NB_TRAVEES int not null,
REGU_PLN char(25) not null,
REG_ELV char(25) not null,
constr char(10),
join_sism char(3),
epaiss int,
etat_const char(8),
remq char(250),
imp1 char(3),
imp2 char(3),
imp3 char(3),
imp4 char(3),
imp5 char(3),
constraint PK_BATI primary key (N_FICHE)
) |
Partager