manufacturer
EntityType Dependent
Logical Entity Name manufacturer
Definition
Note

manufacturer Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
mf_db_site(PK)(FK) CHAR(16) NO
mf_db_id(PK)(FK) INTEGER NO
manuf_code(PK) INTEGER NO
user_tag_ident VARCHAR(254) YES
manuf_trade_name VARCHAR(254) NO
company_name VARCHAR(254) NO
phys_addr VARCHAR(254) YES
phys_city_name VARCHAR(254) YES
phys_state_abbr VARCHAR(254) YES
phys_postal_code VARCHAR(254) YES
phys_country_abbr VARCHAR(254) YES
mail_addr VARCHAR(254) YES
mail_city_name VARCHAR(254) YES
mail_state_abbr VARCHAR(254) YES
mail_postal_code VARCHAR(254) YES
mail_country_abbr VARCHAR(254) YES
us_ph_number VARCHAR(254) YES
int_ph_country_no VARCHAR(254) YES
int_ph_city_no VARCHAR(254) YES
int_ph_local_no VARCHAR(254) YES
us_fax_number VARCHAR(254) YES
int_fax_country_no VARCHAR(254) YES
int_fax_city_no VARCHAR(254) YES
int_fax_local_no VARCHAR(254) YES
business_desc VARCHAR(254) YES
primary_sic VARCHAR(254) YES
gmt_last_updated DATETIME YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) INTEGER YES
rstat_type_code(FK) SMALLINT YES
lc_alt_sic1 VARCHAR(254) YES
lc_alt_sic2 VARCHAR(254) YES

manufacturer Keys
Key Name Key Type Keys
PK__manufacturer__0BC6C43E PrimaryKey mf_db_site,mf_db_id,manuf_code

manufacturer Relationships
Parent Entity Child Entity Type Foreign Keys
row_status_type manufacturer Non-Identifying rstat_type_code
site_database manufacturer Identifying mf_db_site,mf_db_id
site_database manufacturer Non-Identifying last_upd_db_site,last_upd_db_id
manufacturer asset Non-Identifying mf_db_site,mf_db_id,manuf_code
manufacturer model Non-Identifying mf_db_site,mf_db_id,manuf_code