demo - table columns

All table columns

parent	column	definition	comment
EmployeeConfidential	EmployeeID	integer NOT NULL
EmployeeConfidential	DepartmentID	integer NOT NULL
EmployeeConfidential	SocialSecurityNumber	char(11) NULL
EmployeeConfidential	Salary	numeric(20,3) NOT NULL
EmployeeConfidential	ManagerID	integer NULL
EmployeeConfidential	DepartmentName	char(40) NOT NULL
EmployeeConfidential	DepartmentHeadID	integer NULL
2951doc1	file	unsigned smallint NOT NULL
2951doc1	page	unsigned int NOT NULL
2951doc1	bin	long binary NOT NULL
2951doc2	file	unsigned smallint NOT NULL
2951doc2	page	unsigned int NOT NULL
2951doc2	bin	long binary NOT NULL
2951pos1	term	varchar(20) NOT NULL
2951pos1	row	unsigned bigint NOT NULL
2951pos1	col	unsigned int NOT NULL
2951pos1	handle	unsigned int NOT NULL
2951pos1	position	unsigned int NOT NULL
2951pos1	free	unsigned smallint NOT NULL
2951pos1	bin	long binary NOT NULL
2951pos2	term	varchar(20) NOT NULL
2951pos2	row	unsigned bigint NOT NULL
2951pos2	col	unsigned int NOT NULL
2951pos2	handle	unsigned int NOT NULL
2951pos2	position	unsigned int NOT NULL
2951pos2	free	unsigned smallint NOT NULL
2951pos2	bin	long binary NOT NULL
2951stat1	type	tinyint NOT NULL
2951stat1	term	varchar(20) NOT NULL
2951stat1	freq	bigint NOT NULL
2951stat2	type	tinyint NOT NULL
2951stat2	term	varchar(20) NOT NULL
2951stat2	freq	bigint NOT NULL
zzz_object_comments	LevelZeroName	varchar(100) NULL
zzz_object_comments	LevelZeroType	varchar(100) NULL
zzz_object_comments	LevelOneName	varchar(100) NULL
zzz_object_comments	LevelOneType	varchar(100) NULL
zzz_object_comments	LevelTwoName	varchar(100) NULL
zzz_object_comments	LevelTwoType	varchar(100) NULL
zzz_object_comments	PropName	varchar(100) NOT NULL
zzz_object_comments	PropVal	varchar(2048) NOT NULL
Contacts	ID	integer NOT NULL
Contacts	Surname	person_name_t NOT NULL
Contacts	GivenName	person_name_t NOT NULL
Contacts	Title	person_title_t NULL
Contacts	Street	street_t NULL
Contacts	City	city_t NULL
Contacts	State	state_t NULL
Contacts	Country	country_t NULL
Contacts	PostalCode	postal_code_t NULL
Contacts	Phone	phone_number_t NULL
Contacts	Fax	phone_number_t NULL
Contacts	CustomerID	integer NULL
Customers	ID	integer NOT NULL = autoincrement	a column comment
Customers	Surname	person_name_t NOT NULL
Customers	GivenName	person_name_t NOT NULL
Customers	Street	street_t NOT NULL
Customers	City	city_t NOT NULL
Customers	State	state_t NULL
Customers	Country	country_t NULL
Customers	PostalCode	postal_code_t NULL
Customers	Phone	phone_number_t NOT NULL
Customers	CompanyName	company_name_t NULL
Departments	DepartmentID	integer NOT NULL
Departments	DepartmentName	char(40) NOT NULL
Departments	DepartmentHeadID	integer NULL
Employees	EmployeeID	integer NOT NULL
Employees	ManagerID	integer NULL
Employees	Surname	person_name_t NOT NULL
Employees	GivenName	person_name_t NOT NULL
Employees	DepartmentID	integer NOT NULL
Employees	Street	street_t NOT NULL
Employees	City	city_t NOT NULL
Employees	State	state_t NULL
Employees	Country	country_t NULL
Employees	PostalCode	postal_code_t NULL
Employees	Phone	phone_number_t NULL
Employees	Status	char(2) NULL
Employees	SocialSecurityNumber	char(11) NULL
Employees	Salary	numeric(20,3) NOT NULL
Employees	StartDate	date NOT NULL
Employees	TerminationDate	date NULL
Employees	BirthDate	date NULL
Employees	BenefitHealthInsurance	bit NULL
Employees	BenefitLifeInsurance	bit NULL
Employees	BenefitDayCare	bit NULL
Employees	Sex	char(2) NULL
FinancialCodes	Code	char(2) NOT NULL
FinancialCodes	Type	char(10) NOT NULL
FinancialCodes	Description	char(50) NULL
FinancialData	Year	char(4) NOT NULL
FinancialData	Quarter	char(2) NOT NULL
FinancialData	Code	char(2) NOT NULL
FinancialData	Amount	numeric(9,0) NULL
MarketingInformation	ID	integer NOT NULL
MarketingInformation	ProductID	integer NOT NULL
MarketingInformation	Description	long varchar NULL
Products	ID	integer NOT NULL
Products	Name	char(15) NOT NULL
Products	Description	char(30) NOT NULL
Products	Size	char(18) NOT NULL
Products	Color	char(6) NOT NULL
Products	Quantity	integer NOT NULL
Products	UnitPrice	numeric(15,2) NOT NULL
Products	Photo	image NULL
SalesOrderItems	ID	integer NOT NULL
SalesOrderItems	LineID	smallint NOT NULL
SalesOrderItems	ProductID	integer NOT NULL
SalesOrderItems	Quantity	integer NOT NULL
SalesOrderItems	ShipDate	date NOT NULL
SalesOrders	ID	integer NOT NULL = autoincrement
SalesOrders	CustomerID	integer NOT NULL
SalesOrders	OrderDate	date NOT NULL
SalesOrders	FinancialCode	char(2) NULL
SalesOrders	Region	char(7) NULL
SalesOrders	SalesRepresentative	integer NOT NULL
ml_active_remote_id	remote_id	varchar(128) NOT NULL
ml_active_remote_id	server_id	integer NOT NULL
ml_active_remote_id	status	char(1) NOT NULL
ml_column	version_id	integer NOT NULL
ml_column	table_id	integer NOT NULL
ml_column	idx	integer NOT NULL
ml_column	name	varchar(128) NOT NULL
ml_column	type	varchar(128) NULL
ml_connection_script	version_id	integer NOT NULL
ml_connection_script	event	varchar(128) NOT NULL
ml_connection_script	script_id	integer NOT NULL
ml_database	rid	integer NOT NULL = autoincrement
ml_database	remote_id	varchar(128) NOT NULL
ml_database	script_ldt	timestamp NOT NULL = '1900/01/01 00:00:00'
ml_database	description	varchar(128) NULL
ml_device	device_name	varchar(255) NOT NULL
ml_device	listener_version	varchar(128) NOT NULL
ml_device	listener_protocol	integer NOT NULL
ml_device	info	varchar(255) NOT NULL
ml_device	ignore_tracking	varchar(1) NOT NULL
ml_device	source	varchar(255) NOT NULL
ml_device_address	device_name	varchar(255) NOT NULL
ml_device_address	medium	varchar(255) NOT NULL
ml_device_address	address	varchar(255) NOT NULL
ml_device_address	active	varchar(1) NOT NULL
ml_device_address	last_modified	timestamp NOT NULL = timestamp
ml_device_address	ignore_tracking	varchar(1) NOT NULL
ml_device_address	source	varchar(255) NOT NULL
ml_listening	name	varchar(128) NOT NULL
ml_listening	device_name	varchar(255) NOT NULL
ml_listening	listening	varchar(1) NOT NULL
ml_listening	ignore_tracking	varchar(1) NOT NULL
ml_listening	source	varchar(255) NOT NULL
ml_passthrough	remote_id	varchar(128) NOT NULL
ml_passthrough	run_order	integer NOT NULL
ml_passthrough	script_id	integer NOT NULL
ml_passthrough	last_modified	timestamp NOT NULL = current timestamp
ml_passthrough_repair	failed_script_id	integer NOT NULL
ml_passthrough_repair	error_code	integer NOT NULL
ml_passthrough_repair	new_script_id	integer NULL
ml_passthrough_repair	action	char(1) NOT NULL
ml_passthrough_script	script_id	integer NOT NULL = autoincrement
ml_passthrough_script	script_name	varchar(128) NOT NULL
ml_passthrough_script	flags	varchar(256) NULL
ml_passthrough_script	affected_pubs	text NULL
ml_passthrough_script	script	text NOT NULL
ml_passthrough_script	description	varchar(2000) NULL
ml_passthrough_status	status_id	integer NOT NULL = autoincrement
ml_passthrough_status	remote_id	varchar(128) NOT NULL
ml_passthrough_status	run_order	integer NOT NULL
ml_passthrough_status	script_id	integer NOT NULL
ml_passthrough_status	script_status	char(1) NOT NULL
ml_passthrough_status	error_code	integer NULL
ml_passthrough_status	error_text	text NULL
ml_passthrough_status	remote_run_time	timestamp NOT NULL
ml_property	component_name	varchar(128) NOT NULL
ml_property	property_set_name	varchar(128) NOT NULL
ml_property	property_name	varchar(128) NOT NULL
ml_property	property_value	text NOT NULL
ml_qa_delivery	msgid	varchar(128) NOT NULL
ml_qa_delivery	seqno	bigint NOT NULL
ml_qa_delivery	address	varchar(255) NOT NULL
ml_qa_delivery	clientaddress	varchar(128) NOT NULL
ml_qa_delivery	client	varchar(128) NOT NULL
ml_qa_delivery	originator	varchar(128) NULL
ml_qa_delivery	priority	integer NOT NULL
ml_qa_delivery	expires	timestamp NULL
ml_qa_delivery	kind	integer NOT NULL
ml_qa_delivery	contentsize	bigint NOT NULL
ml_qa_delivery	status	integer NOT NULL
ml_qa_delivery	statustime	timestamp NOT NULL = current timestamp
ml_qa_delivery	syncstatus	integer NOT NULL
ml_qa_delivery	receiverid	varchar(128) NULL
ml_qa_delivery_archive	msgid	varchar(128) NOT NULL
ml_qa_delivery_archive	seqno	bigint NOT NULL
ml_qa_delivery_archive	address	varchar(255) NOT NULL
ml_qa_delivery_archive	clientaddress	varchar(128) NOT NULL
ml_qa_delivery_archive	client	varchar(128) NOT NULL
ml_qa_delivery_archive	originator	varchar(128) NULL
ml_qa_delivery_archive	priority	integer NOT NULL
ml_qa_delivery_archive	expires	timestamp NULL
ml_qa_delivery_archive	kind	integer NOT NULL
ml_qa_delivery_archive	contentsize	bigint NOT NULL
ml_qa_delivery_archive	status	integer NOT NULL
ml_qa_delivery_archive	statustime	timestamp NOT NULL = current timestamp
ml_qa_delivery_archive	syncstatus	integer NOT NULL
ml_qa_delivery_archive	receiverid	varchar(128) NULL
ml_qa_global_props	client	varchar(128) NOT NULL = ' '
ml_qa_global_props	name	varchar(128) NOT NULL
ml_qa_global_props	modifiers	integer NOT NULL
ml_qa_global_props	value	long varchar NULL
ml_qa_global_props	last_modified	timestamp NULL = timestamp
ml_qa_notifications	user_id	integer NOT NULL
ml_qa_notifications	name	varchar(128) NOT NULL
ml_qa_repository	msgid	varchar(128) NOT NULL
ml_qa_repository	props	long binary NULL
ml_qa_repository	content	long binary NULL
ml_qa_repository_archive	msgid	varchar(128) NOT NULL
ml_qa_repository_archive	props	long binary NULL
ml_qa_repository_archive	content	long binary NULL
ml_qa_repository_props	msgid	varchar(128) NOT NULL
ml_qa_repository_props	name	varchar(128) NOT NULL
ml_qa_repository_props	value	long varchar NULL
ml_qa_repository_props_archive	msgid	varchar(128) NOT NULL
ml_qa_repository_props_archive	name	varchar(128) NOT NULL
ml_qa_repository_props_archive	value	long varchar NULL
ml_qa_repository_staging	seqno	bigint NOT NULL
ml_qa_repository_staging	msgid	varchar(128) NOT NULL
ml_qa_repository_staging	destination	varchar(128) NOT NULL
ml_qa_repository_staging	originator	varchar(128) NULL
ml_qa_repository_staging	status	varchar(255) NOT NULL
ml_qa_repository_staging	statustime	timestamp NOT NULL
ml_qa_repository_staging	priority	integer NOT NULL
ml_qa_repository_staging	expires	timestamp NULL
ml_qa_repository_staging	kind	integer NOT NULL
ml_qa_repository_staging	contentsize	bigint NOT NULL
ml_qa_repository_staging	props	long binary NULL
ml_qa_repository_staging	content	long binary NULL
ml_qa_repository_staging	mluser	varchar(128) NULL
ml_qa_status_history	msgid	varchar(128) NOT NULL
ml_qa_status_history	address	varchar(255) NOT NULL
ml_qa_status_history	status	integer NOT NULL
ml_qa_status_history	statustime	timestamp NOT NULL
ml_qa_status_history	servertime	timestamp NOT NULL = current timestamp
ml_qa_status_history	details	varchar(1000) NULL
ml_qa_status_history	syncstatus	integer NOT NULL
ml_qa_status_history_archive	msgid	varchar(128) NOT NULL
ml_qa_status_history_archive	address	varchar(255) NOT NULL
ml_qa_status_history_archive	status	integer NOT NULL
ml_qa_status_history_archive	statustime	timestamp NOT NULL
ml_qa_status_history_archive	servertime	timestamp NOT NULL = current timestamp
ml_qa_status_history_archive	details	varchar(1000) NULL
ml_qa_status_history_archive	syncstatus	integer NOT NULL
ml_qa_status_staging	msgid	varchar(128) NOT NULL
ml_qa_status_staging	status	varchar(255) NOT NULL
ml_qa_status_staging	statustime	timestamp NOT NULL
ml_qa_status_staging	mluser	varchar(128) NULL
ml_script	script_id	integer NOT NULL = autoincrement
ml_script	script	text NOT NULL
ml_script	script_language	varchar(128) NOT NULL = 'sql'
ml_script	checksum	varchar(64) NULL
ml_script_version	version_id	integer NOT NULL = autoincrement
ml_script_version	name	varchar(128) NOT NULL
ml_script_version	description	text NULL
ml_scripts_modified	last_modified	datetime NOT NULL
ml_server	server_id	integer NOT NULL = autoincrement
ml_server	name	varchar(128) NOT NULL
ml_server	version	varchar(10) NOT NULL
ml_server	connection_info	varchar(2048) NOT NULL
ml_server	instance_key	binary NOT NULL
ml_server	start_time	timestamp NOT NULL = current timestamp
ml_server	liveness	timestamp NOT NULL = current timestamp
ml_sis_sync_state	remote_id	varchar(128) NOT NULL
ml_sis_sync_state	subscription_id	varchar(128) NOT NULL
ml_sis_sync_state	publication_name	varchar(128) NOT NULL
ml_sis_sync_state	user_name	varchar(128) NOT NULL
ml_sis_sync_state	last_upload	timestamp NOT NULL
ml_sis_sync_state	last_download	timestamp NOT NULL
ml_subscription	rid	integer NOT NULL
ml_subscription	subscription_id	varchar(128) NOT NULL = '<unknown>'
ml_subscription	user_id	integer NOT NULL
ml_subscription	progress	numeric(20,0) NOT NULL = 0
ml_subscription	publication_name	varchar(128) NOT NULL = '<unknown>'
ml_subscription	last_upload_time	timestamp NOT NULL = '1900/01/01 00:00:00'
ml_subscription	last_download_time	timestamp NOT NULL = '1900/01/01 00:00:00'
ml_table	table_id	integer NOT NULL = autoincrement
ml_table	name	varchar(128) NOT NULL
ml_table_script	version_id	integer NOT NULL
ml_table_script	table_id	integer NOT NULL
ml_table_script	event	varchar(128) NOT NULL
ml_table_script	script_id	integer NOT NULL
ml_user	user_id	integer NOT NULL = autoincrement
ml_user	name	varchar(128) NOT NULL
ml_user	hashed_password	binary NULL
ViewSalesOrders	ID	integer NOT NULL
ViewSalesOrders	LineID	smallint NOT NULL
ViewSalesOrders	ProductID	integer NOT NULL
ViewSalesOrders	Quantity	integer NOT NULL
ViewSalesOrders	OrderDate	date NOT NULL
ViewSalesOrders	ShipDate	date NOT NULL
ViewSalesOrders	Region	char(7) NULL
ViewSalesOrders	SalesRepresentativeName	varchar(41) NULL
ml_columns	version	varchar(128) NOT NULL
ml_columns	table_name	varchar(128) NOT NULL
ml_columns	column_name	varchar(128) NOT NULL
ml_columns	data_type	varchar(128) NULL
ml_columns	column_order	integer NOT NULL
ml_connection_scripts	version	varchar(128) NOT NULL
ml_connection_scripts	event	varchar(128) NOT NULL
ml_connection_scripts	script_language	varchar(128) NOT NULL
ml_connection_scripts	script	text NOT NULL
ml_qa_messages	seqno	bigint NOT NULL
ml_qa_messages	msgid	varchar(128) NOT NULL
ml_qa_messages	address	varchar(255) NOT NULL
ml_qa_messages	client	varchar(128) NOT NULL
ml_qa_messages	originator	varchar(128) NULL
ml_qa_messages	status	integer NOT NULL
ml_qa_messages	statustime	timestamp NOT NULL
ml_qa_messages	expires	timestamp NULL
ml_qa_messages	priority	integer NOT NULL
ml_qa_messages	props	long binary NULL
ml_qa_messages	kind	integer NOT NULL
ml_qa_messages	content	long binary NULL
ml_qa_messages	contentsize	bigint NOT NULL
ml_qa_messages	syncstatus	integer NOT NULL
ml_qa_messages	receiverid	varchar(128) NULL
ml_qa_messages	clientaddress	varchar(128) NOT NULL
ml_qa_messages_archive	seqno	bigint NOT NULL
ml_qa_messages_archive	msgid	varchar(128) NOT NULL
ml_qa_messages_archive	address	varchar(255) NOT NULL
ml_qa_messages_archive	client	varchar(128) NOT NULL
ml_qa_messages_archive	originator	varchar(128) NULL
ml_qa_messages_archive	status	integer NOT NULL
ml_qa_messages_archive	statustime	timestamp NOT NULL
ml_qa_messages_archive	expires	timestamp NULL
ml_qa_messages_archive	priority	integer NOT NULL
ml_qa_messages_archive	props	long binary NULL
ml_qa_messages_archive	kind	integer NOT NULL
ml_qa_messages_archive	content	long binary NULL
ml_qa_messages_archive	contentsize	bigint NOT NULL
ml_qa_messages_archive	syncstatus	integer NOT NULL
ml_qa_messages_archive	receiverid	varchar(128) NULL
ml_qa_messages_archive	clientaddress	varchar(128) NOT NULL
ml_table_scripts	version	varchar(128) NOT NULL
ml_table_scripts	event	varchar(128) NOT NULL
ml_table_scripts	table_name	varchar(128) NOT NULL
ml_table_scripts	script_language	varchar(128) NOT NULL
ml_table_scripts	script	text NOT NULL