Website Database ER Diagram
Use immediately

Website Database ER Diagram

locations

id

name

code

parent_id

centroid_sref_system

centroid_geom

boundary_geom

extermal_key

comment

deleted

Indesxes

user_tokens

id

users_id

expires

created

user_agent

token

Indesxes

locations_attributes

id

caption

data_type

validation_rules

temlist_rules

multi_value

public

deleted

Indesxes

users

id

person_id

openid_url

home_entered_sref

home_entered_sref_system

home_geom

Interests

location_name

email_visble

view_commom_names

core_role_id

forgotten_password_key

 deleted

Indesxes

core_roles

id

title

deleted

Indexes

surveys

id

title

description

owner_id

website_id

deleted

Indesxes

people

id

first_name

surname

initials

email_address

website_url

address

title_id

deleted

Indesxes

titles

id

title

deleted

Indexes

occurrence_comments

id

comment

occurence_id

email_address

confirmation_key

deleted

person_name

Indexes

location_attributes_values

id

location_id

location_attrbutes_id

text_value

int_value

date_start_value

date_end_value

date_type_value

deleted

Indexes

occurrences

id

sample_id

determiner_id

taxa_taxon_list

website_id

extermal_key

comment

deleted

reccord_status

verified_by

verified_on

Indexes

occurrence_images

id

occourrence_id

path

caption

deleted

Indexes

sample_attribute_value

id

sample_id

sample_attribute_id

text_value

float_value

int_value

date_start_value

date_end_value

date_type_value

deleted

Indexes

occurrence_attribute_value

id

occourrence_id

occourrence_attribute_id

text_value

float_value

int_value

date_start_value

date_end_value

date_type_value

deleted

Indexes

occurrence_attributes

id

capation

data_type

validation_rules

termlist_id

multi-value

public

deleted

Indexes

sample_attributes

id

caption

data_type

applies_to_location

validation_rules

termlsts_id

multi_value

Indexes

system

id

version

name

repository

relesitory

Indesxes

taxa

id

taxon

taxon_group_id

language_id

extermal_kay

authority

search_code

scientific

image_path

description

Indesxes

taxon_lists

id

title

desription

website_id

parent_id

deleted

Indesxes

taxon_groups

id

title

deleted

Indesxes

languages

id

iso

language

deleted

Indesxes

taxon_meaning

id

Indesxes

taxa_taxon_lists

id

taxon_list_id

taxon_id

parent_id

taxon_meaning_id

preferred

taxonmic_sort_order

image_path

description

Indexes

terms

id

term

language_id

Indesxes

termlists_tems

id

terms_id

termlists_id

meaning_id

parent_id

prefetted

sort_order

Indesxes

termlists

id

term

description

website_id

parent_id

deleted

Indesxes

meaning

id

Indesxes

samples

id

survey_id

location_id

date_start

date_end

date_type

entered_sref

entered_sref_system

geom

location_name

external_key

comment

deleted

recorder_names

Indesxes

entrycards_occurrence_attributes

id

occourrence_id

occourrence_attribute_id

Indexes

entrycard_sample_attributes

id

entrycard_id

sample_attribute_id

Indexes

entrycards

id

title

description

website_id

Indexes

48
0
1
publish time: 2021-06-04
Captain O Captain

Website database entity-relationship (ER) diagram shows the entities like occurrences, occurrence_attribute_value, titles, location_attributes_values, taxon_lists, and others. It is a high-level data model that defines data elements and their relationship for a specified software system. These ER diagrams for an elaborative website database can be created using EdrawMax or EdrawMax Online as it has several predefined templates that make the designing very easy. These entities have attributes like location_id, location_attributes_id, text_value, int_value, data_start_value, date_end_value, deleted, website_id, parent_id, and others. As the below ER diagram illustrates, an affiliation exists between various qualities of an element. A relationship between two properties demonstrates that the estimations of the related characteristics are associated.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
22
0
0
DILSHAN SACHINDRA