DROP TABLE authority;
CREATE TABLE authority
 (
	authority_id			Long Integer (4), 
	authority			Text (100), 
	note			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE bibliography;
CREATE TABLE bibliography
 (
	biblio_id			Long Integer (4), 
	title			Text (255), 
	publication_id			Long Integer (4), 
	volume			Text (30), 
	page			Text (30), 
	date			Text (50), 
	note			Text (255), 
	uncoded_pub			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE category;
CREATE TABLE category
 (
	category_id			Long Integer (4), 
	table			Text (255), 
	column			Text (255), 
	sequence			Long Integer (4), 
	code			Text (255), 
	name			Text (255), 
	short_name			Text (50), 
	description			Text (50), 
	note			Text (50)

);
-- CREATE ANY INDEXES ...

DROP TABLE char_set;
CREATE TABLE char_set
 (
	character_id			Long Integer (4), 
	category_id			Long Integer (4), 
	name			Text (50), 
	short_name			Text (50), 
	value_type			Text (50), 
	value_unit			Text (50), 
	value_min			Text (50), 
	value_max			Text (50), 
	note			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE common_name;
CREATE TABLE common_name
 (
	taxon_id			Long Integer (4), 
	category_id			Long Integer (4), 
	sequence			Long Integer (4), 
	name			Text (50), 
	pronunciation			Text (50), 
	note			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE hu_card;
CREATE TABLE hu_card
 (
	card_no			Long Integer (4), 
	family_id			Long Integer (4), 
	genus_id			Long Integer (4), 
	card_taxon			Text (100), 
	card_authority			Text (100), 
	correct_taxon			Text (100), 
	correct_authority			Text (100), 
	chinese			Text (30), 
	pinyin			Text (50), 
	note			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE hu_card_note;
CREATE TABLE hu_card_note
 (
	card_no			Long Integer (4), 
	note_date			Long Integer (4), 
	card_taxon			Text (100), 
	card_authority			Text (100), 
	correct_taxon			Text (100), 
	correct_authority			Text (100), 
	chinese			Text (50), 
	pinyin			Text (100), 
	synonym			Text (255), 
	bibliography			Text (255), 
	distribution			Text (255), 
	specimen			Text (255), 
	other_text			Text (255), 
	note			Text (255), 
	note_by			Text (20), 
	email			Text (50), 
	ip			Text (50)

);
-- CREATE ANY INDEXES ...

DROP TABLE institution;
CREATE TABLE institution
 (
	institution_id			Long Integer (4), 
	name			Text (80), 
	acronym			Text (20), 
	short_name			Text (50), 
	category_id			Long Integer (4), 
	host_inst_id			Long Integer (4), 
	director_id			Long Integer (4), 
	address_line1			Text (80), 
	address_line2			Text (80), 
	city			Text (255), 
	state			Text (40), 
	country			Text (40), 
	postal_code			Text (20), 
	phone			Text (40), 
	fax			Text (40), 
	www			Text (80), 
	note			Text (50)

);
-- CREATE ANY INDEXES ...

DROP TABLE loc_contain;
CREATE TABLE loc_contain
 (
	locality_id			Long Integer (4), 
	higher_id			Long Integer (4), 
	note			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE loc_name;
CREATE TABLE loc_name
 (
	loc_name_id			Long Integer (4), 
	locality_id			Long Integer (4), 
	category_id			Long Integer (4), 
	sequence			Long Integer (4), 
	name			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE locality;
CREATE TABLE locality
 (
	locality_id			Long Integer (4), 
	category_id			Long Integer (4), 
	name			Text (100), 
	higher_name			Text (50), 
	status			Text (10), 
	valid_date			Text (20), 
	elevation_min			Long Integer (4), 
	elevation_max			Long Integer (4), 
	latitude_min			Long Integer (4), 
	latitude_max			Long Integer (4), 
	longitude_min			Long Integer (4), 
	longitude_max			Long Integer (4), 
	climate_type_id			Long Integer (4), 
	note			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE person;
CREATE TABLE person
 (
	person_id			Long Integer (4), 
	last_name			Text (35), 
	first_name			Text (30), 
	middle_name			Text (40), 
	prefix			Text (10), 
	suffix			Text (10), 
	birth_date			Text (20), 
	death_date			Text (20), 
	country			Text (60), 
	interest			Text (60), 
	authority			Text (1), 
	collector			Text (1), 
	note			Text (50)

);
-- CREATE ANY INDEXES ...

DROP TABLE person_name;
CREATE TABLE person_name
 (
	person_id			Long Integer (4), 
	category_id			Long Integer (4), 
	name			Text (80)

);
-- CREATE ANY INDEXES ...

DROP TABLE publication;
CREATE TABLE publication
 (
	publication_id			Long Integer (4), 
	title			Text (255), 
	abbreviation			Text (10), 
	date			Text (20), 
	insititution_id			Long Integer (4), 
	category_id			Long Integer (4), 
	isbn			Text (50), 
	issn			Text (50), 
	call_no			Text (50), 
	bph_no			Text (50), 
	tl2_no			Text (50), 
	tl2_author			Text (50), 
	correct_pub_id			Text (50), 
	succeed_pub_id			Text (50), 
	note			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE taxon;
CREATE TABLE taxon
 (
	taxon_id			Long Integer (4), 
	name			Text (70), 
	authority_id			Long Integer (4), 
	rank_id			Long Integer (4), 
	name_status			Text (2), 
	publication_id			Long Integer (4), 
	biblio_id			Long Integer (4), 
	taxon_page			Text (50), 
	taxon_date			Text (100), 
	annotation			Text (50), 
	tropicos_id			Text (15), 
	note			Text (50)

);
-- CREATE ANY INDEXES ...

DROP TABLE authority_person;
CREATE TABLE authority_person
 (
	authority_id			Long Integer (4), 
	sequence			Long Integer (4), 
	preceding			Text (3), 
	person_id			Long Integer (4), 
	person_name			Text (50)

);
-- CREATE ANY INDEXES ...

DROP TABLE char_state;
CREATE TABLE char_state
 (
	character_id			Long Integer (4), 
	publication_id			Long Integer (4), 
	value			Text (50), 
	note			Text (50)

);
-- CREATE ANY INDEXES ...

DROP TABLE pub_title;
CREATE TABLE pub_title
 (
	publication_id			Long Integer (4), 
	category_id			Long Integer (4), 
	title			Text (255), 
	note			Text (255)

);
-- CREATE ANY INDEXES ...

DROP TABLE _sect_subg;
CREATE TABLE _sect_subg
 (
	Field1			Long Integer (4), 
	Field2			Text (50), 
	Field3			Long Integer (4), 
	Field4			Long Integer (4), 
	Field6			Long Integer (4), 
	Field8			Text (50), 
	Field9			Long Integer (4), 
	Field10			Text (50), 
	Field11			Long Integer (4)

);
-- CREATE ANY INDEXES ...



-- CREATE ANY Relationships ...