| Table tbl_access_policies | ||
|---|---|---|
| access_policy_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| value | varchar( 512 ) NOT NULL | |
| Indexes | ||
| pk_tbl_access_policies primary key | ( access_policy_id) | |
| idx_access_policies_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| fk_tbl_access_policies_1 | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_address_locations | ||
|---|---|---|
| address_id | int8 NOT NULL | |
| location_id | int8 NOT NULL | |
| Indexes | ||
| pk_tbl_address_locations primary key | ( address_id) | |
| idx_address_locations_location_id_1 | ( location_id) | |
| Foreign Keys | ||
| fk_tbl_address_locations_1 | ( location_id ) ref tbl_locations ( location_id ) | |
| Table tbl_address_parts | ||
|---|---|---|
| address_part_id | int8 NOT NULL | |
| physical_address_id | int8 NOT NULL | |
| value | varchar( 512 ) NOT NULL | |
| type | varchar( 512 ) NOT NULL | |
| Indexes | ||
| pk_tbl_address_parts primary key | ( address_part_id) | |
| idx_address_parts_physical_address_id_1 | ( physical_address_id) | |
| Foreign Keys | ||
| fk_tbl_address_parts_1 | ( physical_address_id ) ref tbl_physical_addresses ( physical_address_id ) | |
| Table tbl_authorities | ||
|---|---|---|
| identifier | varchar( 1024 ) NOT NULL | |
| identifier_type | varchar( 512 ) | |
| name | varchar( 1024 ) | |
| uri | varchar( 512 ) | |
| Indexes | ||
| tbl_authority_pkey primary key | ( identifier) | |
| Table tbl_citation_contributors | ||
|---|---|---|
| citation_contributor_id | bigserial( 19 ) NOT NULL DEFO 'nextval('dba.tbl_citation_contributors_citation_contributor_id_seq'::regclass)' | |
| citation_info_id | int8 | |
| seq | int8 | |
| Indexes | ||
| tbl_citation_contributors_pkey primary key | ( citation_contributor_id) | |
| idx_citation_contributors_citation_info_id_1 | ( citation_info_id) | |
| Foreign Keys | ||
| ref_tbl_citation_contributors_to_tbl_citation_information | ( citation_info_id ) ref tbl_citation_information ( citation_info_id ) | |
| Table tbl_citation_dates | ||
|---|---|---|
| metadata_date_id | bigserial( 19 ) NOT NULL DEFO nextval('dba.tbl_citation_dates_metadata_date_id_seq'::regclass) | |
| citation_info_id | int8 | |
| date | varchar( 512 ) | |
| type | varchar( 512 ) | |
| Indexes | ||
| tbl_citation_dates_pkey primary key | ( metadata_date_id) | |
| idx_citation_dates_citation_info_id_1 | ( citation_info_id) | |
| Foreign Keys | ||
| ref_tbl_citation_metadata_dates_to_tbl_citation_information | ( citation_info_id ) ref tbl_citation_information ( citation_info_id ) | |
| Table tbl_citation_information | ||
|---|---|---|
| citation_info_id | bigserial( 19 ) NOT NULL DEFO 'nextval('dba.tbl_citation_information_citation_info_id_seq'::regclass)' | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| style | varchar( 512 ) | |
| full_citation | varchar( 512 ) | |
| metadata_identifier | varchar( 512 ) | |
| metadata_type | varchar( 512 ) | |
| metadata_title | varchar( 512 ) | |
| metadata_edition | varchar( 512 ) | |
| metadata_place_published | varchar( 512 ) | |
| metadata_url | varchar( 512 ) | |
| metadata_context | varchar( 512 ) | |
| Indexes | ||
| tbl_citation_information_pkey primary key | ( citation_info_id) | |
| idx_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| ref_tbl_citation_information_to_tbl_registry_objects | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_complex_names | ||
|---|---|---|
| complex_name_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| date_from | timestamptz | |
| date_to | timestamptz | |
| type | varchar( 512 ) | |
| lang | varchar( 64 ) | |
| Indexes | ||
| pk_tbl_complex_names primary key | ( complex_name_id) | |
| idx_complex_names_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| fk_tbl_complex_names_1 | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_coverage | ||
|---|---|---|
| coverage_id | bigserial( 19 ) NOT NULL DEFO 'nextval('dba.tbl_coverage_coverage_id_seq'::regclass)' | |
| registry_object_key | varchar( 512 ) | |
| Indexes | ||
| tbl_coverage_pkey primary key | ( coverage_id) | |
| idx_coverage_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| ref_tbl_coverage_to_tbl_registry_objects | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_data_source_logs | ||
|---|---|---|
| event_id | int8 NOT NULL | |
| data_source_key | varchar( 255 ) NOT NULL | |
| created_when | timestamptz DEFO 'now()' | |
| created_who | varchar( 255 ) | |
| request_ip | varchar( 24 ) | |
| event_description | varchar( 2000 ) | |
| Indexes | ||
| pk_tbl_data_source_logs primary key | ( event_id) | |
| idx_data_source_logs_data_source_key_1 | ( data_source_key) | |
| Foreign Keys | ||
| fk_tbl_data_source_logs_1 | ( data_source_key ) ref tbl_data_sources ( data_source_key ) | |
| Table tbl_data_sources | ||
|---|---|---|
| data_source_key | varchar( 255 ) NOT NULL | |
| provider_type | varchar( 64 ) | |
| uri | varchar( 255 ) | |
| title | varchar( 255 ) | |
| contact_name | varchar( 128 ) | |
| contact_email | varchar( 128 ) | |
| notes | varchar( 2000 ) | |
| record_owner | varchar( 255 ) | |
| created_when | timestamptz DEFO 'now()' | |
| created_who | varchar( 255 ) | |
| modified_when | timestamptz DEFO 'now()' | |
| modified_who | varchar( 255 ) | |
| harvest_method | varchar( 64 ) | |
| oai_set | varchar( 255 ) | |
| harvest_date | timestamptz | |
| harvest_frequency | varchar( 64 ) | |
| isil_value | varchar | |
| push_to_nla | bool DEFO 'false' | |
| allow_reverse_internal_links | bool NOT NULL DEFO true | |
| allow_reverse_external_links | bool NOT NULL DEFO false | |
| Indexes | ||
| pk_tbl_data_sources primary key | ( data_source_key) | |
| Table tbl_descriptions | ||
|---|---|---|
| description_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| value | varchar( 4000 ) NOT NULL | |
| type | varchar( 512 ) NOT NULL | |
| lang | varchar( 64 ) | |
| Indexes | ||
| pk_tbl_descriptions primary key | ( description_id) | |
| idx_descriptions_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| fk_tbl_descriptions_1 | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_draft_registry_objects Objects created using the Regiser My Data tool are stored in this table. These objects are draft versions of registry objects, but needn't be valid during the draft stage. For this reason, we keep them in a serialised RIF-CS format until they have been previewed, validated and "approved" by the user. | ||
|---|---|---|
| draft_owner | varchar( 255 ) NOT NULL DEFO ''SYSTEM'::character varying' | |
| draft_key | varchar( 512 ) NOT NULL | |
| class | varchar( 32 ) NOT NULL | |
| registry_object_group | varchar( 512 ) | |
| registry_object_type | varchar( 32 ) | |
| registry_object_data_source | varchar( 255 ) | |
| date_created | timestamptz DEFO 'now()' | |
| date_modified | timestamptz DEFO now() | |
| rifcs | text | |
| registry_object_title | varchar( 512 ) NOT NULL DEFO ''(no name/title)'::character varying' | |
| Indexes | ||
| pk_tbl_rmd_draft_objects primary key | ( draft_owner, draft_key) | |
| Foreign Keys | ||
| fk_tbl_rmd_draft_objects_1 | ( registry_object_data_source ) ref tbl_data_sources ( data_source_key ) | |
| Table tbl_electronic_address_args | ||
|---|---|---|
| electronic_address_arg_id | int8 NOT NULL | |
| electronic_address_id | int8 NOT NULL | |
| name | varchar( 512 ) NOT NULL | |
| required | bool NOT NULL | |
| type | varchar( 512 ) NOT NULL | |
| use | varchar( 512 ) | |
| Indexes | ||
| pk_tbl_electronic_address_args primary key | ( electronic_address_arg_id) | |
| idx_electronic_address_args_electronic_address_id_1 | ( electronic_address_id) | |
| Foreign Keys | ||
| fk_tbl_electronic_address_args_1 | ( electronic_address_id ) ref tbl_electronic_addresses ( electronic_address_id ) | |
| Table tbl_electronic_addresses | ||
|---|---|---|
| electronic_address_id | int8 NOT NULL | |
| address_id | int8 NOT NULL | |
| value | varchar( 512 ) NOT NULL | |
| type | varchar( 512 ) | |
| Indexes | ||
| pk_tbl_electronic_adresses primary key | ( electronic_address_id) | |
| idx_electronic_addresses_address_id_1 | ( address_id) | |
| Foreign Keys | ||
| fk_tbl_electronic_addresses_1 | ( address_id ) ref tbl_address_locations ( address_id ) | |
| Table tbl_harvest_requests | ||
|---|---|---|
| harvest_request_id | varchar( 40 ) NOT NULL | |
| data_source_key | varchar( 255 ) NOT NULL | |
| created_when | timestamptz DEFO 'now()' | |
| created_who | varchar( 255 ) | |
| modified_when | timestamptz DEFO 'now()' | |
| modified_who | varchar( 255 ) | |
| status | varchar( 2000 ) | |
| harvester_base_uri | varchar( 255 ) | |
| response_target_uri | varchar( 255 ) | |
| source_uri | varchar( 255 ) | |
| method | varchar( 64 ) | |
| mode | varchar( 64 ) | |
| harvester_ip | varchar( 24 ) | |
| oai_set | varchar( 255 ) | |
| harvest_date | timestamptz | |
| harvest_frequency | varchar( 64 ) | |
| Indexes | ||
| pk_tbl_harvest_requests primary key | ( harvest_request_id) | |
| idx_harvest_requests_data_source_key_1 | ( data_source_key) | |
| Foreign Keys | ||
| fk_tbl_harvest_requests_1 | ( data_source_key ) ref tbl_data_sources ( data_source_key ) | |
| Table tbl_identifiers | ||
|---|---|---|
| identifier_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| value | varchar( 512 ) NOT NULL | |
| type | varchar( 512 ) NOT NULL | |
| Indexes | ||
| pk_tbl_identifiers primary key | ( identifier_id) | |
| idx_identifiers_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| fk_tbl_identifiers_1 | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_ids | ||
|---|---|---|
| column_identifier | varchar( 128 ) NOT NULL | |
| next_id | int8 NOT NULL | |
| Indexes | ||
| pk_tbl_ids primary key | ( column_identifier) | |
| Table tbl_locations | ||
|---|---|---|
| location_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| date_from | timestamptz | |
| date_to | timestamptz | |
| type | varchar( 512 ) | |
| Indexes | ||
| pk_tbl_locations primary key | ( location_id) | |
| idx_locations_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| fk_tbl_locations_1 | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_name_parts | ||
|---|---|---|
| name_part_id | int8 NOT NULL | |
| complex_name_id | int8 | |
| value | varchar( 512 ) NOT NULL | |
| type | varchar( 512 ) | |
| citation_contributor_id | int8 | |
| Indexes | ||
| pk_tbl_name_parts primary key | ( name_part_id) | |
| idx_name_parts_citation_contributor_id_1 | ( citation_contributor_id) | |
| idx_name_parts_complex_name_id_1 | ( complex_name_id) | |
| Foreign Keys | ||
| ref_tbl_name_parts_to_tbl_citation_contributors | ( citation_contributor_id ) ref tbl_citation_contributors ( citation_contributor_id ) | |
| fk_tbl_name_parts_1 | ( complex_name_id ) ref tbl_complex_names ( complex_name_id ) | |
| Table tbl_oai_rt_complete_list_records | ||
|---|---|---|
| record_number | int4 NOT NULL | |
| complete_list_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| Indexes | ||
| pk_tbl_oai_rt_complete_list_records primary key | ( record_number, complete_list_id) | |
| idx_oai_rt_complete_list_records_complete_list_id_1 | ( complete_list_id) | |
| Foreign Keys | ||
| fk_tbl_oai_rt_complete_list_records_1 | ( complete_list_id ) ref tbl_oai_rt_complete_lists ( complete_list_id ) | |
| Table tbl_oai_rt_complete_lists | ||
|---|---|---|
| complete_list_id | int8 NOT NULL | |
| Indexes | ||
| pk_tbl_oai_rt_complete_lists primary key | ( complete_list_id) | |
| Table tbl_oai_rt_resumption_tokens | ||
|---|---|---|
| resumption_token_id | varchar( 40 ) NOT NULL | |
| complete_list_id | int8 NOT NULL | |
| status | int4 NOT NULL | |
| first_record_number | int4 NOT NULL | |
| complete_list_size | int4 NOT NULL | |
| expiration_date | timestamptz NOT NULL | |
| metadata_prefix | varchar( 64 ) NOT NULL | |
| Indexes | ||
| pk_tbl_oai_rt_resumption_tokens primary key | ( resumption_token_id) | |
| idx_oai_rt_resumption_tokens_complete_list_id_1 | ( complete_list_id) | |
| Foreign Keys | ||
| fk_tbl_oai_rt_resumption_tokens_1 | ( complete_list_id ) ref tbl_oai_rt_complete_lists ( complete_list_id ) | |
| Table tbl_physical_addresses | ||
|---|---|---|
| physical_address_id | int8 NOT NULL | |
| address_id | int8 NOT NULL | |
| type | varchar( 512 ) | |
| lang | varchar( 64 ) | |
| Indexes | ||
| pk_tbl_physical_addresses primary key | ( physical_address_id) | |
| idx_physical_addresses_address_id_1 | ( address_id) | |
| Foreign Keys | ||
| fk_tbl_physical_addresses_1 | ( address_id ) ref tbl_address_locations ( address_id ) | |
| Table tbl_raw_records | ||
|---|---|---|
| registry_object_key | varchar( 512 ) NOT NULL | |
| data_source | varchar( 255 ) NOT NULL | |
| created_when | timestamptz NOT NULL | |
| created_who | varchar( 255 ) | |
| rifcs_fragment | text | |
| Indexes | ||
| pk_raw_record_data primary key | ( registry_object_key, data_source, created_when) | |
| Table tbl_registry_objects | ||
|---|---|---|
| registry_object_key | varchar( 512 ) NOT NULL | |
| data_source_key | varchar( 255 ) NOT NULL | |
| object_group | varchar( 512 ) NOT NULL | |
| date_modified | timestamptz | |
| identifiers_search_index | tsvector | |
| subjects_search_index | tsvector | |
| names_search_index | tsvector | |
| descriptions_search_index | tsvector | |
| registry_object_class | varchar( 512 ) NOT NULL | |
| type | varchar( 32 ) NOT NULL | |
| created_when | timestamptz DEFO 'now()' | |
| created_who | varchar( 255 ) DEFO 'SYSTEM'::character varying | |
| originating_source | varchar( 512 ) NOT NULL | |
| originating_source_type | varchar( 512 ) | |
| date_accessioned | timestamptz | |
| status | bpchar NOT NULL DEFO 'APPROVED'::bpchar | |
| record_owner | varchar( 255 ) NOT NULL DEFO ''SYSTEM'::character varying' | |
| status_modified_when | timestamptz DEFO 'now()' | |
| status_modified_who | varchar( 255 ) DEFO 'SYSTEM'::character varying | |
| schema_version | varchar( 20 ) | |
| list_title | varchar( 512 ) | |
| display_title | varchar( 512 ) | |
| Indexes | ||
| pk_tbl_registry_objects primary key | ( registry_object_key) | |
| idx_registry_objects_data_source_key_1 | ( data_source_key) | |
| registry_object_description_search_idx | ( descriptions_search_index) | |
| registry_object_identifier_search_idx | ( identifiers_search_index) | |
| registry_object_name_search_idx | ( names_search_index) | |
| registry_object_subject_search_idx | ( subjects_search_index) | |
| Foreign Keys | ||
| fk_tbl_registry_objects_1 | ( data_source_key ) ref tbl_data_sources ( data_source_key ) | |
| fk_tbl_registry_objects_status | ( status ) ref tbl_statuses ( status ) | |
| Table tbl_registry_objects_statistics | ||
|---|---|---|
| count_date | date NOT NULL | |
| registry_object_count | int8 | |
| collection_object_count | int8 | |
| party_object_count | int8 | |
| activity_object_count | int8 | |
| service_object_count | int8 | |
| trusted_sw_agreements_count | int8 | |
| Indexes | ||
| pk primary key | ( count_date) | |
| Table tbl_related_info | ||
|---|---|---|
| related_info_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| value | varchar( 512 ) | |
| notes | varchar( 512 ) | |
| title | varchar( 512 ) | |
| identifier_type | varchar( 512 ) | |
| identifier | varchar( 512 ) | |
| info_type | varchar( 64 ) | |
| Indexes | ||
| pk_tbl_related_info primary key | ( related_info_id) | |
| idx_related_info_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| fk_tbl_related_info_1 | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_related_objects | ||
|---|---|---|
| relation_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| related_registry_object_key | varchar( 512 ) NOT NULL | |
| Indexes | ||
| pk_tbl_related_objects primary key | ( relation_id) | |
| idx_related_objects_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| fk_tbl_related_objects_1 | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_relation_descriptions | ||
|---|---|---|
| relation_description_id | int8 NOT NULL | |
| relation_id | int8 NOT NULL | |
| description | varchar( 512 ) | |
| type | varchar( 512 ) NOT NULL | |
| lang | varchar( 64 ) | |
| url | varchar( 512 ) | |
| Indexes | ||
| pk_tbl_relation_descriptions primary key | ( relation_description_id) | |
| idx_relation_descriptions_relation_id_1 | ( relation_id) | |
| Foreign Keys | ||
| fk_tbl_relation_descriptions_1 | ( relation_id ) ref tbl_related_objects ( relation_id ) | |
| Table tbl_spatial_extents | ||
|---|---|---|
| spatial_extents_id | int8 NOT NULL | |
| spatial_location_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| bound_box | box NOT NULL | |
| Indexes | ||
| pk_tbl_spatial_extents primary key | ( spatial_extents_id) | |
| Foreign Keys | ||
| fk_tbl_spatial_extents_1 | ( spatial_location_id ) ref tbl_spatial_locations ( spatial_location_id ) | |
| Table tbl_spatial_locations | ||
|---|---|---|
| spatial_location_id | int8 NOT NULL | |
| location_id | int8 | |
| value | varchar( 4000 ) NOT NULL | |
| type | varchar( 512 ) NOT NULL | |
| lang | varchar( 64 ) | |
| coverage_id | int8 | |
| Indexes | ||
| pk_tbl_spatial_locations primary key | ( spatial_location_id) | |
| idx_spacial_locations_coverage_id_1 | ( coverage_id) | |
| idx_spatial_locations_location_id_1 | ( location_id) | |
| Foreign Keys | ||
| ref_tbl_spatial_locations_to_tbl_coverage | ( coverage_id ) ref tbl_coverage ( coverage_id ) | |
| fk_tbl_spatial_locations_1 | ( location_id ) ref tbl_locations ( location_id ) | |
| Table tbl_statuses | ||
|---|---|---|
| status | bpchar NOT NULL | |
| Indexes | ||
| pk_tbl_statuses primary key | ( status) | |
| Table tbl_subjects | ||
|---|---|---|
| subject_id | int8 NOT NULL | |
| registry_object_key | varchar( 512 ) NOT NULL | |
| value | varchar( 512 ) NOT NULL | |
| type | varchar( 512 ) NOT NULL | |
| lang | varchar( 64 ) | |
| Indexes | ||
| pk_tbl_subjects primary key | ( subject_id) | |
| idx_subjects_registry_object_key_1 | ( registry_object_key) | |
| Foreign Keys | ||
| fk_tbl_subjects_1 | ( registry_object_key ) ref tbl_registry_objects ( registry_object_key ) | |
| Table tbl_temporal_coverage | ||
|---|---|---|
| temporal_coverage_id | bigserial( 19 ) NOT NULL DEFO 'nextval('dba.tbl_temporal_coverage_temporal_coverage_id_seq'::regclass)' | |
| coverage_id | int8 | |
| Indexes | ||
| tbl_temporal_coverage_pkey primary key | ( temporal_coverage_id) | |
| idx_temporal_coverage_coverage_id_1 | ( coverage_id) | |
| Foreign Keys | ||
| ref_tbl_temporal_coverage_to_tbl_coverage | ( coverage_id ) ref tbl_coverage ( coverage_id ) | |
| Table tbl_temporal_coverage_dates | ||
|---|---|---|
| coverage_date_id | bigserial( 19 ) NOT NULL DEFO nextval('dba.tbl_temporal_coverage_dates_coverage_date_id_seq'::regclass) | |
| temporal_coverage_id | int8 | |
| type | varchar( 512 ) | |
| date_format | varchar( 512 ) | |
| value | varchar( 512 ) | |
| timestamp_value | timestamptz | |
| Indexes | ||
| tbl_temporal_coverage_dates_pkey primary key | ( coverage_date_id) | |
| idx_temporal_coverage_dates_temporal_coverage_id_1 | ( temporal_coverage_id) | |
| Foreign Keys | ||
| ref_tbl_temporal_coverage_dates_to_tbl_temporal_coverage | ( temporal_coverage_id ) ref tbl_temporal_coverage ( temporal_coverage_id ) | |
| Table tbl_temporal_coverage_text | ||
|---|---|---|
| coverage_text_id | bigserial( 19 ) NOT NULL DEFO nextval('dba.tbl_temporal_coverage_text_coverage_text_id_seq'::regclass) | |
| temporal_coverage_id | int8 | |
| value | varchar( 512 ) | |
| Indexes | ||
| tbl_temporal_coverage_text_pkey primary key | ( coverage_text_id) | |
| idx_temporal_coverage_text_temporal_coverage_id_1 | ( temporal_coverage_id) | |
| Foreign Keys | ||
| ref_tbl_temporal_coverage_text_to_tbl_temporal_coverage | ( temporal_coverage_id ) ref tbl_temporal_coverage ( temporal_coverage_id ) | |
| Table tbl_terms | ||
|---|---|---|
| identifier | varchar( 1024 ) NOT NULL | |
| vocabulary_identifier | varchar( 1024 ) NOT NULL | |
| identifier_type | varchar( 512 ) | |
| qualifier | varchar( 512 ) | |
| name | varchar( 512 ) | |
| description | varchar( 1024 ) | |
| description_type | varchar( 512 ) | |
| parent_term_identifier | varchar( 1024 ) | |
| type | varchar( 512 ) NOT NULL | |
| relationtype | varchar( 512 ) | |
| vocabpath | varchar( 1024 ) | |
| lang | varchar( 512 ) | |
| Indexes | ||
| pk_tbl_terms primary key | ( identifier, vocabulary_identifier) | |
| idx_terms_identifier | ( identifier) | |
| Foreign Keys | ||
| ref_tbl_terms_vocabulary_identifier | ( vocabulary_identifier ) ref tbl_vocabularies ( identifier ) | |
| Table tbl_vocabularies | ||
|---|---|---|
| identifier | varchar( 1024 ) NOT NULL | |
| identifier_type | varchar( 512 ) | |
| version | varchar( 512 ) NOT NULL | |
| name | varchar( 1024 ) NOT NULL | |
| name_type | varchar( 512 ) NOT NULL | |
| description | varchar( 1024 ) NOT NULL | |
| source | varchar( 512 ) | |
| authority_identifier | varchar( 512 ) | |
| Indexes | ||
| tbl_vocabularies_pkey primary key | ( identifier) | |
| Foreign Keys | ||
| ref_tbl_vocablularies_authority_identifier | ( authority_identifier ) ref tbl_authorities ( identifier ) | |