ORGANIZATION - Table

WaDE [WaDE_Schema_0.25.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: ORGANIZATION

Organization responsible for the data reported.

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	ORGANIZATION_ID	Integer				A unique identifier assigned to the organization. Identifiers would be managed centrally by ????
	ORGANIZATION_NAME	VarChar(20)				Name corresponding to unique organization ID (i.e. Utah Division of Water Resources)
	PURVUE_DESC	Text				A description of the purview of the agency (i.e. water rights, consumptive use, etc.)
	FIRST_NAME	VarChar(20)				First name of a person.
	MIDDLE_INITIAL	VarChar(20)				Middle Initial of a person.
	LAST_NAME	VarChar(20)				Last name of a person.
	TITLE	VarChar(50)				Title of the contact person.
	EMAILE	VarChar(50)				Email address data
	PHONE	VarChar(20)				Telephone Number data
	PHONE_EXT	VarChar(20)				Telephone number extension
	FAX	VarChar(50)				Fax Number
	ADDRESS	VarChar(50)				Mailing Address
	ADDRESS_EXT	VarChar(50)				Additional Address Information
	CITY	VarChar(20)				City or Locality Name
	STATE	VarChar(20)				State USPS Code (i.e. KS)
	COUNTRY	VarChar(20)				Country Name
	ZIPCODE	VarChar(20)
	WADE_URL	VarChar(50)

Indexes

(none)

Foreign Keys

(none)

Triggers

(none)

Used in Diagrams