-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_table_and_columns.sql
103 lines (103 loc) · 2.77 KB
/
create_table_and_columns.sql
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
CREATE TABLE public.sirene
(
"SIREN" integer,
"NIC" character(5),
"L1_NORMALISEE" character(38),
"L2_NORMALISEE" character(38),
"L3_NORMALISEE" character(38),
"L4_NORMALISEE" character(38),
"L5_NORMALISEE" character(38),
"L6_NORMALISEE" character(38),
"L7_NORMALISEE" character(38),
"L1_DECLAREE" character(38),
"L2_DECLAREE" character(38),
"L3_DECLAREE" character(38),
"L4_DECLAREE" character(38),
"L5_DECLAREE" character(38),
"L6_DECLAREE" character(38),
"L7_DECLAREE" character(38),
"NUMVOIE" character(4),
"INDREP" character(1),
"TYPVOIE" character(4),
"LIBVOIE" character(32),
"CODPOS" character(5),
"CEDEX" character(5),
"RPET" character(2),
"LIBREG" character(70),
"DEPET" character(2),
"ARRONET" character(2),
"CTONET" character(3),
"COMET" character(3),
"LIBCOM" character(32),
"DU" character(2),
"TU" character(1),
"UU" character(2),
"EPCI" character(9),
"TCD" character(2),
"ZEMET" character(4),
"SIEGE" character(1),
"ENSEIGNE" character(50),
"IND_PUBLIPO" character(1),
"DIFFCOM" character(1),
"AMINTRET" character(6),
"NATETAB" character(1),
"LIBNATETAB" character(30),
"APET700" character(5),
"LIBAPET" character(65),
"DAPET" character(4),
"TEFET" character(2),
"LIBTEFET" character(23),
"EFETCENT" character(6),
"DEFET" character(4),
"ORIGINE" character(2),
"DCRET" character(8),
"DDEBACT" character(8),
"ACTIVNAT" character(2),
"LIEUACT" character(2),
"ACTISURF" character(2),
"SAISONAT" character(2),
"MODET" character(1),
"PRODET" character(1),
"PRODPART" character(1),
"AUXILT" character(1),
"NOMEN_LONG" character(131),
"SIGLE" character(20),
"NOM" character(100),
"PRENOM" character(30),
"CIVILITE" character(1),
"RNA" character(10),
"NICSIEGE" character(5),
"RPEN" character(2),
"DEPCOMEN" character(5),
"ADR_MAIL" character(80),
"NJ" character(4),
"LIBNJ" character(100),
"APEN700" character(5),
"LIBAPEN" character(65),
"DAPEN" character(4),
"APRM" character(6),
"ESS" character(1),
"DATEESS" character(8),
"TEFEN" character(2),
"LIBTEFEN" character(23),
"EFENCENT" character(6),
"DEFEN" character(4),
"CATEGORIE" character(5),
"DCREN" date,
"AMINTREN" character(6),
"MONOACT" character(1),
"MODEN" character(1),
"PRODEN" character(1),
"ESAANN" character(4),
"TCA" character(1),
"ESAAPEN" character(5),
"ESASEC1N" character(5),
"ESASEC2N" character(5),
"ESASEC3N" character(5),
"ESASEC4N" character(5),
"VMAJ" character(1),
"VMAJ1" character(1),
"VMAJ2" character(1),
"VMAJ3" character(1),
"DATEMAJ" date
);