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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| CREATE TYPE Tlien_config AS OBJECT
(id_config INTEGER,
id_lien VARCHAR2(30),
frequence VARCHAR2(30),
sous_bande VARCHAR2(30),
comment_config VARCHAR2(30),
distance_lien REAL,
site_a VARCHAR2(30),
latitude_a REAL,
longitude_a REAL,
azimut_a REAL,
equipement_a VARCHAR2(30),
diam_a REAL,
h_ant_a REAL,
h_building_a REAL,
h_roof_a REAL,
space_div_a VARCHAR2(30),
diam_a2 REAL,
sep_ant_a REAL,
h_tower_a REAL,
polar_a VARCHAR2(30),
canaux_a INTEGER,
frequence_a REAL,
site_b VARCHAR2(30),
latitude_b REAL,
longitude_b REAL,
azimut_b REAL,
equipement_b VARCHAR2(30),
diam_b REAL,
h_ant_b REAL,
h_building_b REAL,
h_roof_b REAL,
space_div_b VARCHAR2(30),
diam_b2 REAL,
sep_ant_b REAL,
h_tower_b REAL,
polar_b VARCHAR2(30),
canaux_b INTEGER,
frequence_b REAL,
power_trans REAL,
level_recep REAL,
date_ajout date
)
/
CREATE TABLE lien_config OF Tlien_config
(PRIMARY KEY(id_config)
)
; |
Partager