manufacturer
EntityType Dependent
Logical Entity Name manufacturer
Default Table 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) NUMERIC(10, 0) NO
manuf_code(PK) NUMERIC(10, 0) NO
user_tag_ident NVARCHAR(254) YES
manuf_trade_name NVARCHAR(254) NO
company_name NVARCHAR(254) NO
phys_addr NVARCHAR(254) YES
phys_city_name NVARCHAR(254) YES
phys_state_abbr NVARCHAR(254) YES
phys_postal_code NVARCHAR(254) YES
phys_country_abbr NVARCHAR(254) YES
mail_addr NVARCHAR(254) YES
mail_city_name NVARCHAR(254) YES
mail_state_abbr NVARCHAR(254) YES
mail_postal_code NVARCHAR(254) YES
mail_country_abbr NVARCHAR(254) YES
us_ph_number NVARCHAR(254) YES
int_ph_country_no NVARCHAR(254) YES
int_ph_city_no NVARCHAR(254) YES
int_ph_local_no NVARCHAR(254) YES
us_fax_number NVARCHAR(254) YES
int_fax_country_no NVARCHAR(254) YES
int_fax_city_no NVARCHAR(254) YES
int_fax_local_no NVARCHAR(254) YES
business_desc NVARCHAR(254) YES
primary_sic NVARCHAR(254) YES
gmt_last_updated TIMESTAMP/DATE YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) NUMERIC(10, 0) YES
rstat_type_code(FK) NUMERIC(5, 0) YES
lc_alt_sic1 NVARCHAR(254) YES
lc_alt_sic2 NVARCHAR(254) YES

manufacturer Keys
Key Name Key Type Keys
PK8 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

manufacturer Attachments
Name Datatype Value Override Default Value Description