Table BDNA_PUBLISH.dbo.CAT_MANUFACTURER
Manufacturer information table

 Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ID float 8
CAT_CPU_PRODUCT.MANUFACTURER_ID FK0_CAT_CPU_PRODUCT R
CAT_HARDWARE_MODEL.MANUFACTURER_ID FK0_CAT_HARDWARE_MODEL R
CAT_HARDWARE_PRODUCT.MANUFACTURER_ID FK0_CAT_HARDWARE_PRODUCT R
CAT_HW_MODEL_PROFILE.MANUFACTURER_ID FK0_CAT_HW_MODEL_PROFILE R
CAT_SOFTWARE.MANUFACTURER_ID FK0_CAT_SOFTWARE R
CAT_SOFTWARE_RELEASE.MANUFACTURER_ID FK0_CAT_SOFTWARE_RELEASE R
CAT_SUPPORT_POLICY.MANUFACTURER_ID FK0_CAT_SUPPORT_POLICY R
CAT_MANUFACTURER table's unique identifier
LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
LABEL varchar 2000  √  null Manufacturer name (as obtained from the official website), minus the legal entity
LEGAL varchar 64  √  null Legal entity of the company (e.g. Corporation, Limited, etc.)
REVENUE float 8  √  null The latest annual revenue (in millions of USD)
SYMBOL varchar 16  √  null The company's stock/ticker symbol (if it's publicly traded)
TIER float 8  √  null Categorization of manufacturers based on priority/importance
WEBSITE varchar 4000  √  null Manufacturer's official website
OWNER_ID float 8  √  null Manufacturer owner's unique identifier
DATE_ACQUIRED varchar 60  √  null The date the manufacturer being acquired (if applicable)
DESCRIPTION varchar 1024  √  null Short description of the manufacturer
PHONE varchar 64  √  null Manufacturer's telephone number
FAX varchar 64  √  null Manufacturer's fax number
CITY varchar 256  √  null The city where the manufacturer is based in (usually where the headquarter is located)
COUNTRY varchar 256  √  null The country where the manufacturer is based in (usually where the headquarter is located)
EMAIL varchar 256  √  null Manufacturer's email address

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PK_CAT_MANUFACTURER

Close relationships  within of separation: