Commit | Line | Data |
aee4b66e |
1 | Schema: |
2 | Database: |
3 | |
4 | Foo: bar |
5 | Hello: world |
6 | |
7 | Table: Basic |
8 | ========================================================================== |
9 | |
10 | Fields |
11 | id |
12 | data_type: int |
13 | size: 10 |
14 | is_nullable: 0 |
15 | default_value: |
16 | is_primary_key: 1 |
17 | is_unique: 0 |
18 | is_auto_increment: 1 |
19 | is_foreign_key: 0 |
20 | foreign_key_reference: |
21 | is_valid: 1 |
22 | order: 1 |
23 | table: Basic |
24 | |
25 | title |
26 | data_type: varchar |
27 | size: 100 |
28 | is_nullable: 0 |
29 | default_value: hello |
30 | is_primary_key: 0 |
31 | is_unique: 1 |
32 | is_auto_increment: 0 |
33 | is_foreign_key: 0 |
34 | foreign_key_reference: |
35 | is_valid: 1 |
36 | order: 2 |
37 | table: Basic |
38 | |
39 | description |
40 | data_type: text |
41 | size: 0 |
42 | is_nullable: 1 |
43 | default_value: |
44 | is_primary_key: 0 |
45 | is_unique: 0 |
46 | is_auto_increment: 0 |
47 | is_foreign_key: 0 |
48 | foreign_key_reference: |
49 | is_valid: 1 |
50 | order: 3 |
51 | table: Basic |
52 | |
53 | email |
54 | data_type: varchar |
55 | size: 500 |
56 | is_nullable: 1 |
57 | default_value: |
58 | is_primary_key: 0 |
59 | is_unique: 1 |
60 | is_auto_increment: 0 |
61 | is_foreign_key: 0 |
62 | foreign_key_reference: |
63 | is_valid: 1 |
64 | order: 4 |
65 | table: Basic |
66 | |
67 | explicitnulldef |
68 | data_type: varchar |
69 | size: 0 |
70 | is_nullable: 1 |
71 | default_value: |
72 | is_primary_key: 0 |
73 | is_unique: 0 |
74 | is_auto_increment: 0 |
75 | is_foreign_key: 0 |
76 | foreign_key_reference: |
77 | is_valid: 1 |
78 | order: 5 |
79 | table: Basic |
80 | |
81 | explicitemptystring |
82 | data_type: varchar |
83 | size: 0 |
84 | is_nullable: 1 |
85 | default_value: |
86 | is_primary_key: 0 |
87 | is_unique: 0 |
88 | is_auto_increment: 0 |
89 | is_foreign_key: 0 |
90 | foreign_key_reference: |
91 | is_valid: 1 |
92 | order: 6 |
93 | table: Basic |
94 | |
95 | emptytagdef |
96 | data_type: varchar |
97 | size: 0 |
98 | is_nullable: 1 |
99 | default_value: |
100 | is_primary_key: 0 |
101 | is_unique: 0 |
102 | is_auto_increment: 0 |
103 | is_foreign_key: 0 |
104 | foreign_key_reference: |
105 | is_valid: 1 |
106 | order: 7 |
107 | table: Basic |
108 | |
109 | another_id |
110 | data_type: int |
111 | size: 10 |
112 | is_nullable: 1 |
113 | default_value: 2 |
114 | is_primary_key: 0 |
115 | is_unique: 0 |
116 | is_auto_increment: 0 |
117 | is_foreign_key: 1 |
118 | foreign_key_reference: Another |
119 | is_valid: 1 |
120 | order: 8 |
121 | table: Basic |
122 | |
123 | timest |
124 | data_type: timestamp |
125 | size: 0 |
126 | is_nullable: 1 |
127 | default_value: |
128 | is_primary_key: 0 |
129 | is_unique: 0 |
130 | is_auto_increment: 0 |
131 | is_foreign_key: 0 |
132 | foreign_key_reference: |
133 | is_valid: 1 |
134 | order: 9 |
135 | table: Basic |
136 | |
137 | |
138 | Indices |
139 | titleindex |
140 | table: Basic |
141 | fields: title |
142 | type: NORMAL |
143 | options: |
144 | is_valid: 1 |
145 | |
146 | |
147 | Constraints |
148 | ? |
149 | type: PRIMARY KEY |
150 | fields: id |
151 | expression: |
152 | match_type: |
153 | reference_fields: |
154 | reference_table: |
155 | deferrable: 1 |
156 | on_delete: |
157 | on_update: |
158 | options: |
159 | is_valid: 1 |
160 | |
161 | emailuniqueindex |
162 | type: UNIQUE |
163 | fields: email |
164 | expression: |
165 | match_type: |
166 | reference_fields: |
167 | reference_table: |
168 | deferrable: 1 |
169 | on_delete: |
170 | on_update: |
171 | options: |
172 | is_valid: 1 |
173 | |
174 | very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms |
175 | type: UNIQUE |
176 | fields: title |
177 | expression: |
178 | match_type: |
179 | reference_fields: |
180 | reference_table: |
181 | deferrable: 1 |
182 | on_delete: |
183 | on_update: |
184 | options: |
185 | is_valid: 1 |
186 | |
187 | ? |
188 | type: FOREIGN KEY |
189 | fields: another_id |
190 | expression: |
191 | match_type: |
192 | reference_fields: id |
193 | reference_table: Another |
194 | deferrable: 1 |
195 | on_delete: |
196 | on_update: |
197 | options: |
198 | is_valid: 1 |
199 | |
200 | Table: Another |
201 | ========================================================================== |
202 | |
203 | Fields |
204 | id |
205 | data_type: int |
206 | size: 10 |
207 | is_nullable: 0 |
208 | default_value: |
209 | is_primary_key: 1 |
210 | is_unique: 0 |
211 | is_auto_increment: 1 |
212 | is_foreign_key: 0 |
213 | foreign_key_reference: |
214 | is_valid: 1 |
215 | order: 1 |
216 | table: Another |
217 | |
218 | num |
219 | data_type: numeric |
220 | size: 10,2 |
221 | is_nullable: 1 |
222 | default_value: |
223 | is_primary_key: 0 |
224 | is_unique: 0 |
225 | is_auto_increment: 0 |
226 | is_foreign_key: 0 |
227 | foreign_key_reference: |
228 | is_valid: 1 |
229 | order: 2 |
230 | table: Another |
231 | |
232 | |
233 | Indices |
234 | |
235 | Constraints |
236 | ? |
237 | type: PRIMARY KEY |
238 | fields: id |
239 | expression: |
240 | match_type: |
241 | reference_fields: |
242 | reference_table: |
243 | deferrable: 1 |
244 | on_delete: |
245 | on_update: |
246 | options: |
247 | is_valid: 1 |
248 | |