Home
Sample work
Sample code
Database visualizer
Definitions
Resume
Contact
create new table
db tools
manually enter SQL
gus_demo
:
altering table definition for tf_column_info
Table Name:
[
view 0 records of existing table data
] [
view SQL table definition
] [
new table
]
select
column
type
size
default
nullable
PK
auto++
more
relate
+field
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
<=
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
=>
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
=>
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
->
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
=>
here
display name
help text
extra functionality
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Created Date
true
false
Is a Modified Date
true
false
Force Editable
true
false
Force Uneditable
true
false
Is a Password
true
false
width:
height:
move selected:
up
|
down
|
delete selected
Foreign Tables
tf_validation_type
tf_validation_pattern
tf_browsetype
